SELECT
Vendor.name as 'Производитель',
ProductData.made_in as 'Страна',
Brand.value as 'Бренд производителя',
Postavshik.value as 'Поставщик',
BaseData.pagetitle as 'Название',
GROUP_CONCAT(DISTINCT Gallery.url ORDER BY Gallery.product_id ASC SEPARATOR '|') as 'Галерея',
Article2.value as 'Артикул производителя',
Article3.value as 'Артикул поставщика (оптовика)',
ProductData.article as 'Артикул',
SHCode.value as 'Штрих код',
BaseData.parent as 'Родитель',
Cloth.value as 'Ткань',
ClothMat.value as 'Состав ткани',
PlotnostCloth.value as 'Плотность ткани',
ClothCountry.value as 'Страна - производитель ткани',
ClothAdd.value as 'Ткань-компаньон',
ClothMatAdd.value as 'Состав ткани-компаньона',
GROUP_CONCAT(DISTINCT Size2.value ORDER BY Size2.product_id ASC SEPARATOR '|') as 'Размер пододеяльника, см',
CoinPododeal.value as 'Количество пододеяльников',
GROUP_CONCAT(DISTINCT Size1.value ORDER BY Size1.product_id ASC SEPARATOR '|') as 'Размер простыни, см',
GROUP_CONCAT(DISTINCT Size3.value ORDER BY Size3.product_id ASC SEPARATOR '|') as 'Размер наволочек 1, см',
NavolochCoint.value as 'Количество наволочек 1, шт.',
GROUP_CONCAT(DISTINCT Size4.value ORDER BY Size4.product_id ASC SEPARATOR '|') as 'Размер наволочек 2, см',
NavolochCoint2.value as 'Количество наволочек 2, шт.',
Upakovka.value as 'Упаковка',
ProductData.weight as 'Вес в упаковке',
LengthPack.value as 'Длина упаковки, см',
WidthPack.value as 'Ширина упаковки, см',
HeightPack.value as 'Высота упаковки, см',
ZakupPrice.value as 'Цена закупки, руб.',
RecPrice.value as 'РРЦ, руб.',
ProductData.price as 'Цена сбыта',
PriceAfterAction.value as 'Цена с % скидки по акции (руб.)',
PriceAfterActionZak.value as 'Цена с % скидки по акции, руб. - опт (наша закупка)',
Osobennosti1.value as 'Особенности 1',
Osobennosti2.value as 'Особенности 2',
Dekor.value as 'Декор',
BaseData.content as 'Содержимое',
Ostatki.value as 'Остатки',
(SELECT IF (Color1.value = 1, 1, '') FROM modx_ms2_product_options AS Color1 WHERE Color1.product_id = ProductData.id AND Color1.key = 'color_1') as 'Белый',
(SELECT IF (Color2.value = 1, 1, '') FROM modx_ms2_product_options AS Color2 WHERE Color2.product_id = ProductData.id AND Color2.key = 'color_2') as 'Бежевый',
(SELECT IF (Color3.value = 1, 1, '') FROM modx_ms2_product_options AS Color3 WHERE Color3.product_id = ProductData.id AND Color3.key = 'color_3') as 'Бирюзовый',
(SELECT IF (Color4.value = 1, 1, '') FROM modx_ms2_product_options AS Color4 WHERE Color4.product_id = ProductData.id AND Color4.key = 'color_4') as 'Бордовый',
(SELECT IF (Color5.value = 1, 1, '') FROM modx_ms2_product_options AS Color5 WHERE Color5.product_id = ProductData.id AND Color5.key = 'color_5') as 'Ваниль',
(SELECT IF (Color6.value = 1, 1, '') FROM modx_ms2_product_options AS Color6 WHERE Color6.product_id = ProductData.id AND Color6.key = 'color_6') as 'Разноцветный',
(SELECT IF (Color7.value = 1, 1, '') FROM modx_ms2_product_options AS Color7 WHERE Color7.product_id = ProductData.id AND Color7.key = 'color_7') as 'Жёлтый',
(SELECT IF (Color8.value = 1, 1, '') FROM modx_ms2_product_options AS Color8 WHERE Color8.product_id = ProductData.id AND Color8.key = 'color_8') as 'Зелёный',
(SELECT IF (Color9.value = 1, 1, '') FROM modx_ms2_product_options AS Color9 WHERE Color9.product_id = ProductData.id AND Color9.key = 'color_9') as 'Коричневый',
(SELECT IF (Color10.value = 1, 1, '') FROM modx_ms2_product_options AS Color10 WHERE Color10.product_id = ProductData.id AND Color10.key = 'color_10') as 'Красный',
(SELECT IF (Color11.value = 1, 1, '') FROM modx_ms2_product_options AS Color11 WHERE Color11.product_id = ProductData.id AND Color11.key = 'color_11') as 'Кремовый',
(SELECT IF (Color12.value = 1, 1, '') FROM modx_ms2_product_options AS Color12 WHERE Color12.product_id = ProductData.id AND Color12.key = 'color_12') as 'Оранжевый',
(SELECT IF (Color13.value = 1, 1, '') FROM modx_ms2_product_options AS Color13 WHERE Color13.product_id = ProductData.id AND Color13.key = 'color_13') as 'Розовый',
(SELECT IF (Color14.value = 1, 1, '') FROM modx_ms2_product_options AS Color14 WHERE Color14.product_id = ProductData.id AND Color14.key = 'color_14') as 'Серый',
(SELECT IF (Color15.value = 1, 1, '') FROM modx_ms2_product_options AS Color15 WHERE Color15.product_id = ProductData.id AND Color15.key = 'color_15') as 'Синий',
(SELECT IF (Color16.value = 1, 1, '') FROM modx_ms2_product_options AS Color16 WHERE Color16.product_id = ProductData.id AND Color16.key = 'color_16') as 'Сиреневый',
(SELECT IF (Color17.value = 1, 1, '') FROM modx_ms2_product_options AS Color17 WHERE Color17.product_id = ProductData.id AND Color17.key = 'color_17') as 'Фиолетовый',
(SELECT IF (Color18.value = 1, 1, '') FROM modx_ms2_product_options AS Color18 WHERE Color18.product_id = ProductData.id AND Color18.key = 'color_18') as 'Черный',
(SELECT IF (Color19.value = 1, 1, '') FROM modx_ms2_product_options AS Color19 WHERE Color19.product_id = ProductData.id AND Color19.key = 'color_19') as 'Шоколадный',
(SELECT IF (Theme1.value = 1, 1, '') FROM modx_ms2_product_options AS Theme1 WHERE Theme1.product_id = ProductData.id AND Theme1.key = 'theme_1') as '3D-Эффект',
(SELECT IF (Theme2.value = 1, 1, '') FROM modx_ms2_product_options AS Theme2 WHERE Theme2.product_id = ProductData.id AND Theme2.key = 'theme_2') as 'Авто-мото',
(SELECT IF (Theme3.value = 1, 1, '') FROM modx_ms2_product_options AS Theme3 WHERE Theme3.product_id = ProductData.id AND Theme3.key = 'theme_3') as 'Авторский рисунок',
(SELECT IF (Theme4.value = 1, 1, '') FROM modx_ms2_product_options AS Theme4 WHERE Theme4.product_id = ProductData.id AND Theme4.key = 'theme_4') as 'Ангелы',
(SELECT IF (Theme5.value = 1, 1, '') FROM modx_ms2_product_options AS Theme5 WHERE Theme5.product_id = ProductData.id AND Theme5.key = 'theme_5') as 'Без ресунка',
(SELECT IF (Theme6.value = 1, 1, '') FROM modx_ms2_product_options AS Theme6 WHERE Theme6.product_id = ProductData.id AND Theme6.key = 'theme_6') as 'Геометрия',
(SELECT IF (Theme7.value = 1, 1, '') FROM modx_ms2_product_options AS Theme7 WHERE Theme7.product_id = ProductData.id AND Theme7.key = 'theme_7') as 'Города и страны',
(SELECT IF (Theme8.value = 1, 1, '') FROM modx_ms2_product_options AS Theme8 WHERE Theme8.product_id = ProductData.id AND Theme8.key = 'theme_8') as 'Детская тема',
(SELECT IF (Theme9.value = 1, 1, '') FROM modx_ms2_product_options AS Theme9 WHERE Theme9.product_id = ProductData.id AND Theme9.key = 'theme_9') as 'Животные',
(SELECT IF (Theme10.value = 1, 1, '') FROM modx_ms2_product_options AS Theme10 WHERE Theme10.product_id = ProductData.id AND Theme10.key = 'theme_10') as 'Знаки зодиака',
(SELECT IF (Theme11.value = 1, 1, '') FROM modx_ms2_product_options AS Theme11 WHERE Theme11.product_id = ProductData.id AND Theme11.key = 'theme_11') as 'Космос',
(SELECT IF (Theme12.value = 1, 1, '') FROM modx_ms2_product_options AS Theme12 WHERE Theme12.product_id = ProductData.id AND Theme12.key = 'theme_12') as 'Любовь',
(SELECT IF (Theme13.value = 1, 1, '') FROM modx_ms2_product_options AS Theme13 WHERE Theme13.product_id = ProductData.id AND Theme13.key = 'theme_13') as 'Морская тема',
(SELECT IF (Theme14.value = 1, 1, '') FROM modx_ms2_product_options AS Theme14 WHERE Theme14.product_id = ProductData.id AND Theme14.key = 'theme_14') as 'Музыка',
(SELECT IF (Theme15.value = 1, 1, '') FROM modx_ms2_product_options AS Theme15 WHERE Theme15.product_id = ProductData.id AND Theme15.key = 'theme_15') as 'Оригиналный сюжет',
(SELECT IF (Theme16.value = 1, 1, '') FROM modx_ms2_product_options AS Theme16 WHERE Theme16.product_id = ProductData.id AND Theme16.key = 'theme_16') as 'Праздники',
(SELECT IF (Theme17.value = 1, 1, '') FROM modx_ms2_product_options AS Theme17 WHERE Theme17.product_id = ProductData.id AND Theme17.key = 'theme_17') as 'Природа',
(SELECT IF (Theme18.value = 1, 1, '') FROM modx_ms2_product_options AS Theme18 WHERE Theme18.product_id = ProductData.id AND Theme18.key = 'theme_18') as 'Чёрный',
(SELECT IF (Theme19.value = 1, 1, '') FROM modx_ms2_product_options AS Theme19 WHERE Theme19.product_id = ProductData.id AND Theme19.key = 'theme_19') as 'Спорт',
(SELECT IF (Theme20.value = 1, 1, '') FROM modx_ms2_product_options AS Theme20 WHERE Theme20.product_id = ProductData.id AND Theme20.key = 'theme_20') as 'Узоры',
(SELECT IF (Theme21.value = 1, 1, '') FROM modx_ms2_product_options AS Theme21 WHERE Theme21.product_id = ProductData.id AND Theme21.key = 'theme_21') as 'Фрукты',
(SELECT IF (Theme22.value = 1, 1, '') FROM modx_ms2_product_options AS Theme22 WHERE Theme22.product_id = ProductData.id AND Theme22.key = 'theme_22') as 'Цветы',
ThisSell.value as 'ID С этим покупают',
IDAnalog.value as 'ID Аналоги',
IDRazmer.value as 'ID Размерный ряд',
IF (ProductData.new = 1, 1, '') as 'Новый',
IF (ActionKey.value = 1, 1, '') as 'Акция',
IF (Sale.value = 1, 1, '') as 'SALE',
IF (HIT.value = 1, 1, '') as 'HIT',
IF (Gift.value = 1, 1, '') as 'Подарок',
GROUP_CONCAT(DISTINCT Stickers.value ORDER BY Stickers.product_id ASC SEPARATOR '|') as 'Факультативный стикер',
GROUP_CONCAT(DISTINCT Podbor.value ORDER BY Podbor.product_id ASC SEPARATOR '|') as 'Коллекции',
STRINGDECODE(ProductData.tags, '|') as 'Теги',
ActionName.value as 'Название акции',
IF (BaseData.published = 1, 1, '') as 'Опубликован',
#Тут должен быть список связанных категорий
IF (Popularity.value = 1, 1, '') as 'Популярность',
PriorityMain.value as 'Приоритет для Главной',
PriorityCategory.value as 'Приоритет для Категорий'





