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_region59.my_taglist WHERE tid= ? ORDER BY id DESC
альтернативы - Агентство Событий