SELECT count(*) as total, id, type FROM content_manager WHERE main = '1' LIMIT 1
In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'siorto_db.content_manager.id'; this is incompatible with sql_mode=only_full_group_by