47
MySQL Query Error: SELECT (SELECT VALUE FROM b_iblock_element_property AS BLIA WHERE BLIA.IBLOCK_PROPERTY_ID=10 AND BLIA.IBLOCK_ELEMENT_ID=IBE.ID) AS VIDEO, (SELECT VALUE FROM b_iblock_element_property AS BLIA WHERE BLIA.IBLOCK_PROPERTY_ID=9 AND BLIA.IBLOCK_ELEMENT_ID=IBE.ID) AS PHOTO, (SELECT VALUE FROM b_iblock_element_property AS BLIA WHERE BLIA.IBLOCK_PROPERTY_ID=38 AND BLIA.IBLOCK_ELEMENT_ID=IBE.ID) AS COMMENTS, IBE.ID AS ID, IBE.CODE AS CODE, IBE.NAME AS TITLE, IBE.PREVIEW_TEXT AS TEXT, IBE.PREVIEW_PICTURE, IBS.NAME AS RUBRIC_NAME, IBS.CODE AS RUBRIC_CODE, F.SUBDIR, F.FILE_NAME, IBE.ACTIVE_FROM as DATE_CREATE FROM b_iblock_element AS IBE LEFT JOIN b_iblock_section AS IBS ON IBS.ID=IBE.IBLOCK_SECTION_ID LEFT JOIN b_file AS F ON F.ID=IBE.PREVIEW_PICTURE WHERE IBS.ID IN(1,) AND IBE.IBLOCK_ID=1 AND IBE.ACTIVE='Y' AND IBE.ACTIVE_FROM < NOW() AND (SELECT MT.VALUE FROM b_iblock_element_property AS MT WHERE MT.IBLOCK_ELEMENT_ID=IBE.ID AND MT.IBLOCK_PROPERTY_ID=1) = 2 ORDER BY IBE.ACTIVE_FROM DESC, IBE.SORT DESC LIMIT 18 [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 ') AND IBE.IBLOCK_ID=1 AND IBE.ACTIVE='Y' AN' at line 9]
MySQL Query Error: SELECT (SELECT VALUE FROM b_iblock_element_property AS BLIA WHERE BLIA.IBLOCK_PROPERTY_ID=10 AND BLIA.IBLOCK_ELEMENT_ID=IBE.ID) AS VIDEO, (SELECT VALUE FROM b_iblock_element_property AS BLIA WHERE BLIA.IBLOCK_PROPERTY_ID=9 AND BLIA.IBLOCK_ELEMENT_ID=IBE.ID) AS PHOTO, (SELECT VALUE FROM b_iblock_element_property AS BLIA WHERE BLIA.IBLOCK_PROPERTY_ID=38 AND BLIA.IBLOCK_ELEMENT_ID=IBE.ID) AS COMMENTS, IBE.ID AS ID, IBE.CODE AS CODE, IBE.NAME AS TITLE, IBE.PREVIEW_TEXT AS TEXT, IBE.PREVIEW_PICTURE, IBS.NAME AS RUBRIC_NAME, IBS.CODE AS RUBRIC_CODE, F.SUBDIR, F.FILE_NAME, IBE.ACTIVE_FROM as DATE_CREATE FROM b_iblock_element AS IBE LEFT JOIN b_iblock_section AS IBS ON IBS.ID=IBE.IBLOCK_SECTION_ID LEFT JOIN b_file AS F ON F.ID=IBE.PREVIEW_PICTURE WHERE IBS.ID IN(1,) AND IBE.IBLOCK_ID=1 AND IBE.ACTIVE='Y' AND IBE.ACTIVE_FROM < NOW() AND (SELECT MT.VALUE FROM b_iblock_element_property AS MT WHERE MT.IBLOCK_ELEMENT_ID=IBE.ID AND MT.IBLOCK_PROPERTY_ID=1) = 2 ORDER BY IBE.ACTIVE_FROM DESC, IBE.SORT DESC LIMIT 18 [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 ') AND IBE.IBLOCK_ID=1 AND IBE.ACTIVE='Y' AN' at line 9]
|