MULTIMEDIA ART MUSEUM, MOSCOW
MUSEUM "MOSCOW HOUSE OF PHOTOGRAPHY"
MUSEUM "MOSCOW HOUSE OF PHOTOGRAPHY"
MySQL Query Error: SELECT @rank:=el1.rank FROM ( SELECT @rank:=@rank+1 AS rank, el0.* FROM ( SELECT BE.ID as ID, BE0.NAME as PROPERTY_EXHIBITION_ID_NAME, replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace(B0.DETAIL_PAGE_URL, '#ID#', BE0.ID) , '#ELEMENT_ID#', BE0.ID) , '#CODE#', ifnull(BE0.CODE, '')) , '#ELEMENT_CODE#', ifnull(BE0.CODE, '')) , '#EXTERNAL_ID#', ifnull(BE0.XML_ID, '')) , '#IBLOCK_TYPE_ID#', B0.IBLOCK_TYPE_ID) , '#IBLOCK_ID#', BE0.IBLOCK_ID) , '#IBLOCK_CODE#', ifnull(B0.CODE, '')) , '#IBLOCK_EXTERNAL_ID#', ifnull(B0.XML_ID, '')) , '#SITE_DIR#', '/en/') , '#SERVER_NAME#', 'mamm-mdf.ru') , '#SECTION_ID#', ifnull(BE0.IBLOCK_SECTION_ID, '')) , '#SECTION_CODE#', ifnull(BS0.CODE, '')) as PROPERTY_EXHIBITION_ID_DETAIL_PAGE_URL,BE.SORT as SORT,IF(EXTRACT(HOUR_SECOND FROM BE.ACTIVE_FROM)>0, DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y')) as ACTIVE_FROM FROM 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_prop_s42 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element BE0 ON BE0.ID = FPS0.PROPERTY_94 AND ((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)) LEFT JOIN b_iblock B0 ON B0.ID = BE0.IBLOCK_ID LEFT JOIN b_iblock_section BS0 ON BS0.ID = BE0.IBLOCK_SECTION_ID WHERE 1=1 AND ( ((((B.CODE LIKE 'exhibition_calendar_en')))) AND ((((BE.ACTIVE='Y')))) AND ((((BE.ACTIVE_FROM > '2026-11-08 00:00:00')))) AND (((FPS0.PROPERTY_94 IS NOT NULL))) AND (((FPS0.PROPERTY_92 IS NOT NULL))) AND ((((FPS0.PROPERTY_91 = '356')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) ORDER BY BE.SORT asc ,BE.ACTIVE_FROM desc LIMIT 18446744073709551615 ) el0 ) el1 WHERE el1.ID = 241566 [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank, el0.* FROM ( SELECT BE.ID as ID, BE0.NAME as PROPERTY_EXHI' at line 3]
|