Database error: [Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ritex.c.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT i.*, c.title as category_title, c.uri as category_uri FROM items i LEFT JOIN categories_meta c ON ( c.category_id = i.category_id AND c.language='lv' ) WHERE i.id <> '1078' AND i.category_id='334' GROUP BY i.id ORDER BY abs(i.id - 1078) LIMIT 3