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(383,68,461,503,151,154,155,167,296,188,295,197,199,201,202,204,205,208,209,211,227,274,234,260,261,262,263,267,268,271,273,276,277,278,279,280,282,284,285,287,289,377,294,297,298,300,303,308,309,310,313,315,318,321,493,324,326,327,328,331,501,502,337,340,341,343,510,511,498,352,509,531,532,533,499,387,414,471,437,454,456,459,466,486,491) 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