Shop
sql_products=>SELECT p.id as product_id, p.productName, p.*, cl0.id as brand_id, cl0.category_name as brand_name,
cl2.id as top_category_id, cl2.level2_name as top_category_name,
cl1.id as category_id,cl1.level1_name as category_name, cl1.dollar as dollar_charge
FROM products p
JOIN categories_level1 cl1 ON p.productCategory=cl1.id
JOIN categories_level2 cl2 ON cl1.level2_parent=cl2.id
JOIN categories_level0 cl0 ON cl1.level1_parent_category=cl0.id
WHERE cl0.active=1 AND cl0.member_display in (1) AND cl0.member_display in (1) AND outofstock in (0) AND cl2.id=57 AND gender>-1 ORDER BY p.id DESC count_products=>4