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,%' ORDER BY updated_date DESC, inventory_name ASC LIMIT 0, 12
Welcome to Smile BasketProduct-listing-Csearch :: smilebasket.com
