SELECT * FROM items i
LEFT JOIN groups g ON g.group_id = i.group_id
ORDER BY i.group_id DESC