0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

/*WITH AggregatedTags AS (
SELECT pt.postid ,
           STRING_AGG(t.tagname, ',') WITHIN GROUP (ORDER BY t.id asc) AS tag_combination
    FROM posttags pt
    join tags t on t.id = pt.tagid
    WHERE 1=1
    --and pt.postid in (72, 79)
    GROUP BY pt.postid
)
    SELECT tag_combination,
           COUNT(*) AS combination_count
    FROM AggregatedTags
    GROUP BY tag_combination
    order by combination_count desc
*/

--select * from tags where tagname='python'

select count(*) from tags where tagname='css,html'

view current version

edited aug 14

created aug 14 jon.doe45409