- Розширений пошук документів за наступними умовами:
- розділи: []
- ключові слова містить: провокації
Warning: oci_parse() expects parameter 1 to be resource, boolean given in /ora/www/siteclass.php on line 5266
Warning: oci_execute() expects parameter 1 to be resource, null given in /ora/www/siteclass.php on line 5267
Warning: oci_fetch_array() expects parameter 1 to be resource, null given in /ora/www/siteclass.php on line 5268
Warning: oci_parse() expects parameter 1 to be resource, boolean given in /ora/www/siteclass.php on line 4286
Warning: oci_execute() expects parameter 1 to be resource, null given in /ora/www/siteclass.php on line 4288
select count(1) RC from (select all_t.* ,ROW_NUMBER() OVER(ORDER BY 1) RN from ( select distinct main.* from (select t_res.AUTHORS,t_id.id,t_id.zag,t_id.DATES,t_id.SORT_DATES ,t_id.ID_FOND_L,t_id.ID_FOND_CLT_L, t_id.ID_TOM_L,t_id.UP_ID_VYD_DK,t_id.EK24_STEXT,t_id.EK23_SPRM from ( select doc.id ID, LISTAGG(pers.name, ' , ') WITHIN GROUP(ORDER BY DOC.ID) AUTHORS FROM GALSLIB.WPU_VDA_APERS_TBL_L pers_tb, GALSLIB.WPU_VDA_APERS_L pers, GALSLIB.WPU_VARH_DK_SPR_L DOC WHERE pers.ID = pers_tb.ID_DA_L AND DOC.ID = pers_tb.ID_DK_SPR_L group by doc.id, doc.ek23_date, doc.ek23_zagolovok) t_res, ( SELECT doc.id ID, doc.ek23_zagolovok , decode(doc.ek23_date, null,EK23_NDATE ,to_char(doc.ek23_date,'DD.MM.YYYY') ) DATES, doc.ek23_zagolovok ZAG, doc.SORT_DATES, doc.ID_FOND_L, doc.ID_FOND_CLT_L, doc.ID_TOM_L, doc.UP_ID_VYD_DK, doc.EK24_STEXT, doc.EK23_SPRM FROM GALSLIB.WPU_VARH_DK_SPR_L DOC WHERE DOC.ID != 0 group by DOC.ID, doc.ek23_date, doc.ek23_zagolovok,EK23_NDATE,doc.SORT_DATES,doc.ID_FOND_L,doc.ID_FOND_CLT_L,doc.ID_TOM_L,doc.UP_ID_VYD_DK,doc.EK24_STEXT,doc.EK23_SPRM ) t_id where t_id.id = t_res.ID(+) ) main , ( select distinct nay.ID_DK_SPR_L, t_w_id.ParId ID_ARUBR_L from galslib.WPU_VDA_ARUBR_TBL_L nay, ( select t2.ID ID , t.id ParId from galslib.WPU_VDA_ARUBR_L t, galslib.WPU_VDA_ARUBR_L t2 where t2.LINEAGE like t.LINEAGE || '%' ) t_w_id where t_w_id.Id = nay.ID_ARUBR_L ) TB ,( select TBL.NAME NAME_KEY, P.ID_DK_SPR_L from GALSLIB.WPU_VDA_KLS_L TBL, GALSLIB.WPU_VDA_KLS_TBL_L P where p.ID_DA_L = tbl.ID ) tKey1 where 1=1 and TB.ID_DK_SPR_L = main.ID and tb.ID_ARUBR_L = 148 and ( ( upper(trim(tKey1.NAME_KEY)) like upper('%' || trim('провокації ') || '%')) and tKey1.ID_DK_SPR_L = main.ID ) ) all_t)
Warning: oci_fetch_array() expects parameter 1 to be resource, null given in /ora/www/siteclass.php on line 4291
Результатів не знайдено
