|
|
|
Home The Web Links
Expression #15 of SELECT list is not in GROUP BY clause and contains nonaggregated column \'unmjgfi_kidsandco.a.id\' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SQL=SELECT *, COUNT(a.id) AS numlinks FROM kidsnco_categories AS cc\nLEFT JOIN kidsnco_weblinks AS a ON a.catid = cc.id\nWHERE a.published=\'1\' AND section=\'com_weblinks\' AND cc.published=\'1\' AND cc.access <= \'0\'\nGROUP BY cc.id\nORDER BY cc.ordering
|