URI: index.php?option=com_newsletter&Itemid=51&task=newsletter Message: 'dogcompe_new.m.menutype' isn't in GROUP BY
SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt
FROM elx_menu AS m
LEFT JOIN elx_menu AS p ON p.parent = m.id
WHERE m.menutype='topmenu' AND m.published='1' AND m.access IN (29)
AND ((m.language IS NULL) OR (m.language LIKE '%russian%'))
GROUP BY m.id ORDER BY m.parent, m.ordering
