select productos.*,REPLACE(productos.singleb, 'L', 'P') AS singleballoon from productos,productoscategorias where productoscategorias.productoId=productos.id AND productoscategorias.categoriaId IN(54) 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
Please visit balloondepot.ca for more supplies and flat latex!
Quick view
Quick view