Q&A about the site for Joomla! administrators, users, developers and designers
SELECT tags.TagName ,COUNT(PostId) AS total_unique_posts FROM ( SELECT Id ,TagName FROM Tags WHERE LOWER(TagName) LIKE '%snowflake%' OR LOWER(TagName) LIKE '%airflow%' ) AS tags LEFT JOIN PostTags pt ON tags.id = pt.TagId GROUP BY tags.TagName ORDER BY total_unique_posts DESC