SELECT
CONCAT(group_id, ',', id) AS 'Nr. p.k.',
name AS 'Darba veids',
mesurment_id AS 'Mērvienība',
price AS 'Vienības cena. Ls (bez PVN)'
FROM job
ORDER BY group_id, id;