Q&A about the site for Joomla! administrators, users, developers and designers
/*SELECT COUNT(Id), Tags FROM PostsWithDeleted GROUP BY Tags HAVING Tags = '%Airflow%' or Tags = '%Snowflake%'*/ /*select Tags, COUNT(Id) FROM PostsWithDeleted GROUP BY Tags HAVING LOWER(Tags) LIKE '%airflow%' or LOWER(Tags) LIKE '%snowflake%'*/ SELECT TagName, count(DISTINCT PostId) AS count_tags FROM PostTags pt INNER JOIN Tags t ON pt.TagId = t.Id GROUP BY TagName HAVING LOWER(TagName) LIKE '%airflow%' OR LOWER(TagName) LIKE '%snowflake%' ORDER BY count(DISTINCT PostId) DESC