Command: Query
Time: 85
State: statistics
Info: SEL ECT DISTINCT BE.SORT as SORT,BE.ID as ID,DATE_FORMAT(BE.TI MESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIM ESTAMP(BE.TIMESTAMP_ X) as TIMESTAMP_X_UNIX,BE. MODIFIED_BY as MODIFIED_BY,DATE_FOR MAT(BE.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE,UNIX_TIM ESTAMP(BE.DATE_CREAT E) as DATE_CREATE_UNIX,BE. CREATED_BY as CREATED_BY,BE.IBLOCK _ID as IBLOCK_ID,BE.IBLOCK_ SECTION_ID as IBLOCK_SECTION_ID,BE .ACTIVE as ACTIVE,IF(EXTRACT(HO UR_SECOND FR OM BE.ACTIVE_FROM)>0, DATE_FORMAT(BE.ACTIV E_FROM, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIV E_FROM, '%d.%m.%Y')) as ACTIVE_FROM,IF(EXTRA CT(HOUR_SECOND FROM BE.ACTIVE_TO)>0, DATE_FORMAT(BE.ACTIV E_TO, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIV E_TO, '%d.%m.%Y')) as ACTIVE_TO,IF(EXTRACT (HOUR_SECOND FROM BE.ACTIVE_FROM)>0, DATE_FORMAT(BE.ACTIV E_FROM, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIV E_FROM, '%d.%m.%Y')) as DATE_ACTIVE_FROM,IF( EXTRACT(HOUR_SECOND FROM BE.ACTIVE_TO)>0, DATE_FORMAT(BE.ACTIV E_TO, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIV E_TO, '%d.%m.%Y')) as DATE_ACTIVE_TO,BE.NA ME as NAME,BE.PREVIEW_PICT URE as PREVIEW_PICTURE,BE.P REVIEW_TEXT as PREVIEW_TEXT,BE.PREV IEW_TEXT_TYPE as PREVIEW_TEXT_TYPE,BE .DETAIL_PICTURE as DETAIL_PICTURE,BE.DE TAIL_TEXT as DETAIL_TEXT,BE.DETAI L_TEXT_TYPE as DETAIL_TEXT_TYPE,BE. SEARCHABLE_CONTENT as SEARCHABLE_CONTENT,B E.WF_STATUS_ID as WF_STATUS_ID,BE.WF_P ARENT_ELEMENT_ID as WF_PARENT_ELEMENT_ID ,BE.WF_LAST_HISTORY_ ID as WF_LAST_HISTORY_ID,B E.WF_NEW as WF_NEW,if (BE.WF_DATE_LOCK is null, 'green', if(DATE_ADD(BE.WF_DA TE_LOCK, interval 60 MINUTE)<now(), 'green', if(BE.WF_LOCKED_BY=0 , 'yellow', 'red'))) as LOCK_STATUS,BE.WF_LO CKED_BY as WF_LOCKED_BY,DATE_FO RMAT(BE.WF_DATE_LOCK , '%d.%m.%Y %H:%i:%s') as WF_DATE_LOCK,BE.WF_C OMMENTS as WF_COMMENTS,BE.IN_SE CTIONS as IN_SECTIONS,BE.SHOW_ COUNTER as SHOW_COUNTER,BE.SHOW _COUNTER_START as SHOW_COUNTER_START,B E.CODE as CODE,BE.TAGS as TAGS,BE.XML_ID as XML_ID,BE.XML_ID as EXTERNAL_ID,BE.TMP_I D as TMP_ID,concat('(',U. LOGIN,') ',ifnull(U.NAME,''), ' ',ifnull(U.LAST_NAME ,'')) as USER_NAME,concat('(' ,UL.LOGIN,') ',ifnull(UL.NAME,'') ,' ',ifnull(UL.LAST_NAM E,'')) as LOCKED_USER_NAME,con cat('(',UC.LOGIN,') ',ifnull(UC.NAME,'') ,' ',ifnull(UC.LAST_NAM E,'')) as CREATED_USER_NAME,L. DIR as LANG_DIR,B.LID as LID,B.IBLOCK_TYPE_ID as IBLOCK_TYPE_ID,B.COD E as IBLOCK_CODE,B.NAME as IBLOCK_NAME,B.XML_ID as IBLOCK_EXTERNAL_ID,B .DETAIL_PAGE_URL as DETAIL_PAGE_URL,B.LI ST_PAGE_URL as LIST_PAGE_URL,DATE_F ORMAT(BE.DATE_CREATE , '%Y.%m.%d') as CREATED_DATE,if(BE.W F_STATUS_ID = 1, 'Y', 'N') as BP_PUBLISHED
FR OM b_iblock B
INNER JOIN b_lang L ON B.LID=L.LID
INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID
INNER JOIN b_iblock_element_pro p_s13 FPS0 ON FPS0.IBLOCK_ELEMENT_ ID = BE.ID
LEFT JOIN b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.CODE='RASPOLOGEN IE'
LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE='TYPE_HOTEL '
LEFT JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND FP2.CODE='TYPE_BUILD '
LEFT JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID = B.ID AND FP3.CODE='EAT'
LEFT JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID = B.ID AND FP4.CODE='CHILDREN'
LEFT JOIN b_iblock_property FP5 ON FP5.IBLOCK_ID = B.ID AND FP5.CODE='SPA'
LEFT JOIN b_iblock_element_pro p_m13 FPV0 ON FPV0.IBLOCK_PROPERTY _ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ ID = BE.ID
LEFT JOIN b_iblock_element_pro p_m13 FPV1 ON FPV1.IBLOCK_PROPERTY _ID = FP1.ID AND FPV1.IBLOCK_ELEMENT_ ID = BE.ID
LEFT JOIN b_iblock_element_pro p_m13 FPV2 ON FPV2.IBLOCK_PROPERTY _ID = FP2.ID AND FPV2.IBLOCK_ELEMENT_ ID = BE.ID
LEFT JOIN b_iblock_element_pro p_m13 FPV3 ON FPV3.IBLOCK_PROPERTY _ID = FP3.ID AND FPV3.IBLOCK_ELEMENT_ ID = BE.ID
LEFT JOIN b_iblock_element_pro p_m13 FPV4 ON FPV4.IBLOCK_PROPERTY _ID = FP4.ID AND FPV4.IBLOCK_ELEMENT_ ID = BE.ID
LEFT JOIN b_iblock_element_pro p_m13 FPV5 ON FPV5.IBLOCK_PROPERTY _ID = FP5.ID AND FPV5.IBLOCK_ELEMENT_ ID = BE.ID
INNER JOIN b_iblock_property_en um FPEN0 ON FPEN0.PROPERTY_ID = 73 AND FPS0.PROPERTY_73 = FPEN0.ID
LEFT JOIN b_user U ON U.ID=BE.MODIFIED_BY
LEFT JOIN b_user UL ON UL.ID=BE.WF_LOCKED_B Y
LEFT JOIN b_user UC ON UC.ID=BE.CREATED_BY
WH ERE 1=1
AND (
((((BE.IBLOCK_ID = '13'))))
AND (
((((FPV0.VALUE_ENUM = '246'))))
)
AND (
((((FPV1.VALUE_ENUM = '250'))))
)
AND (
((((FPV2.VALUE_ENUM = '254'))))
)
AND (
((((FPV3.VALUE_ENUM = '266'))))
)
AND (
((((FPV4.VALUE_ENUM = '273'))))
)
AND (
((((FPV5.VALUE_ENUM = '356'))))
)
AND (
((((FPV5.VALUE_ENUM = '358'))))
)
AND (
((((FPV5.VALUE_ENUM = '359'))))
)
AND (
((((FPV5.VALUE_ENUM = '360'))))
)
AND (
((((FPV5.VALUE_ENUM = '361')) |