Poshmoda
  • Gifts For Him
  • Authentic Gifts
  • Get $20 Per Friend
SELECT count(prod_id) as total_rows FROM (`tb_products`) WHERE prod_site_id LIKE '%|38|%' AND prod_categories LIKE '%|1|%' AND prod_new_arrival = 1 AND prod_status = 0 AND prod_number IN ('cnbag2746','cnbag2740','M40781','M48814','M94413','M40592','cnbag2157','M40906','M41208','M41207','M4062G') AND prod_warehouse = 1
SELECT count(prod_id) as total_rows FROM (`tb_products`) WHERE prod_site_id LIKE '%|38|%' AND prod_categories LIKE '%|1|%' AND prod_new_arrival = 1 AND prod_status = 0 AND prod_warehouse = 1
SELECT count(prod_id) as total_rows FROM (`tb_products`) WHERE prod_site_id LIKE '%|38|%' AND prod_categories LIKE '%|1|%' AND prod_best_seller = 1 AND prod_status = 0 AND prod_warehouse = 1

SELECT count(prod_id) as total_rows FROM (`tb_products`) WHERE prod_site_id LIKE '%|38|%' AND prod_categories LIKE '%|1|%' AND ( prod_clearance > 0 OR (prod_s_clearance > 0 AND prod_s_clearance_qty > 0)) AND prod_status = 0 AND prod_warehouse = 1