select `m`.`id` AS `Nr. p.k.`,`m`.`name` AS `Materiālu veids`,`u`.`name` AS `Mērvienība`,`m`.`amount` AS `Plānotais apjoms 48 mēn.` from (`materialwork`.`material` `m` left join `materialwork`.`unit` `u` on(`m`.`unit_id` = `u`.`id`)) order by `m`.`id`