#  Компания Keyword / Фид Marka
SELECT
       "DEA-Marka-rus" AS campaignName,
       CONCAT(m.marka_name, "#", kw.`language`) AS `adGroupName`,
       CONCAT("+", REPLACE(REPLACE(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(kw.keyword,
                                                                        "[VCH]", vch.VCH_synonym),
                                                                "[marka_en]", mas.marka_synonym),
                                                        "[marka_rus]", mas.marka_synonym),
                                                "[attractor]", IFNULL(att.attractor,""))),
                                   " ", " +"), ",", ".")) AS keyword,
       "Broad" AS keyword_match_type,
       MD5(
           CONCAT_WS(
               '+'
               , CONCAT("+", REPLACE(REPLACE(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(kw.keyword,
                                                                                  "[VCH]", vch.VCH_synonym),
                                                                          "[marka_en]", mas.marka_synonym),
                                                                  "[marka_rus]", mas.marka_synonym),
                                                          "[attractor]", IFNULL(att.attractor,""))),
                                             " ", " +"), ",", "."))
               , "Broad"
               , CONCAT(m.marka_name, "#", kw.`language`)
               , "DEA-Marka-rus"

       )) AS DOK_keyword_ID
FROM
       yii_doc.adwords_plitka AS p
              INNER JOIN ppc.model AS m ON p.model = m.seo_model_id
              LEFT JOIN ppc.model_synonyms AS mos ON p.model = mos.seo_model_id
              LEFT JOIN ppc.marka_synonyms AS mas ON p.marka = mas.seo_marki_id AND mos.`language` = mas.`language` -- язык марки совпадает с языком модели
              LEFT JOIN ppc.keyword AS kw ON mos.`language` = kw.`language` AND kw.campaign_type = "Marka"
              LEFT JOIN ppc.attractor AS att ON kw.attractor = att.is_for_Z
              CROSS JOIN ppc.VCH_synonyms AS vch
GROUP BY 1,2,3
HAVING keyword IS NOT NULL;



 #  Компания Ads / Фид Marka
SELECT
       "DEA-Marka-rus" AS campaignName,
       CONCAT(m.marka_name, "#", ad.`language`) AS adGroupName,
       REPLACE(ad.headline_1, "[m.marka_name]", IF(ad.`language`="en", m.marka_en_ads, m.marka_rus_ads)) AS headline1,
       ad.headline_2 headline2,
       REPLACE(ad.description, "[m.marka_name]", IF(ad.`language`="en", m.marka_name, m.marka_rus_ads)) AS description1,
       ad.path_1 AS path1,
       REPLACE(IF(ad.`language`="en",m.marka_en_ads,m.marka_rus_ads), "/", " ") AS path2,
       SUBSTRING_INDEX(p.url,"/",5) AS finalUrl,
       "active" AS ads_status,
       MD5(
         CONCAT_WS(
           '+'
           , REPLACE(ad.headline_1, "[m.marka_name]", IF(ad.`language`="en", m.marka_en_ads, m.marka_rus_ads))
           , REPLACE(ad.description, "[m.marka_name]", IF(ad.`language`="en", m.marka_name, m.marka_rus_ads))
           , SUBSTRING_INDEX(p.url,"/",5)
           , ad.path_1
           , REPLACE(IF(ad.`language`="en",m.marka_en_ads,m.marka_rus_ads), "/", " ")
           , CONCAT(m.marka_name, "#", ad.`language`)
           , "DEA-Marka-rus"
          )
       ) AS DOK_Ads_ID
FROM yii_doc.adwords_plitka AS p
       INNER JOIN ppc.model m ON p.model = m.seo_model_id
       INNER JOIN ppc.zapchast z ON p.zapchast = z.seo_izdelie_id AND z.is_catalog = 1 AND z.is_redirected = 0
       CROSS JOIN (SELECT * FROM ppc.advertisement WHERE campaign_type = "Marka") AS ad
GROUP BY campaignName, adGroupName, ad.id;