SELECT * , COUNT(`ca_number`) AS AC FROM `cmp_theme` LEFT JOIN `cmp_article` ON `ct_number` = `ca_tid` WHERE `ct_aid` = '16' GROUP BY `ct_number` ORDER BY `ct_date` DESC