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 = 134 AND outofstock=0 AND gender>-1 ORDER BY productPrice ASC
1 Year Shop Renewal
- Enjoy Partner pricing
- Earn retail commission
- Earn binary commission
*Note: Online Shop can only renew 30 days prior and 30 days after its annual renewal date (launch date) as noted in the Back Office Dashboard under "...