FROM modx_ms2_products AS ProductData
INNER JOIN modx_site_content AS BaseData ON ProductData.id = BaseData.id
LEFT JOIN modx_ms2_vendors AS Vendor ON ProductData.vendor = Vendor.id
LEFT JOIN modx_ms2_product_options AS Brand ON ProductData.id = Brand.product_id AND Brand.key = 'brand'
LEFT JOIN modx_ms2_product_options AS Postavshik ON ProductData.id = Postavshik.product_id AND Postavshik.key = 'postavshik'
LEFT JOIN modx_ms2_product_files AS Gallery ON ProductData.id = Gallery.product_id AND Gallery.type = 'image' AND Gallery.path LIKE CONCAT(ProductData.id,'/')
LEFT JOIN modx_ms2_product_options AS Article2 ON ProductData.id = Article2.product_id AND Article2.key = 'article_2'
LEFT JOIN modx_ms2_product_options AS Article3 ON ProductData.id = Article3.product_id AND Article3.key = 'article_3'
LEFT JOIN modx_ms2_product_options AS SHCode ON ProductData.id = SHCode.product_id AND SHCode.key = 'shtrich-kod'
LEFT JOIN modx_ms2_product_options AS Cloth ON ProductData.id = Cloth.product_id AND Cloth.key = 'cloth'
LEFT JOIN modx_ms2_product_options AS ClothMat ON ProductData.id = ClothMat.product_id AND ClothMat.key = 'cloth_mat'
LEFT JOIN modx_ms2_product_options AS PlotnostCloth ON ProductData.id = PlotnostCloth.product_id AND PlotnostCloth.key = 'plotnost_cloth'
LEFT JOIN modx_ms2_product_options AS ClothCountry ON ProductData.id = ClothCountry.product_id AND ClothCountry.key = 'cloth_country'
LEFT JOIN modx_ms2_product_options AS ClothAdd ON ProductData.id = ClothAdd.product_id AND ClothAdd.key = 'cloth_add'
LEFT JOIN modx_ms2_product_options AS ClothMatAdd ON ProductData.id = ClothMatAdd.product_id AND ClothMatAdd.key = 'cloth_mat_add'
LEFT JOIN modx_ms2_product_options AS Size2 ON ProductData.id = Size2.product_id AND Size2.key = 'size_2'
LEFT JOIN modx_ms2_product_options AS CoinPododeal ON ProductData.id = CoinPododeal.product_id AND CoinPododeal.key = 'coin_pododeal'
LEFT JOIN modx_ms2_product_options AS Size1 ON ProductData.id = Size1.product_id AND Size1.key = 'size_1'
LEFT JOIN modx_ms2_product_options AS Size3 ON ProductData.id = Size3.product_id AND Size3.key = 'size_3'
LEFT JOIN modx_ms2_product_options AS NavolochCoint ON ProductData.id = NavolochCoint.product_id AND NavolochCoint.key = 'navoloch_coint'
LEFT JOIN modx_ms2_product_options AS Size4 ON ProductData.id = Size4.product_id AND Size4.key = 'size_4'
LEFT JOIN modx_ms2_product_options AS NavolochCoint2 ON ProductData.id = NavolochCoint2.product_id AND NavolochCoint2.key = 'navoloch_coint_2'
LEFT JOIN modx_ms2_product_options AS Upakovka ON ProductData.id = Upakovka.product_id AND Upakovka.key = 'upakovka'
LEFT JOIN modx_ms2_product_options AS LengthPack ON ProductData.id = LengthPack.product_id AND LengthPack.key = 'length_pack'
LEFT JOIN modx_ms2_product_options AS WidthPack ON ProductData.id = WidthPack.product_id AND WidthPack.key = 'width_pack'
LEFT JOIN modx_ms2_product_options AS HeightPack ON ProductData.id = HeightPack.product_id AND HeightPack.key = 'height_pack'
LEFT JOIN modx_ms2_product_options AS ZakupPrice ON ProductData.id = ZakupPrice.product_id AND ZakupPrice.key = 'zakup_price'
LEFT JOIN modx_ms2_product_options AS RecPrice ON ProductData.id = RecPrice.product_id AND RecPrice.key = 'rec_price'
LEFT JOIN modx_ms2_product_options AS PriceAfterAction ON ProductData.id = PriceAfterAction.product_id AND PriceAfterAction.key = 'price_after_action'
LEFT JOIN modx_ms2_product_options AS PriceAfterActionZak ON ProductData.id = PriceAfterActionZak.product_id AND PriceAfterActionZak.key = 'price_after_sale_zak'
LEFT JOIN modx_ms2_product_options AS Osobennosti1 ON ProductData.id = Osobennosti1.product_id AND Osobennosti1.key = 'osobennosti_1'
LEFT JOIN modx_ms2_product_options AS Osobennosti2 ON ProductData.id = Osobennosti2.product_id AND Osobennosti2.key = 'osobennosti_2'
LEFT JOIN modx_ms2_product_options AS Dekor ON ProductData.id = Dekor.product_id AND Dekor.key = 'dekor'
LEFT JOIN modx_ms2_product_options AS Ostatki ON ProductData.id = Ostatki.product_id AND Ostatki.key = 'ostatki'
LEFT JOIN modx_ms2_product_options AS ThisSell ON ProductData.id = ThisSell.product_id AND ThisSell.key = 'id_this_sell'
LEFT JOIN modx_ms2_product_options AS IDAnalog ON ProductData.id = IDAnalog.product_id AND IDAnalog.key = 'analog'
LEFT JOIN modx_site_tmplvar_contentvalues AS IDRazmer ON ProductData.id = IDRazmer.contentid AND IDRazmer.tmplvarid = 23
LEFT JOIN modx_ms2_product_options AS ActionKey ON ProductData.id = ActionKey.product_id AND ActionKey.key = 'action_key'
LEFT JOIN modx_ms2_product_options AS Sale ON ProductData.id = Sale.product_id AND Sale.key = 'sale'
LEFT JOIN modx_ms2_product_options AS HIT ON ProductData.id = HIT.product_id AND HIT.key = 'hit'
LEFT JOIN modx_ms2_product_options AS Gift ON ProductData.id = Gift.product_id AND Gift.key = 'gift'
LEFT JOIN modx_ms2_product_options AS Stickers ON ProductData.id = Stickers.product_id AND Stickers.key = 'stiskers'
LEFT JOIN modx_ms2_product_options AS Podbor ON ProductData.id = Podbor.product_id AND Podbor.key = 'podbor'
LEFT JOIN modx_site_tmplvar_contentvalues AS ActionName ON ProductData.id = ActionName.contentid AND ActionName.tmplvarid = 27
LEFT JOIN modx_ms2_product_options AS Popularity ON ProductData.id = Popularity.product_id AND Popularity.key = 'popularity'
LEFT JOIN modx_site_tmplvar_contentvalues AS PriorityMain ON ProductData.id = PriorityMain.contentid AND PriorityMain.tmplvarid = 21
LEFT JOIN modx_site_tmplvar_contentvalues AS PriorityCategory ON ProductData.id = PriorityCategory.contentid AND PriorityCategory.tmplvarid = 22


#Условие
WHERE BaseData.parent = 13

#Группировка
GROUP BY ProductData.id