CREATE OR REPLACE  ALGORITHM = MERGE VIEW dwh_products_attributes AS

SELECT
     pa.products_attributes_id AS products_attributes_id -- 'ID атрибута товара (в акции)'
    , p.products_id AS products_id -- 'ID товара (в акции)'
    , IFNULL(p.products_model,'') AS products_article -- 'Артикул (Мамси)'
    , IFNULL(pa.article_supplier,'') AS products_attributes_article -- 'Артикул (поставщика)'
    , pd.products_name_label AS products_name -- 'Наименование товара на сайте'
    , pa.attributes_convolution AS products_attributes_convolution
    , IFNULL(p.brandswelove_id,0) AS brandswelove_id
    , pa.products_status AS products_attributes_status_id
    , p.products_quantity_min AS products_quantity_min -- 'Минимальное кол-во для заказа, шт.'
    , p.products_quantity_max AS products_quantity_max -- 'Максимальное кол-во для заказа, шт.'
    , p.entities_types_id AS products_entities_types_id
    , COALESCE(pa.attributes_stock_log, pa.attributes_stock, 0) + COALESCE(pa.attributes_stock_added, 0) AS products_attributes_reserve_quantity -- 'Резерв, шт.'

    ,ifnull(pcpc.name, '') AS country_production
    ,ifnull(pcdc.name, '') AS country_design

    , IFNULL(pao01.products_options_values_id, 0) AS pov01_id
    , IFNULL(pao02.products_options_values_id, 0) AS pov02_id
    , IFNULL(pao03.products_options_values_id, 0) AS pov03_id
    , IFNULL(pao04.products_options_values_id, 0) AS pov04_id
    , IFNULL(pao05.products_options_values_id, 0) AS pov05_id
    , IFNULL(pao06.products_options_values_id, 0) AS pov06_id
    , IFNULL(pao07.products_options_values_id, 0) AS pov07_id
    , IFNULL(pao08.products_options_values_id, 0) AS pov08_id
    , IFNULL(pao09.products_options_values_id, 0) AS pov09_id
    , IFNULL(pao10.products_options_values_id, 0) AS pov10_id
    , IFNULL(pao11.products_options_values_id, 0) AS pov11_id
    , IFNULL(pao12.products_options_values_id, 0) AS pov12_id
    , IFNULL(pao13.products_options_values_id, 0) AS pov13_id
    , IFNULL(pao14.products_options_values_id, 0) AS pov14_id
    , IFNULL(pao15.products_options_values_id, 0) AS pov15_id
    , IFNULL(pao16.products_options_values_id, 0) AS pov16_id
    , IFNULL(pao17.products_options_values_id, 0) AS pov17_id
    , IFNULL(pao18.products_options_values_id, 0) AS pov18_id
    , IFNULL(pao19.products_options_values_id, 0) AS pov19_id
    , IFNULL(pao20.products_options_values_id, 0) AS pov20_id
    , IFNULL(pao21.products_options_values_id, 0) AS pov21_id
    , IFNULL(pao22.products_options_values_id, 0) AS pov22_id
    , IFNULL(pao23.products_options_values_id, 0) AS pov23_id
    , IFNULL(pao24.products_options_values_id, 0) AS pov24_id
    , IFNULL(pao25.products_options_values_id, 0) AS pov25_id
    , IFNULL(pao26.products_options_values_id, 0) AS pov26_id
    , IFNULL(pao27.products_options_values_id, 0) AS pov27_id
    , IFNULL(pao28.products_options_values_id, 0) AS pov28_id
    , IFNULL(pao29.products_options_values_id, 0) AS pov29_id
    , IFNULL(pao30.products_options_values_id, 0) AS pov30_id
    , IFNULL(pao31.products_options_values_id, 0) AS pov31_id
    , IFNULL(pao32.products_options_values_id, 0) AS pov32_id
    , IFNULL(pao33.products_options_values_id, 0) AS pov33_id
    , IFNULL(pao34.products_options_values_id, 0) AS pov34_id
    , IFNULL(pao35.products_options_values_id, 0) AS pov35_id
    , IFNULL(pao36.products_options_values_id, 0) AS pov36_id
    , IFNULL(pao37.products_options_values_id, 0) AS pov37_id
    , IFNULL(pao38.products_options_values_id, 0) AS pov38_id
FROM products_attributes AS pa
JOIN dwh_products_attributes_modified as pam ON pam.products_attributes_id = pa.products_attributes_id
JOIN products AS p ON p.products_id = pa.products_id
JOIN products_description AS pd ON pd.products_id = p.products_id

LEFT JOIN products_countries AS pcp ON pcp.products_id = p.products_id AND pcp.type = 'production'
LEFT JOIN country AS pcpc ON pcpc.country_id = pcp.country_id

LEFT JOIN products_countries pcd ON pcd.products_id = p.products_id AND pcd.type = 'design'
LEFT JOIN country pcdc ON pcdc.country_id = pcd.country_id

