How to use GROUP_CONCAT for a column and COUNT(*)?

1 vote

2 answers

1638 views

                          I get the ids of a query by GROUP_CONCAT.

    SELECT GROUP_CONCAT(ArticleID) FROM TagMap WHERE Tag IN(...)

How can I merge this query with a COUNT(*) group by

    SELECT ArticleID,COUNT(*) FROM TagMap WHERE Tag IN(...) GROUP BY ArticleID

to get GROUP_CONCAT(ArticleID) with order of COUNT(*)?

In other words, in the first query, I want to make GROUP_CONCAT(ArticleID) order by the number of tags found for each ArticleID.

Asked by Googlebot (4551 rep)

Aug 29, 2020, 01:26 AM
Last activity: Dec 15, 2021, 09:16 PM

How to use GROUP_CONCAT for a column and COUNT(*)?

Related Questions