SELECT SUM(CASE WHEN aid > 0 THEN 1 ELSE 0 END) AS dd1, SUM(CASE WHEN freeid > 0 THEN 1 ELSE 0 END) AS dd2, SUM(CASE WHEN varnameid > 0 THEN 1 ELSE 0 END) AS dd3, SUM(CASE WHEN typeid > 0 THEN 1 ELSE 0 END) AS dd4 FROM https_qqdzh.my_taglist WHERE tid= ? ORDER BY id DESC 挖角台 - 事件代理館