LEFT JOIN products_attributes_options AS pao01  ON pao01.products_attributes_id = pa.products_attributes_id AND pao01.products_options_id = 1
LEFT JOIN products_attributes_options AS pao02  ON pao02.products_attributes_id = pa.products_attributes_id AND pao02.products_options_id = 2
LEFT JOIN products_attributes_options AS pao03  ON pao03.products_attributes_id = pa.products_attributes_id AND pao03.products_options_id = 3
LEFT JOIN products_attributes_options AS pao04  ON pao04.products_attributes_id = pa.products_attributes_id AND pao04.products_options_id = 4
LEFT JOIN products_attributes_options AS pao05  ON pao05.products_attributes_id = pa.products_attributes_id AND pao05.products_options_id = 5
LEFT JOIN products_attributes_options AS pao06  ON pao06.products_attributes_id = pa.products_attributes_id AND pao06.products_options_id = 6
LEFT JOIN products_attributes_options AS pao07  ON pao07.products_attributes_id = pa.products_attributes_id AND pao07.products_options_id = 7
LEFT JOIN products_attributes_options AS pao08  ON pao08.products_attributes_id = pa.products_attributes_id AND pao08.products_options_id = 8
LEFT JOIN products_attributes_options AS pao09  ON pao09.products_attributes_id = pa.products_attributes_id AND pao09.products_options_id = 9
LEFT JOIN products_attributes_options AS pao10  ON pao10.products_attributes_id = pa.products_attributes_id AND pao10.products_options_id = 10
LEFT JOIN products_attributes_options AS pao11  ON pao11.products_attributes_id = pa.products_attributes_id AND pao11.products_options_id = 11
LEFT JOIN products_attributes_options AS pao12  ON pao12.products_attributes_id = pa.products_attributes_id AND pao12.products_options_id = 12
LEFT JOIN products_attributes_options AS pao13  ON pao13.products_attributes_id = pa.products_attributes_id AND pao13.products_options_id = 13
LEFT JOIN products_attributes_options AS pao14  ON pao14.products_attributes_id = pa.products_attributes_id AND pao14.products_options_id = 14
LEFT JOIN products_attributes_options AS pao15  ON pao15.products_attributes_id = pa.products_attributes_id AND pao15.products_options_id = 15
LEFT JOIN products_attributes_options AS pao16  ON pao16.products_attributes_id = pa.products_attributes_id AND pao16.products_options_id = 16
LEFT JOIN products_attributes_options AS pao17  ON pao17.products_attributes_id = pa.products_attributes_id AND pao17.products_options_id = 17
LEFT JOIN products_attributes_options AS pao18  ON pao18.products_attributes_id = pa.products_attributes_id AND pao18.products_options_id = 18
LEFT JOIN products_attributes_options AS pao19  ON pao19.products_attributes_id = pa.products_attributes_id AND pao19.products_options_id = 19
LEFT JOIN products_attributes_options AS pao20  ON pao20.products_attributes_id = pa.products_attributes_id AND pao20.products_options_id = 20
LEFT JOIN products_attributes_options AS pao21  ON pao21.products_attributes_id = pa.products_attributes_id AND pao21.products_options_id = 21
LEFT JOIN products_attributes_options AS pao22  ON pao22.products_attributes_id = pa.products_attributes_id AND pao22.products_options_id = 22
LEFT JOIN products_attributes_options AS pao23  ON pao23.products_attributes_id = pa.products_attributes_id AND pao23.products_options_id = 23
LEFT JOIN products_attributes_options AS pao24  ON pao24.products_attributes_id = pa.products_attributes_id AND pao24.products_options_id = 24
LEFT JOIN products_attributes_options AS pao25  ON pao25.products_attributes_id = pa.products_attributes_id AND pao25.products_options_id = 25
LEFT JOIN products_attributes_options AS pao26  ON pao26.products_attributes_id = pa.products_attributes_id AND pao26.products_options_id = 26
LEFT JOIN products_attributes_options AS pao27  ON pao27.products_attributes_id = pa.products_attributes_id AND pao27.products_options_id = 27
LEFT JOIN products_attributes_options AS pao28  ON pao28.products_attributes_id = pa.products_attributes_id AND pao28.products_options_id = 28
LEFT JOIN products_attributes_options AS pao29  ON pao29.products_attributes_id = pa.products_attributes_id AND pao29.products_options_id = 29
LEFT JOIN products_attributes_options AS pao30  ON pao30.products_attributes_id = pa.products_attributes_id AND pao30.products_options_id = 30
LEFT JOIN products_attributes_options AS pao31  ON pao31.products_attributes_id = pa.products_attributes_id AND pao31.products_options_id = 31
LEFT JOIN products_attributes_options AS pao32  ON pao32.products_attributes_id = pa.products_attributes_id AND pao32.products_options_id = 32
LEFT JOIN products_attributes_options AS pao33  ON pao33.products_attributes_id = pa.products_attributes_id AND pao33.products_options_id = 33
LEFT JOIN products_attributes_options AS pao34  ON pao34.products_attributes_id = pa.products_attributes_id AND pao34.products_options_id = 34
LEFT JOIN products_attributes_options AS pao35  ON pao35.products_attributes_id = pa.products_attributes_id AND pao35.products_options_id = 35
LEFT JOIN products_attributes_options AS pao36  ON pao36.products_attributes_id = pa.products_attributes_id AND pao36.products_options_id = 36
LEFT JOIN products_attributes_options AS pao37  ON pao37.products_attributes_id = pa.products_attributes_id AND pao37.products_options_id = 37
LEFT JOIN products_attributes_options AS pao38  ON pao38.products_attributes_id = pa.products_attributes_id AND pao38.products_options_id = 38

;