select pod,
(case polya when 'Наши цены' then znach else null end) as "Наши цены",
(case polya when 'Наименование лота' then znach else null end) as "Наименование лота",
(case polya when 'Заказчик' then znach else null end) as "Заказчик"
from zayav

CREATE OR ALTER VIEW ZAYAV(
    POD,
    ZNACH,
    NAZVA)
AS
select dd.name, task_attribute_values.view_value_short, mf.name from task
      left join employertaskids tt on task.id=tt.id_task
      left join employer ee on  tt.id_employer=ee.id
      left join department dd on ee.id_department=dd.id
      left join task_attribute_values on task.id=task_attribute_values.id_task
      left join meta_field mf on task_attribute_values.id_metafield=mf.id
      where (startdate between '01.09.2014' and '10.12.2014')
      and task_attribute_values.id_metafield in(133,134,136,137,146) and (dd.id between '1' and '20')
      group by dd.name, task_attribute_values.view_value_short,  mf.name
;