f
SELECT SQL_CALC_FOUND_ROWS p.*, c.category_name FROM product_master p LEFT JOIN category_master c ON p.category_id=c.category_id WHERE p.is_deleted ='0' AND p.is_disabled ='0' AND category_id_tree like '%,1,%' AND age = '%all%' AND gifting = 'gifting' AND sex = 'man' ORDER BY updated_date DESC, inventory_name ASC LIMIT 0, 12
Welcome to Smile BasketProduct-listing-Csearch :: smilebasket.com
