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
использовании - Агентство Событий