# большое количество колонок смотрим со стороны евентов
SELECT *
FROM
  (SELECT backend."id" AS "backend_id",
          backend.id AS "backend_abc",
          to_timestamp(to_char(backend."CreateDate"::TIMESTAMP WITH TIME ZONE AT TIME ZONE 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::TIMESTAMP WITHOUT TIME ZONE AS "backend_CreateDate",
                                                                                                                                                                                                    to_timestamp(to_char(backend."UpdateDate"::TIMESTAMP WITH TIME ZONE AT TIME ZONE 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::TIMESTAMP WITHOUT TIME ZONE AS "backend_UpdateDate",
 ............,
                                                                                                                                                                                                                                                                                                                                                                                              objects.id AS "xyz",

     ,......,

     (SELECT MAX(CASE
                     WHEN "ColumnName" = 'НоваяКолонка1_ad0dff7879' THEN "ColumnValue"
                     ELSE NULL
                 END)
      FROM backendext
      WHERE "BackendId" = backend.id
      GROUP BY "BackendId") AS "backend_НоваяКолонка1_ad0dff7879",
                                                                                                                                                                                                                                                                                                                                                                                              screens."Name" AS "screens_Name",
                                                                                                                                                                                                                                                                                                                                                                                              objects."InviteStatus" AS "objects_InviteStatus",
,......,                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                objects."Testval" AS "objects_Testval",
    ,......,
     (SELECT MAX(CASE
                     WHEN "ColumnName" = 'НоваяКолонка1_357624f4a4' THEN "ColumnValue"
                     ELSE NULL
                 END)
      FROM backendext
      WHERE "BackendId" = backend.id
      GROUP BY "BackendId") AS "backend_НоваяКолонка1_357624f4a4"
   FROM backend
   LEFT JOIN objects ON objects.id = backend."ObjectId"
   LEFT JOIN statuses ON statuses.id = backend."StatusId"
   LEFT JOIN users ON users.id = backend."Responsibleid"
   LEFT JOIN screens ON screens.id = backend."ScreenId") x
WHERE "backend_ApplicationId" = 672
  AND ("backend_НоваяКолонка1_ad0dff7879"='123'
       AND "screens_Name"='Home'
       AND "backend_UpdateDate"='24.05.2018 18:17:58'
       AND "objects_Email"='nzulfigarov@gmail.com')