function: count()
SELECT count(*) as cnt FROM td_products WHERE category_id IN (1ÔłĘder=push) AND publish_flag=1