Catalog Diag

1. Все инфоблоки сайта

ID	CODE	NAME	IBLOCK_TYPE_ID	ACTIVE
1	catalog	Каталог товаров	catalog	Y
2	reviews	Отзывы	Reviews	Y
3	banners	Баннеры	banners	Y
4	sertificates	Сертификаты	sertificates	Y
5	sertificates_results	Сертификаты Отчеты	sertificates	Y
6	colors	Цвета	catalog	Y
8	collection	Коллекции	catalog	Y
9		Описания	catalog	Y
10		Отзывы о магазине	Reviews	Y

2. Инфоблоки, подключённые к каталогу (b_catalog)

IBLOCK_ID	NAME	SUBSCRIPTION	PRODUCT_IBLOCK_ID
1	Каталог товаров	N	0
4	Сертификаты	N	0

3. Свойства товарных инфоблоков

IBlock ID=1: Каталог товаров

ID	CODE	NAME	PROPERTY_TYPE	USER_TYPE
40	AVAIL_COLOR	Доступные цвета	L
56	PRODUCT_TYPE	Тип(Раздел)	L
62	NEW_COLOR	Новый цвет	E
63	NEW_AVAIL_COLOR	Новый доступный цвет	E	EList
68	COLLECTION	Коллекция	E
54	RECOMEND	Рекомендуемые товары	E
1	MORE_PHOTO	Доп Картинки	F
2	MORE_PHOTO_HIGH	Доп Картинки(Увелич)	F
3	ARTICLE	Артикул	S
4	TO_MAIN	Лидеры продаж	L
5	NEW_PRODUCT	Новинка	L
39	COLOR_LIST	Цвет для фильтра	L
51	ZAKAZ_DAYS	Производство	S
57	BRAND	Бренд	S	directory
71	PROMO	Показывать в акциях	L
72	LEATHER	Кожа	L
6	ARTIKUL	Артикул	S
7	TSVET	Цвет	S
8	MATERIAL_KRYSHKI	Материал крышки	S
9	TIP	Тип	S
10	TVYERDOST_KRYSHKI	Твёрдость крышки	S
12	ELASTICHNYY_FIKSATOR	Эластичный фиксатор	S
13	FLESHKA	Флешка	S
14	KHLYASTIK	Хлястик	S
15	FURNITURA	Фурнитура	S
16	BLOK	Блок	S
17	FORMAT	Формат	S
18	PETLYA_DLYA_RUCHKI	Петля для ручки	S
20	STIL	Стиль	S
21	POL	Пол	S
22	TSVET_FURNITURY	Цвет фурнитуры	S
23	RAZMERY_SHKHVKHG	Размеры (ШхВхГ)	S
24	MATERIAL	Материал	L
25	VYDELKA	Выделка	S
26	LOGOTIP	Логотип	S
27	KAK_ZAKRYVAETSYA	Как закрывается	S
28	MATERIAL_PODKLADKI	Материал подкладки	S
29	TSVET_PODKLADKI	Цвет подкладки	S
30	KOLICHESTVO_OTDELENIY	Количество отделений	S
31	KOLICHESTVO_KARMANOV	Количество карманов	S
32	DLINA_REMNYA	Длина ремня	S
33	DOPOLNITELNYY_REMEN	Дополнительный ремень	S
35	UPAKOVKA	Упаковка	S
41	RAZMERY	Размеры	S
42	KRASOCHNOST_BLOKA	Красочность блока	S
43	OBLOZHKA	Обложка	S
44	SPOSOB_KREPLENIYA_BLOKA	Способ крепления блока	S
45	RAZMER_IZDELIYA	Размер изделия	S
46	RAZMER_BLOKA	Размер блока	S
52	KOMPLEKTACIA	Комплектация	S
53	NAPOLNENIE_KOROBKI	Наполнение коробки	S
64	PAPER_COLOR	Цвет бумаги	L
65	TYPE	Тип	L

IBlock ID=4: Сертификаты

ID	CODE	NAME	PROPERTY_TYPE	USER_TYPE

4. Пример товара (первые 3 из каждого каталожного инфоблока)

IBlock ID=1: Каталог товаров

