select `w`.`id2` AS `Nr. p.k.`,`w`.`name` AS `Darba veids`,`u`.`name` AS `Mērvienība`,`w`.`amount` AS `Plānotais apjoms 48 mēn.` from (`materialwork`.`work` `w` left join `materialwork`.`unit` `u` on(`w`.`unit_id` = `u`.`id`)) where `w`.`wcategory_id` = 2 order by `w`.`id2`