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(148,492,548,216,217,405,515,422,423,441,455,467,485,489,490) 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