click to filter by price or to select a different category
select productos.*,REPLACE(productos.singleb, 'L', 'P') AS singleballoon from productos,productoscategorias where productoscategorias.productoId=productos.id AND productoscategorias.categoriaId IN(225,248,249,246,146,247,395,250,252,253,255,256,258,259) and productos.visible='SI' and productos.producto<>'' AND CAST(precio AS UNSIGNED) >=0 AND CAST(precio AS UNSIGNED) <= 99999 order by singleballoon ASC, productos.posicion desc