Blog - keywords
1.6.4.+, PostgreSQL8.1

ERROR: column "t.id" must appear in the GROUP BY clause or be used in an aggregate function

SELECT t.*, COUNT(DISTINCT bt.id) as ct FROM mdl_tags as t, mdl_blog_tag_instance as bt, mdl_post as p WHERE t.id = bt.tagid AND p.id = bt.entryid AND (p.publishstate = 'site' or p.publishstate='public') AND bt.timemodified > 7776000 GROUP BY bt.tagid ORDER BY ct DESC, t.text ASC LIMIT 20