meteoracle

This may only be useful in particular circumstances (most obviously when using ExpressionEngine), but nonetheless it was useful to me, so here it is:

I have a number of Weblogs set up for managing the content on a website. The majority of these have been assigned to a ‘Static Content’ field group, and it’s these weblogs that I intend to use as menu links, with the individual posts in the section as sub-menu links.

Other weblogs have other specific Field Groups for their specific content, i.e. File Downloads and News Articles.

So to do this, I used a query to list only the Weblogs that use the ‘Static Content’ Field Group, and here it is:

SELECT
exp_weblogs.blog_name,
exp_weblogs.blog_title
FROM
exp_field_groups
Inner Join exp_weblogs ON exp_weblogs.field_group = exp_field_groups.group_id
WHERE
exp_field_groups.group_name = 'Static Content'

Short and sweet, and I hope it’s useful to somebody.