Something
public text v1 · immutableSELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_categories AS c ON i.catid=c.id
LEFT JOIN mos_menu AS m ON m.componentid=c.id
WHERE m.type='content_blog_category'
AND m.published='1';
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_categories AS c ON i.catid=c.id
LEFT JOIN mos_menu AS m ON m.componentid=c.id
WHERE m.type='content_blog_category'
AND m.published='1';