[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: (1116) Too many tables; MariaDB can only use 61 tables in a join (400)

					SELECT DISTINCT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,BE.NAME as NAME,BE.ACTIVE as ACTIVE,BE.XML_ID as XML_ID, FPV0.VALUE as PROPERTY_MORE_PHOTO_VALUE, FPV0.ID as PROPERTY_MORE_PHOTO_VALUE_ID, FPV1.VALUE as PROPERTY_MORE_PHOTO_HIGH_VALUE, FPV1.ID as PROPERTY_MORE_PHOTO_HIGH_VALUE_ID, FPV2.VALUE as PROPERTY_ARTICLE_VALUE, FPV2.ID as PROPERTY_ARTICLE_VALUE_ID, FPEN0.VALUE as PROPERTY_TO_MAIN_VALUE, FPEN0.ID as PROPERTY_TO_MAIN_ENUM_ID, FPV3.ID as PROPERTY_TO_MAIN_VALUE_ID, FPEN1.VALUE as PROPERTY_NEW_PRODUCT_VALUE, FPEN1.ID as PROPERTY_NEW_PRODUCT_ENUM_ID, FPV4.ID as PROPERTY_NEW_PRODUCT_VALUE_ID, FPV5.VALUE as PROPERTY_ARTIKUL_VALUE, FPV5.ID as PROPERTY_ARTIKUL_VALUE_ID, FPV6.VALUE as PROPERTY_TSVET_VALUE, FPV6.ID as PROPERTY_TSVET_VALUE_ID, FPV7.VALUE as PROPERTY_MATERIAL_KRYSHKI_VALUE, FPV7.ID as PROPERTY_MATERIAL_KRYSHKI_VALUE_ID, FPV8.VALUE as PROPERTY_TIP_VALUE, FPV8.ID as PROPERTY_TIP_VALUE_ID, FPV9.VALUE as PROPERTY_TVYERDOST_KRYSHKI_VALUE, FPV9.ID as PROPERTY_TVYERDOST_KRYSHKI_VALUE_ID, FPV10.VALUE as PROPERTY_ELASTICHNYY_FIKSATOR_VALUE, FPV10.ID as PROPERTY_ELASTICHNYY_FIKSATOR_VALUE_ID, FPV11.VALUE as PROPERTY_FLESHKA_VALUE, FPV11.ID as PROPERTY_FLESHKA_VALUE_ID, FPV12.VALUE as PROPERTY_KHLYASTIK_VALUE, FPV12.ID as PROPERTY_KHLYASTIK_VALUE_ID, FPV13.VALUE as PROPERTY_FURNITURA_VALUE, FPV13.ID as PROPERTY_FURNITURA_VALUE_ID, FPV14.VALUE as PROPERTY_BLOK_VALUE, FPV14.ID as PROPERTY_BLOK_VALUE_ID, FPV15.VALUE as PROPERTY_FORMAT_VALUE, FPV15.ID as PROPERTY_FORMAT_VALUE_ID, FPV16.VALUE as PROPERTY_PETLYA_DLYA_RUCHKI_VALUE, FPV16.ID as PROPERTY_PETLYA_DLYA_RUCHKI_VALUE_ID, FPV17.VALUE as PROPERTY_STIL_VALUE, FPV17.ID as PROPERTY_STIL_VALUE_ID, FPV18.VALUE as PROPERTY_POL_VALUE, FPV18.ID as PROPERTY_POL_VALUE_ID, FPV19.VALUE as PROPERTY_TSVET_FURNITURY_VALUE, FPV19.ID as PROPERTY_TSVET_FURNITURY_VALUE_ID, FPV20.VALUE as PROPERTY_RAZMERY_SHKHVKHG_VALUE, FPV20.ID as PROPERTY_RAZMERY_SHKHVKHG_VALUE_ID, FPEN2.VALUE as PROPERTY_MATERIAL_VALUE, FPEN2.ID as PROPERTY_MATERIAL_ENUM_ID, FPV21.ID as PROPERTY_MATERIAL_VALUE_ID, FPV22.VALUE as PROPERTY_VYDELKA_VALUE, FPV22.ID as PROPERTY_VYDELKA_VALUE_ID, FPV23.VALUE as PROPERTY_LOGOTIP_VALUE, FPV23.ID as PROPERTY_LOGOTIP_VALUE_ID, FPV24.VALUE as PROPERTY_KAK_ZAKRYVAETSYA_VALUE, FPV24.ID as PROPERTY_KAK_ZAKRYVAETSYA_VALUE_ID, FPV25.VALUE as PROPERTY_MATERIAL_PODKLADKI_VALUE, FPV25.ID as PROPERTY_MATERIAL_PODKLADKI_VALUE_ID, FPV26.VALUE as PROPERTY_TSVET_PODKLADKI_VALUE, FPV26.ID as PROPERTY_TSVET_PODKLADKI_VALUE_ID, FPV27.VALUE as PROPERTY_KOLICHESTVO_OTDELENIY_VALUE, FPV27.ID as PROPERTY_KOLICHESTVO_OTDELENIY_VALUE_ID, FPV28.VALUE as PROPERTY_KOLICHESTVO_KARMANOV_VALUE, FPV28.ID as PROPERTY_KOLICHESTVO_KARMANOV_VALUE_ID, FPV29.VALUE as PROPERTY_DLINA_REMNYA_VALUE, FPV29.ID as PROPERTY_DLINA_REMNYA_VALUE_ID, FPV30.VALUE as PROPERTY_DOPOLNITELNYY_REMEN_VALUE, FPV30.ID as PROPERTY_DOPOLNITELNYY_REMEN_VALUE_ID, FPV31.VALUE as PROPERTY_UPAKOVKA_VALUE, FPV31.ID as PROPERTY_UPAKOVKA_VALUE_ID, FPEN3.VALUE as PROPERTY_COLOR_LIST_VALUE, FPEN3.ID as PROPERTY_COLOR_LIST_ENUM_ID, FPV32.ID as PROPERTY_COLOR_LIST_VALUE_ID, FPEN4.VALUE as PROPERTY_AVAIL_COLOR_VALUE, FPEN4.ID as PROPERTY_AVAIL_COLOR_ENUM_ID, FPV33.ID as PROPERTY_AVAIL_COLOR_VALUE_ID, FPV34.VALUE as PROPERTY_RAZMERY_VALUE, FPV34.ID as PROPERTY_RAZMERY_VALUE_ID, FPV35.VALUE as PROPERTY_KRASOCHNOST_BLOKA_VALUE, FPV35.ID as PROPERTY_KRASOCHNOST_BLOKA_VALUE_ID, FPV36.VALUE as PROPERTY_OBLOZHKA_VALUE, FPV36.ID as PROPERTY_OBLOZHKA_VALUE_ID, FPV37.VALUE as PROPERTY_SPOSOB_KREPLENIYA_BLOKA_VALUE, FPV37.ID as PROPERTY_SPOSOB_KREPLENIYA_BLOKA_VALUE_ID, FPV38.VALUE as PROPERTY_RAZMER_IZDELIYA_VALUE, FPV38.ID as PROPERTY_RAZMER_IZDELIYA_VALUE_ID, FPV39.VALUE as PROPERTY_RAZMER_BLOKA_VALUE, FPV39.ID as PROPERTY_RAZMER_BLOKA_VALUE_ID, FPV40.VALUE as PROPERTY_ZAKAZ_DAYS_VALUE, FPV40.ID as PROPERTY_ZAKAZ_DAYS_VALUE_ID, FPV41.VALUE as PROPERTY_KOMPLEKTACIA_VALUE, FPV41.ID as PROPERTY_KOMPLEKTACIA_VALUE_ID, FPV42.VALUE as PROPERTY_NAPOLNENIE_KOROBKI_VALUE, FPV42.ID as PROPERTY_NAPOLNENIE_KOROBKI_VALUE_ID, FPV43.VALUE as PROPERTY_RECOMEND_VALUE, FPV43.ID as PROPERTY_RECOMEND_VALUE_ID, FPEN5.VALUE as PROPERTY_PRODUCT_TYPE_VALUE, FPEN5.ID as PROPERTY_PRODUCT_TYPE_ENUM_ID, FPV44.ID as PROPERTY_PRODUCT_TYPE_VALUE_ID, FPV45.VALUE as PROPERTY_BRAND_VALUE, FPV45.ID as PROPERTY_BRAND_VALUE_ID, FPV46.VALUE as PROPERTY_NEW_COLOR_VALUE, FPV46.ID as PROPERTY_NEW_COLOR_VALUE_ID, FPV47.VALUE as PROPERTY_NEW_AVAIL_COLOR_VALUE, FPV47.ID as PROPERTY_NEW_AVAIL_COLOR_VALUE_ID, FPEN6.VALUE as PROPERTY_PAPER_COLOR_VALUE, FPEN6.ID as PROPERTY_PAPER_COLOR_ENUM_ID, FPV48.ID as PROPERTY_PAPER_COLOR_VALUE_ID, FPEN7.VALUE as PROPERTY_TYPE_VALUE, FPEN7.ID as PROPERTY_TYPE_ENUM_ID, FPV49.ID as PROPERTY_TYPE_VALUE_ID, FPV50.VALUE as PROPERTY_COLLECTION_VALUE, FPV50.ID as PROPERTY_COLLECTION_VALUE_ID, FPEN8.VALUE as PROPERTY_PROMO_VALUE, FPEN8.ID as PROPERTY_PROMO_ENUM_ID, FPV51.ID as PROPERTY_PROMO_VALUE_ID, FPEN9.VALUE as PROPERTY_LEATHER_VALUE, FPEN9.ID as PROPERTY_LEATHER_ENUM_ID, FPV52.ID as PROPERTY_LEATHER_VALUE_ID
					FROM 
			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
			LEFT JOIN b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.CODE='MORE_PHOTO'
			LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE='MORE_PHOTO_HIGH'
			LEFT JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND FP2.CODE='ARTICLE'
			LEFT JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID = B.ID AND FP3.CODE='TO_MAIN'
			LEFT JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID = B.ID AND FP4.CODE='NEW_PRODUCT'
			LEFT JOIN b_iblock_property FP5 ON FP5.IBLOCK_ID = B.ID AND FP5.CODE='ARTIKUL'
			LEFT JOIN b_iblock_property FP6 ON FP6.IBLOCK_ID = B.ID AND FP6.CODE='TSVET'
			LEFT JOIN b_iblock_property FP7 ON FP7.IBLOCK_ID = B.ID AND FP7.CODE='MATERIAL_KRYSHKI'
			LEFT JOIN b_iblock_property FP8 ON FP8.IBLOCK_ID = B.ID AND FP8.CODE='TIP'
			LEFT JOIN b_iblock_property FP9 ON FP9.IBLOCK_ID = B.ID AND FP9.CODE='TVYERDOST_KRYSHKI'
			LEFT JOIN b_iblock_property FP10 ON FP10.IBLOCK_ID = B.ID AND FP10.CODE='ELASTICHNYY_FIKSATOR'
			LEFT JOIN b_iblock_property FP11 ON FP11.IBLOCK_ID = B.ID AND FP11.CODE='FLESHKA'
			LEFT JOIN b_iblock_property FP12 ON FP12.IBLOCK_ID = B.ID AND FP12.CODE='KHLYASTIK'
			LEFT JOIN b_iblock_property FP13 ON FP13.IBLOCK_ID = B.ID AND FP13.CODE='FURNITURA'
			LEFT JOIN b_iblock_property FP14 ON FP14.IBLOCK_ID = B.ID AND FP14.CODE='BLOK'
			LEFT JOIN b_iblock_property FP15 ON FP15.IBLOCK_ID = B.ID AND FP15.CODE='FORMAT'
			LEFT JOIN b_iblock_property FP16 ON FP16.IBLOCK_ID = B.ID AND FP16.CODE='PETLYA_DLYA_RUCHKI'
			LEFT JOIN b_iblock_property FP17 ON FP17.IBLOCK_ID = B.ID AND FP17.CODE='STIL'
			LEFT JOIN b_iblock_property FP18 ON FP18.IBLOCK_ID = B.ID AND FP18.CODE='POL'
			LEFT JOIN b_iblock_property FP19 ON FP19.IBLOCK_ID = B.ID AND FP19.CODE='TSVET_FURNITURY'
			LEFT JOIN b_iblock_property FP20 ON FP20.IBLOCK_ID = B.ID AND FP20.CODE='RAZMERY_SHKHVKHG'
			LEFT JOIN b_iblock_property FP21 ON FP21.IBLOCK_ID = B.ID AND FP21.CODE='MATERIAL'
			LEFT JOIN b_iblock_property FP22 ON FP22.IBLOCK_ID = B.ID AND FP22.CODE='VYDELKA'
			LEFT JOIN b_iblock_property FP23 ON FP23.IBLOCK_ID = B.ID AND FP23.CODE='LOGOTIP'
			LEFT JOIN b_iblock_property FP24 ON FP24.IBLOCK_ID = B.ID AND FP24.CODE='KAK_ZAKRYVAETSYA'
			LEFT JOIN b_iblock_property FP25 ON FP25.IBLOCK_ID = B.ID AND FP25.CODE='MATERIAL_PODKLADKI'
			LEFT JOIN b_iblock_property FP26 ON FP26.IBLOCK_ID = B.ID AND FP26.CODE='TSVET_PODKLADKI'
			LEFT JOIN b_iblock_property FP27 ON FP27.IBLOCK_ID = B.ID AND FP27.CODE='KOLICHESTVO_OTDELENIY'
			LEFT JOIN b_iblock_property FP28 ON FP28.IBLOCK_ID = B.ID AND FP28.CODE='KOLICHESTVO_KARMANOV'
			LEFT JOIN b_iblock_property FP29 ON FP29.IBLOCK_ID = B.ID AND FP29.CODE='DLINA_REMNYA'
			LEFT JOIN b_iblock_property FP30 ON FP30.IBLOCK_ID = B.ID AND FP30.CODE='DOPOLNITELNYY_REMEN'
			LEFT JOIN b_iblock_property FP31 ON FP31.IBLOCK_ID = B.ID AND FP31.CODE='UPAKOVKA'
			LEFT JOIN b_iblock_property FP32 ON FP32.IBLOCK_ID = B.ID AND FP32.CODE='COLOR_LIST'
			LEFT JOIN b_iblock_property FP33 ON FP33.IBLOCK_ID = B.ID AND FP33.CODE='AVAIL_COLOR'
			LEFT JOIN b_iblock_property FP34 ON FP34.IBLOCK_ID = B.ID AND FP34.CODE='RAZMERY'
			LEFT JOIN b_iblock_property FP35 ON FP35.IBLOCK_ID = B.ID AND FP35.CODE='KRASOCHNOST_BLOKA'
			LEFT JOIN b_iblock_property FP36 ON FP36.IBLOCK_ID = B.ID AND FP36.CODE='OBLOZHKA'
			LEFT JOIN b_iblock_property FP37 ON FP37.IBLOCK_ID = B.ID AND FP37.CODE='SPOSOB_KREPLENIYA_BLOKA'
			LEFT JOIN b_iblock_property FP38 ON FP38.IBLOCK_ID = B.ID AND FP38.CODE='RAZMER_IZDELIYA'
			LEFT JOIN b_iblock_property FP39 ON FP39.IBLOCK_ID = B.ID AND FP39.CODE='RAZMER_BLOKA'
			LEFT JOIN b_iblock_property FP40 ON FP40.IBLOCK_ID = B.ID AND FP40.CODE='ZAKAZ_DAYS'
			LEFT JOIN b_iblock_property FP41 ON FP41.IBLOCK_ID = B.ID AND FP41.CODE='KOMPLEKTACIA'
			LEFT JOIN b_iblock_property FP42 ON FP42.IBLOCK_ID = B.ID AND FP42.CODE='NAPOLNENIE_KOROBKI'
			LEFT JOIN b_iblock_property FP43 ON FP43.IBLOCK_ID = B.ID AND FP43.CODE='RECOMEND'
			LEFT JOIN b_iblock_property FP44 ON FP44.IBLOCK_ID = B.ID AND FP44.CODE='PRODUCT_TYPE'
			LEFT JOIN b_iblock_property FP45 ON FP45.IBLOCK_ID = B.ID AND FP45.CODE='BRAND'
			LEFT JOIN b_iblock_property FP46 ON FP46.IBLOCK_ID = B.ID AND FP46.CODE='NEW_COLOR'
			LEFT JOIN b_iblock_property FP47 ON FP47.IBLOCK_ID = B.ID AND FP47.CODE='NEW_AVAIL_COLOR'
			LEFT JOIN b_iblock_property FP48 ON FP48.IBLOCK_ID = B.ID AND FP48.CODE='PAPER_COLOR'
			LEFT JOIN b_iblock_property FP49 ON FP49.IBLOCK_ID = B.ID AND FP49.CODE='TYPE'
			LEFT JOIN b_iblock_property FP50 ON FP50.IBLOCK_ID = B.ID AND FP50.CODE='COLLECTION'
			LEFT JOIN b_iblock_property FP51 ON FP51.IBLOCK_ID = B.ID AND FP51.CODE='PROMO'
			LEFT JOIN b_iblock_property FP52 ON FP52.IBLOCK_ID = B.ID AND FP52.CODE='LEATHER'
			LEFT JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV1 ON FPV1.IBLOCK_PROPERTY_ID = FP1.ID AND FPV1.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV2 ON FPV2.IBLOCK_PROPERTY_ID = FP2.ID AND FPV2.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV3 ON FPV3.IBLOCK_PROPERTY_ID = FP3.ID AND FPV3.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV4 ON FPV4.IBLOCK_PROPERTY_ID = FP4.ID AND FPV4.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV5 ON FPV5.IBLOCK_PROPERTY_ID = FP5.ID AND FPV5.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV6 ON FPV6.IBLOCK_PROPERTY_ID = FP6.ID AND FPV6.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV7 ON FPV7.IBLOCK_PROPERTY_ID = FP7.ID AND FPV7.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV8 ON FPV8.IBLOCK_PROPERTY_ID = FP8.ID AND FPV8.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV9 ON FPV9.IBLOCK_PROPERTY_ID = FP9.ID AND FPV9.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV10 ON FPV10.IBLOCK_PROPERTY_ID = FP10.ID AND FPV10.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV11 ON FPV11.IBLOCK_PROPERTY_ID = FP11.ID AND FPV11.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV12 ON FPV12.IBLOCK_PROPERTY_ID = FP12.ID AND FPV12.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV13 ON FPV13.IBLOCK_PROPERTY_ID = FP13.ID AND FPV13.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV14 ON FPV14.IBLOCK_PROPERTY_ID = FP14.ID AND FPV14.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV15 ON FPV15.IBLOCK_PROPERTY_ID = FP15.ID AND FPV15.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV16 ON FPV16.IBLOCK_PROPERTY_ID = FP16.ID AND FPV16.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV17 ON FPV17.IBLOCK_PROPERTY_ID = FP17.ID AND FPV17.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV18 ON FPV18.IBLOCK_PROPERTY_ID = FP18.ID AND FPV18.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV19 ON FPV19.IBLOCK_PROPERTY_ID = FP19.ID AND FPV19.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV20 ON FPV20.IBLOCK_PROPERTY_ID = FP20.ID AND FPV20.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV21 ON FPV21.IBLOCK_PROPERTY_ID = FP21.ID AND FPV21.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV22 ON FPV22.IBLOCK_PROPERTY_ID = FP22.ID AND FPV22.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV23 ON FPV23.IBLOCK_PROPERTY_ID = FP23.ID AND FPV23.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV24 ON FPV24.IBLOCK_PROPERTY_ID = FP24.ID AND FPV24.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV25 ON FPV25.IBLOCK_PROPERTY_ID = FP25.ID AND FPV25.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV26 ON FPV26.IBLOCK_PROPERTY_ID = FP26.ID AND FPV26.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV27 ON FPV27.IBLOCK_PROPERTY_ID = FP27.ID AND FPV27.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV28 ON FPV28.IBLOCK_PROPERTY_ID = FP28.ID AND FPV28.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV29 ON FPV29.IBLOCK_PROPERTY_ID = FP29.ID AND FPV29.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV30 ON FPV30.IBLOCK_PROPERTY_ID = FP30.ID AND FPV30.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV31 ON FPV31.IBLOCK_PROPERTY_ID = FP31.ID AND FPV31.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV32 ON FPV32.IBLOCK_PROPERTY_ID = FP32.ID AND FPV32.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV33 ON FPV33.IBLOCK_PROPERTY_ID = FP33.ID AND FPV33.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV34 ON FPV34.IBLOCK_PROPERTY_ID = FP34.ID AND FPV34.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV35 ON FPV35.IBLOCK_PROPERTY_ID = FP35.ID AND FPV35.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV36 ON FPV36.IBLOCK_PROPERTY_ID = FP36.ID AND FPV36.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV37 ON FPV37.IBLOCK_PROPERTY_ID = FP37.ID AND FPV37.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV38 ON FPV38.IBLOCK_PROPERTY_ID = FP38.ID AND FPV38.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV39 ON FPV39.IBLOCK_PROPERTY_ID = FP39.ID AND FPV39.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV40 ON FPV40.IBLOCK_PROPERTY_ID = FP40.ID AND FPV40.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV41 ON FPV41.IBLOCK_PROPERTY_ID = FP41.ID AND FPV41.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV42 ON FPV42.IBLOCK_PROPERTY_ID = FP42.ID AND FPV42.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV43 ON FPV43.IBLOCK_PROPERTY_ID = FP43.ID AND FPV43.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV44 ON FPV44.IBLOCK_PROPERTY_ID = FP44.ID AND FPV44.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV45 ON FPV45.IBLOCK_PROPERTY_ID = FP45.ID AND FPV45.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV46 ON FPV46.IBLOCK_PROPERTY_ID = FP46.ID AND FPV46.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV47 ON FPV47.IBLOCK_PROPERTY_ID = FP47.ID AND FPV47.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV48 ON FPV48.IBLOCK_PROPERTY_ID = FP48.ID AND FPV48.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV49 ON FPV49.IBLOCK_PROPERTY_ID = FP49.ID AND FPV49.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV50 ON FPV50.IBLOCK_PROPERTY_ID = FP50.ID AND FPV50.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV51 ON FPV51.IBLOCK_PROPERTY_ID = FP51.ID AND FPV51.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_element_property FPV52 ON FPV52.IBLOCK_PROPERTY_ID = FP52.ID AND FPV52.IBLOCK_ELEMENT_ID = BE.ID
			LEFT JOIN b_iblock_property_enum FPEN0 ON FPEN0.PROPERTY_ID = FPV3.IBLOCK_PROPERTY_ID AND FPV3.VALUE_ENUM = FPEN0.ID
			LEFT JOIN b_iblock_property_enum FPEN1 ON FPEN1.PROPERTY_ID = FPV4.IBLOCK_PROPERTY_ID AND FPV4.VALUE_ENUM = FPEN1.ID
			LEFT JOIN b_iblock_property_enum FPEN2 ON FPEN2.PROPERTY_ID = FPV21.IBLOCK_PROPERTY_ID AND FPV21.VALUE_ENUM = FPEN2.ID
			LEFT JOIN b_iblock_property_enum FPEN3 ON FPEN3.PROPERTY_ID = FPV32.IBLOCK_PROPERTY_ID AND FPV32.VALUE_ENUM = FPEN3.ID
			LEFT JOIN b_iblock_property_enum FPEN4 ON FPEN4.PROPERTY_ID = FPV33.IBLOCK_PROPERTY_ID AND FPV33.VALUE_ENUM = FPEN4.ID
			LEFT JOIN b_iblock_property_enum FPEN5 ON FPEN5.PROPERTY_ID = FPV44.IBLOCK_PROPERTY_ID AND FPV44.VALUE_ENUM = FPEN5.ID
			LEFT JOIN b_iblock_property_enum FPEN6 ON FPEN6.PROPERTY_ID = FPV48.IBLOCK_PROPERTY_ID AND FPV48.VALUE_ENUM = FPEN6.ID
			LEFT JOIN b_iblock_property_enum FPEN7 ON FPEN7.PROPERTY_ID = FPV49.IBLOCK_PROPERTY_ID AND FPV49.VALUE_ENUM = FPEN7.ID
			LEFT JOIN b_iblock_property_enum FPEN8 ON FPEN8.PROPERTY_ID = FPV51.IBLOCK_PROPERTY_ID AND FPV51.VALUE_ENUM = FPEN8.ID
			LEFT JOIN b_iblock_property_enum FPEN9 ON FPEN9.PROPERTY_ID = FPV52.IBLOCK_PROPERTY_ID AND FPV52.VALUE_ENUM = FPEN9.ID

		
					WHERE 1=1 
			AND (
			
				((((BE.IBLOCK_ID = 1))))
				AND ((((BE.ACTIVE='Y'))))
			)
			AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
					
					 ORDER BY BE.ID asc 
				 LIMIT 3 OFFSET 0
/var/www/spark-store.moscow/html/bitrix/modules/main/lib/db/mysqlcommonconnection.php:415
#0: Bitrix\Main\DB\MysqlCommonConnection->createQueryException
	/var/www/spark-store.moscow/html/bitrix/modules/main/classes/general/database.php:670
#1: CAllDatabase->Query
	/var/www/spark-store.moscow/html/bitrix/modules/main/classes/general/dbresult.php:286
#2: CAllDBResult->NavQuery
	/var/www/spark-store.moscow/html/bitrix/modules/iblock/classes/mysql/iblockelement.php:854
#3: CIBlockElement::GetList
	/var/www/spark-store.moscow/html/diag_catalog.php:79
----------