Номенклатура для Unified Search (Laximo)

SET @operation_uuid = UUID();
INSERT IGNORE INTO laximo.new_vincode_widget_nomenklatura_log (brand, oem, name_ru_RU, vendor_code, tags, operation_uuid)
SELECT IFNULL(b_syn.synonym_name, ba.NAME_BRANDS) AS brand
     , pa.art_num AS oem
     , (
         SELECT GROUP_CONCAT(DISTINCT ga.name_ru)
         FROM yii_doc.dok_ga ga
         WHERE ga.GA_ID = pa.pa_ga_id_search
     ) AS name_ru_RU
     , pa.id AS vendor_code
     , LOWER(
         IFNULL(
             (
                 SELECT GROUP_CONCAT(tags.tag ORDER BY id SEPARATOR ' ')
                 FROM laximo.new_vincode_widget_pa_tags tags
                 WHERE tags.ga_id = pa.pa_ga_id_search
                 GROUP BY tags.ga_id
             )
             , (
                 SELECT GROUP_CONCAT(DISTINCT ga.name_ru)
                 FROM yii_doc.dok_ga ga
                 WHERE ga.GA_ID = pa.pa_ga_id_search
             )
         )
     ) AS tags
     , @operation_uuid
FROM yii_doc.prices_all pa
LEFT JOIN yii_doc.brand_all ba ON ba.id = pa.brand_id
LEFT JOIN laximo.new_vincode_widget_brand_synonyms b_syn ON b_syn.brand_id = ba.id
LEFT JOIN laximo.new_vincode_widget_pa_tags tags ON tags.ga_id = pa.pa_ga_id_search
WHERE 1 = 1
  AND pa.brand_id NOT IN (0, 9999)
  AND pa.brand_id IS NOT NULL
#   AND pa.brand_id IN (2268, 10368)
#   AND pa.pa_ga_id_search IN (70)
  AND EXISTS(
      SELECT ga.id
      FROM yii_doc.dok_ga ga
      WHERE ga.GA_ID = pa.pa_ga_id_search
  )
  AND (
#     Категории, выбранные для эксперимента и
#         которые находятся в файле
#         (https://docs.google.com/spreadsheets/d/1Zz6DP_R5I9f9pQZ5DKvCP6p7eP-BPdyqHY0DUcDs_0U/edit#gid=0)
    EXISTS(
        SELECT rel.id
        FROM laximo.mvp_ga_matches rel
        WHERE rel.GA_ID = pa.pa_ga_id_search
    );