====================================================================================================
QUERY: SELECT
D.ID F0,
D.UID UID,
D.CASE_NUMBER NUM,
cast(('
'||D.CASE_NUMBER||'') as varchar(4096)) F1,
to_char(E.event_time, 'HH24:MI') F2,
cast((select U1_GET_CRIMINALS_INFO (D.ID,1,5)) as varchar(4096)) F3,
case when E.EVENT_RESULT is null then ' '
else cast((select name from catalogcontent where contentid=E.EVENT_RESULT and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(4096)) end F4,
coalesce((select name from judges where groupcontentid=D.judge and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1), ' ') F5,
case when E.ROOM_NUMBER is NULL then ' ' else cast((select name from catalogcontent where contentid=E.ROOM_NUMBER and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(50)) end F6,
(select name from catalogcontent where contentid=E.EVENT_NAME and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) F8,
case when D.CASE_TYPE = 50780001 then D.CASE_TYPE
else 0 end CASE_TYPE,
1540006 delo_id,
case when doc.documenttext1 is null then case when doc.web_link1 is null then '0' else '1' end else '1' end has_doc
FROM U1_EVENT E JOIN U1_CASE D ON (E.case_id = D.ID)
left join u1_document doc on (d.uid=doc.case_uid)
Where
(D.VNKOD='42RS0031') AND
(D.NUM_BUILD=1) AND
/* оптимизация */
(E.VNKOD='42RS0031') AND
(E.NUM_BUILD=1) AND
(E.event_date='04.07.2026') and
(E.IS_HEARING=1) UNION SELECT
D.ID F0,
D.UID UID,
D.CASE_NUMBER NUM,
cast(('
'||D.CASE_NUMBER||'') as varchar(4096)) F1,
to_char(E.event_time, 'HH24:MI') F2,
cast((select U2_GET_CRIMINALS_INFO(D.ID, 1, 5)) || coalesce('
Суд (судебный участок) первой инстанции: ' || (select name from catalogcontent where contentid=D.COURT_I and vnkod=D.VNKOD and num_build=D.NUM_BUILD LIMIT 1), '
Судья (мировой судья) первой инстанции: ' || (select name from catalogcontent where contentid=D.JUDGE_I and vnkod=D.VNKOD and num_build=D.NUM_BUILD LIMIT 1), '') || coalesce('
Номер дела в первой инстанции: ' || D.CASE_NUMBER_I, '') as varchar(4096)) F3,
case when D.RESULT is NULL then
case when E.EVENT_RESULT is NULL then ' '
else cast((select name from catalogcontent where contentid=E.EVENT_RESULT and VNKOD=E.VNKOD and NUM_BUILD=E.NUM_BUILD LIMIT 1) as varchar(4096)) end
else
cast((select name from catalogcontent where contentid=D.RESULT and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(4096))
end F4,
coalesce((select name from judges where groupcontentid=D.judge and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1), ' ') F5,
case when E.ROOM_NUMBER is NULL then ' ' else cast((select name from catalogcontent where contentid=E.ROOM_NUMBER and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(50)) end F6,
'' F8,
0 CASE_TYPE,
4 delo_id,
case when doc.documenttext1 is null then case when doc.web_link1 is null then '0' else '1' end else '1' end has_doc
FROM U2_EVENT E JOIN U2_CASE D ON (E.case_id = D.ID)
left join u2_document doc on (d.uid=doc.case_uid)
Where
(E.VNKOD='42RS0031') AND
(E.NUM_BUILD=1) AND
(E.event_date='04.07.2026') and
(E.IS_HEARING=1) UNION SELECT
D.ID F0,
D.UID UID,
D.CASE_NUMBER NUM,
cast(('
'||D.CASE_NUMBER||'') as varchar(4096)) F1 ,
to_char(E.event_time, 'HH24:MI') F2,
cast(case when D.CATEGORY is null then ' ' else 'КАТЕГОРИЯ: '||(select gxx_get_category(D.CATEGORY, D.VNKOD, D.NUM_BUILD, ' → '))||'
' end || coalesce((SELECT g1_parts_on_case (D.ID, 1)), '<Информация скрыта>') as varchar(4096)) F3,
case when E.EVENT_RESULT is null then ' ' else
cast((select name from catalogcontent where contentid=E.EVENT_RESULT and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(4096)) end F4,
coalesce((select name from judges where groupcontentid=D.judge and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1), ' ') F5,
case when E.ROOM_NUMBER is NULL then ' ' else cast((select name from catalogcontent where contentid=E.ROOM_NUMBER and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(50)) end F6,
(select name from catalogcontent where contentid=E.EVENT_NAME and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) F8,
case when D.CASE_TYPE in (50520004, 50520054) then 50520004
else 0 end CASE_TYPE,
1540005 DELO_ID,
case when doc.documenttext1 is null then case when doc.web_link1 is null then '0' else '1' end else '1' end has_doc
FROM G1_CASE D inner JOIN G1_EVENT E
ON ( D.ID= E.case_id )
left join g1_document doc on (d.uid=doc.case_uid)
WHERE
(D.VNKOD='42RS0031') AND
(D.NUM_BUILD=1) AND
/* оптимизация */
(E.VNKOD='42RS0031') AND
(E.NUM_BUILD=1) AND
(E.event_date='04.07.2026') and
(E.IS_HEARING=1) UNION SELECT
D.ID F0,
D.UID UID,
D.CASE_NUMBER NUM,
cast(('
'||D.CASE_NUMBER||'') as varchar(4096)) F1 ,
to_char(E.event_time, 'HH24:MI') F2,
cast(case when D.M_SUB_TYPE is not null then 'КАТЕГОРИЯ: ' || (select name from catalogcontent where contentid=D.M_SUB_TYPE and vnkod=D.VNKOD and num_build=D.NUM_BUILD LIMIT 1) || '
' else case when D.CATEGORY is null then '' else 'КАТЕГОРИЯ: '|| (select gxx_get_category(D.CATEGORY, D.VNKOD, D.NUM_BUILD, ' → ')) ||'
' end end || coalesce((SELECT g2_parts_on_case(D.ID, 1)), '<Информация скрыта>') || coalesce('
Суд (судебный участок) первой инстанции: ' || (select name from catalogcontent where contentid=D.COURT_I and vnkod=D.VNKOD and num_build=D.NUM_BUILD LIMIT 1), '
Судья (мировой судья) первой инстанции: ' || (select name from catalogcontent where contentid=D.JUDGE_I and vnkod=D.VNKOD and num_build=D.NUM_BUILD LIMIT 1), '') || coalesce('
Номер дела в первой инстанции: ' || D.CASE_NUMBER_I, '') as varchar(4096)) F3,
case when d.result is null then
case when E.EVENT_RESULT is NULL then ' '
else cast((select name from catalogcontent where contentid=E.EVENT_RESULT and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(4096)) end
else case when D.RESULT is NULL then ' '
else cast((select name from catalogcontent where contentid=D.RESULT and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(4096)) end end f4,
coalesce((select name from judges where groupcontentid=D.judge and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1), ' ') F5,
case when E.ROOM_NUMBER is NULL then ' ' else cast((select name from catalogcontent where contentid=E.ROOM_NUMBER and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(50)) end F6,
upper((select name from catalogcontent where contentid=E.EVENT_NAME and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1)) F8,
0 CASE_TYPE,
5 DELO_ID,
case when doc.documenttext1 is null then case when doc.web_link1 is null then '0' else '1' end else '1' end has_doc
FROM G2_CASE D inner JOIN G2_EVENT E
ON (D.ID= E.case_id )
left join g2_document doc on (d.uid=doc.case_uid)
WHERE
(D.VNKOD='42RS0031') AND
(D.NUM_BUILD=1) AND
(E.event_date='04.07.2026') and
(E.IS_HEARING=1) UNION SELECT
D.ID F0,
D.UID UID,
D.CASE_NUMBER NUM,
cast(('
'||D.CASE_NUMBER||'') as varchar(4096)) F1 ,
to_char(E.event_time, 'HH24:MI') F2,
cast(case when D.CATEGORY is null then ' ' else 'КАТЕГОРИЯ: '||(select gxx_get_category(D.CATEGORY, D.VNKOD, D.NUM_BUILD, ' → '))||'
' end || coalesce((SELECT p1_parts_on_case (D.ID, 1)), '<Информация скрыта>') as varchar(4096)) F3,
case when E.EVENT_RESULT is null then ' ' else
cast((select name from catalogcontent where contentid=E.EVENT_RESULT and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(4096)) end F4,
coalesce((select name from judges where groupcontentid=D.judge and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1), ' ') F5,
case when E.ROOM_NUMBER is NULL then ' ' else cast((select name from catalogcontent where contentid=E.ROOM_NUMBER and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(50)) end F6,
(select name from catalogcontent where contentid=E.EVENT_NAME and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) F8,
0 CASE_TYPE,
41 DELO_ID,
case when doc.documenttext1 is null then case when doc.web_link1 is null then '0' else '1' end else '1' end has_doc
FROM P1_CASE D inner JOIN P1_EVENT E
ON ( D.ID= E.case_id )
left join p1_document doc on (d.uid=doc.case_uid)
WHERE
(D.VNKOD='42RS0031') AND
(D.NUM_BUILD=1) AND
/* оптимизация */
(E.VNKOD='42RS0031') AND
(E.NUM_BUILD=1) AND
(E.event_date='04.07.2026') and
(E.IS_HEARING=1) UNION SELECT
D.ID F0,
D.UID UID,
D.CASE_NUMBER NUM,
cast(('
'||D.CASE_NUMBER||'') as varchar(4096)) F1 ,
to_char(E.event_time, 'HH24:MI') F2,
cast(case when D.M_SUB_TYPE is not null then 'КАТЕГОРИЯ: ' || (select name from catalogcontent where contentid=D.M_SUB_TYPE and vnkod=D.VNKOD and num_build=D.NUM_BUILD LIMIT 1) || '
' else case when D.CATEGORY is null then '' else 'КАТЕГОРИЯ: '|| (select gxx_get_category(D.CATEGORY, D.VNKOD, D.NUM_BUILD, ' → ')) ||'
' end end || coalesce((SELECT p2_parts_on_case(D.ID, 1)), '<Информация скрыта>') || coalesce('
Суд (судебный участок) первой инстанции: ' || (select name from catalogcontent where contentid=D.COURT_I and vnkod=D.VNKOD and num_build=D.NUM_BUILD LIMIT 1), '
Судья (мировой судья) первой инстанции: ' || (select name from catalogcontent where contentid=D.JUDGE_I and vnkod=D.VNKOD and num_build=D.NUM_BUILD LIMIT 1), '') || coalesce('
Номер дела в первой инстанции: ' || D.CASE_NUMBER_I, '') as varchar(4096)) F3,
case when d.result is null then
case when E.EVENT_RESULT is NULL then ' '
else cast((select name from catalogcontent where contentid=E.EVENT_RESULT and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(4096)) end
else case when D.RESULT is NULL then ' '
else cast((select name from catalogcontent where contentid=D.RESULT and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(4096)) end end f4,
coalesce((select name from judges where groupcontentid=D.judge and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1), ' ') F5,
case when E.ROOM_NUMBER is NULL then ' ' else cast((select name from catalogcontent where contentid=E.ROOM_NUMBER and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(50)) end F6,
upper((select name from catalogcontent where contentid=E.EVENT_NAME and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1)) F8,
0 CASE_TYPE,
42 DELO_ID,
case when doc.documenttext1 is null then case when doc.web_link1 is null then '0' else '1' end else '1' end has_doc
FROM P2_CASE D inner JOIN P2_EVENT E
ON (D.ID= E.case_id )
left join p2_document doc on (d.uid=doc.case_uid)
WHERE
(D.VNKOD='42RS0031') AND
(D.NUM_BUILD=1) AND
(E.event_date='04.07.2026') and
(E.IS_HEARING=1) UNION select
D.ID F0,
D.UID UID,
D.CASE_NUMBER NUM,
cast(('
'||D.case_number||'') as varchar(4096)) F1 ,
to_char(e.event_time, 'HH24:MI') F2,
cast('ПРАВОНАРУШЕНИЕ: ' || (select adm_get_persons(D.id)) as varchar(4096)) F3,
case when e.EVENT_RESULT is null then ' ' else
cast((select name from catalogcontent where contentid=e.EVENT_RESULT and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(4096)) end F4,
coalesce((select name from judges where groupcontentid=D.judge and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1), ' ') F5,
case when E.ROOM_NUMBER is NULL then ' ' else cast((select name from catalogcontent where contentid=E.ROOM_NUMBER and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(50)) end F6,
(select name from catalogcontent where contentid=e.EVENT_NAME and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) F8,
0 case_type,
1500001 DELO_ID,
case when doc.documenttext1 is null then case when doc.web_link1 is null then '0' else '1' end else '1' end has_doc
from
adm_case D left join adm_document doc on (d.uid=doc.case_uid),
adm_event e
where
(D.VNKOD='42RS0031') AND
(D.NUM_BUILD=1) AND
/* оптимизация */
(E.VNKOD='42RS0031') AND
(E.NUM_BUILD=1) AND
D.id = e.case_id and
(E.IS_HEARING=1) and
e.event_date = '04.07.2026' UNION select
D.ID F0,
D.UID UID,
D.CASE_NUMBER NUM,
cast(('
'||D.case_number||'') as varchar(4096)) F1 ,
to_char(e.event_time, 'HH24:MI') F2,
cast('ПРАВОНАРУШЕНИЕ: ' || (select adm1_get_persons(D.id)) as varchar(4096)) F3,
case when e.EVENT_RESULT is null then ' ' else
cast((select name from catalogcontent where contentid=e.EVENT_RESULT and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(4096)) end F4,
coalesce((select name from judges where groupcontentid=D.judge and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1), ' ') F5,
case when E.ROOM_NUMBER is NULL then ' ' else cast((select name from catalogcontent where contentid=E.ROOM_NUMBER and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(50)) end F6,
(select name from catalogcontent where contentid=e.EVENT_NAME and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) F8,
0 case_type,
1502001 DELO_ID,
case when doc.documenttext1 is null then case when doc.web_link1 is null then '0' else '1' end else '1' end has_doc
from
adm1_case D left join adm1_document doc on (d.uid=doc.case_uid),
adm1_event e
where
(D.VNKOD='42RS0031') AND
(D.NUM_BUILD=1) AND
D.id = e.case_id and
/* оптимизация */
(E.VNKOD='42RS0031') AND
(E.NUM_BUILD=1) AND
(E.IS_HEARING=1)
and
e.event_date = '04.07.2026' UNION select
D.ID F0,
D.UID UID,
D.CASE_NUMBER NUM,
cast(('
'||D.case_number||'') as varchar(4096)) F1 ,
to_char(E.event_time, 'HH24:MI') F2,
cast((select M_GET_CRIMINALS_INFO (D.ID)) as varchar(4096)) F3,
case when E.EVENT_RESULT is null then ' ' else
cast((select name from catalogcontent where contentid=E.EVENT_RESULT and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(4096)) end F4,
coalesce((select name from judges where groupcontentid=D.judge and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1), ' ') F5,
case when E.ROOM_NUMBER is NULL then ' ' else cast((select name from catalogcontent where contentid=E.ROOM_NUMBER and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) as varchar(50)) end F6,
(select name from catalogcontent where contentid=E.EVENT_NAME and VNKOD=D.VNKOD and NUM_BUILD=D.NUM_BUILD LIMIT 1) F8,
0 case_type,
1610001 delo_id,
case when doc.documenttext1 is null then case when doc.web_link1 is null then '0' else '1' end else '1' end has_doc
FROM M_EVENT E JOIN M_CASE D ON (E.case_id = D.ID)
left join m_document doc on (d.uid=doc.case_uid)
where
(D.VNKOD='42RS0031') AND
(D.NUM_BUILD=1) AND
D.id = E.case_id and
/* оптимизация */
(E.VNKOD='42RS0031') AND
(E.NUM_BUILD=1) AND
(E.IS_HEARING=1)
and
E.event_date = '04.07.2026' order by 12,11,5
ERROR: ВАЖНО: закрытие подключения по команде администратора
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
====================================================================================================
ВАЖНО: закрытие подключения по команде администратора
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
