SELECT a.products_id FROM products a,products_description b, products_class d, class e WHERE b.products_tag = '1' AND a.products_id = b.products_id AND d.productcode = b.products_id AND e.classcode = d.classcode GROUP BY a.products_id ORDER BY productscore DESC, a.products_date_added DESC LIMIT 15

SELECT a.products_id FROM products a,products_description b, products_class d, class e WHERE b.products_tag = '2' AND a.products_id = b.products_id AND d.productcode = b.products_id AND e.classcode = d.classcode GROUP BY a.products_id ORDER BY productscore DESC, a.products_date_added DESC LIMIT 15

SELECT a.products_id FROM products a,products_description b, products_class d, class e WHERE b.products_tag = '3' AND a.products_id = b.products_id AND d.productcode = b.products_id AND e.classcode = d.classcode GROUP BY a.products_id ORDER BY productscore DESC, a.products_date_added DESC LIMIT 15

SELECT a.products_id FROM products a,products_description b, products_class d, class e WHERE b.products_tag = '4' AND a.products_id = b.products_id AND d.productcode = b.products_id AND e.classcode = d.classcode GROUP BY a.products_id ORDER BY productscore DESC, a.products_date_added DESC LIMIT 15


New

Best Seller

Special Offer

Bulk Offer