Каталог без разделов

SEL ECT BE.ID as ID
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
WHERE 1=1
   AND (
      ((((BE.IBLOCK_ID = '20'))))
      AND (
         EXISTS (
            SELECT IBLOCK_ID FR OM b_iblock_site WH ERE IBLOCK_ID = B.ID AND (((SITE_ID='s1')))
         )
      )
      AND ((((B.ACTIVE='Y'))))
      AND ((
         (BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL)
      ))
      AND ((((BE.ACTIVE='Y'))))
      AND ((((BE.CODE = 'SECTION_CODE'))))
   )
   AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))