ShopPOSH Beauty
strSQL: SELECT p.*, c1.dollar as dollar_charge FROM products p
JOIN categories_level1 c1 on c1.id = p.productCategory
WHERE c1.level1_parent_category!=7 AND onlyrelated = 0 AND p.id>0 AND p.id != 6518 AND p.id != 6803 AND (productCategory = -999) AND outofstock=0 AND gender>-1 ORDER BY productPrice ASC