Таблицы товаров и категорий Bitrix в базе данных

Подробности

Категория: Bitrix

Обновлено 08.07.2019

Товары
b_iblock_element
b_iblock_element_iprop
b_sale_viewed_product
b_iblock_element_property

Категории
b_iblock_section
b_iblock_section_iprop

"SELECT c.id, c.name,c2.id, c2.name,c3.id, c3.name,c4.id, c4.name FROM b_iblock_section c LEFT JOIN b_iblock_section c2 ON(c2.IBLOCK_SECTION_ID = c.id) LEFT JOIN b_iblock_section c3 ON(c3.IBLOCK_SECTION_ID = c2.id) LEFT JOIN b_iblock_section c4 ON(c4.IBLOCK_SECTION_ID = c3.id) WHERE c.IBLOCK_SECTION_ID IS NULL AND c.active ='y' AND c2.id is not null ORDER BY c.name,c2.name,c3.name,c4.name ASC"