SELECT COUNT(*) AS `numrows` FROM `th_product` WHERE `status` = 1 AND `shop_id` = 34SELECT * FROM `th_product` WHERE `status` = 1 AND `shop_id` = 34 ORDER BY `sort_id` asc LIMIT 9