MySQL Query Error: SELECT DISTINCT BS.*, BS.XML_ID as EXTERNAL_ID, DATE_FORMAT(BS.TIMESTAMP_X, '%H:%i | %d-%m-%Y') as TIMESTAMP_X, COUNT(DISTINCT BE.ID) as ELEMENT_CNT FROM b_iblock_section BS, b_iblock B LEFT JOIN b_iblock_group IBG ON IBG.IBLOCK_ID=B.ID , b_iblock_section BSTEMP LEFT JOIN b_iblock_section_element BSE ON BSE.IBLOCK_SECTION_ID=BSTEMP.ID LEFT JOIN b_iblock_element BE ON (BSE.IBLOCK_ELEMENT_ID=BE.ID AND ((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL ) AND BE.IBLOCK_ID = BS.IBLOCK_ID ) AND BE.ACTIVE='Y' AND (BE.ACTIVE_TO >= CURRENT_DATE OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= CURRENT_DATE OR BE.ACTIVE_FROM IS NULL)) WHERE BS.IBLOCK_ID = B.ID AND IBG.GROUP_ID IN (2) AND IBG.PERMISSION>='R' AND (IBG.PERMISSION='X' OR B.ACTIVE='Y') AND BSTEMP.IBLOCK_ID = BS.IBLOCK_ID AND BSTEMP.LEFT_MARGIN >= BS.LEFT_MARGIN AND BSTEMP.RIGHT_MARGIN <= BS.RIGHT_MARGIN AND ((((BS.IBLOCK_ID = '42')))) AND ((((BS.ACTIVE='Y')))) AND ((((BS.IBLOCK_SECTION_ID IS NULL)))) AND (B.ID IN (0,42) ) GROUP BY BS.ID ORDER BY BS.SORT asc , BS.NAME asc [Unknown column 'BS.IBLOCK_ID' in 'on clause']
