Запрос на выявление дублей товаров в прайсах

SELECT pa.id AS pa_id_for_deactivate
     , pa2.id
     , pa.art_num
     , pa2.art_num
     , ba.id
     , ba2.id
     , ba.NAME_BRANDS
     , ba2.NAME_BRANDS
     , pa.pa_ga_id_search
     , pa2.pa_ga_id_search
     , pa.avalaible_gen
     , pa2.avalaible_gen
FROM yii_doc.prices_all pa
LEFT JOIN yii_doc.brand_all ba ON ba.id = pa.brand_id
LEFT JOIN yii_doc.brand_all ba2 ON ba2.parent_id = ba.id
LEFT JOIN wms.prices_all_new_cats pc ON pc.brand_id = ba2.id AND pc.art_num = pa.art_num
LEFT JOIN yii_doc.prices_all pa2 ON pa2.id = pc.pa_id
LEFT JOIN yii_doc.forbidden_search_ga fga ON fga.ga_id = pa.pa_ga_id_search AND fga.forbidden_in_big_index = true
LEFT JOIN yii_doc.forbidden_search_ga fga2 ON fga2.ga_id = pa2.pa_ga_id_search AND fga2.forbidden_in_big_index = true
WHERE 1 =1
  AND pa2.id IS NOT NULL
  AND pa.id <> pa2.id
  AND ba.id <> ba2.id
  AND pa.pa_ga_id_search IS NOT NULL
  AND pa.avalaible_gen <> 2
  AND pa2.avalaible_gen <> 2
  AND fga.ga_id IS NULL
  AND fga2.ga_id IS NULL