bitrix blocks-sections-elements

SELECT * FROM

(SELECT a.iblock_type_id, a.name block_name, a.list_page_url, a.section_page_url,
a.detail_page_url, s.name section_name, el.name element_name
FROM
   b_iblock AS a LEFT JOIN (
      b_iblock_section AS s LEFT JOIN b_iblock_element AS el ON
      el.iblock_section_id=s.id)

      ON s.iblock_id=a.id


      UNION ALL

      SELECT a.iblock_type_id, a.name block_name, a.list_page_url, a.section_page_url,
a.detail_page_url, s.name section_name, el.name element_name
FROM
   b_iblock_element AS el LEFT JOIN (
                  b_iblock_section AS s LEFT JOIN b_iblock a ON
                  s.iblock_id=a.id)

                  ON el.iblock_section_id=s.id

                  WHERE a.id IS NULL) AS zz

                  ORDER BY iblock_type_id, block_name, section_name, element_name