Error in query: SELECT t.*, i.*
FROM items2categories r
LEFT JOIN items i
ON (r.item_id = i.id)
LEFT JOIN itemsmeta t
ON (i.id = t.item_id AND t.language='en')
WHERE r.uri_common IN('air-conditioners-and-heat-pumps-for-house-and-flat')
GROUP BY r.item_id
ORDER BY i.position ASC, t.title ASC
LIMIT 1000