0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited dec 3

created dec 3 anonymous