INSERT IGNORE INTO yii_doc.price_sku (price_id, pa_id, is_active, comment)
SELECT sp.id
     , pa.id
     , 1
     , 'auto vitrina (IT fix)'
FROM yii_doc.supplier_price sp
LEFT JOIN yii_doc.price_sku ps ON ps.price_id = sp.id
LEFT JOIN yii_doc.char_text ct1 ON ct1.text_hash = MD5(sp.art_num)
LEFT JOIN yii_doc.char_text ct2 ON ct2.text = sp.art_num
LEFT JOIN yii_doc.char_text ct ON ct.id = IFNULL(ct1.id, ct2.id)
LEFT JOIN yii_doc.char_art ca ON ca.ca_char_text_id = ct.id
LEFT JOIN yii_doc.`char` c ON c.id = ca.ca_char_id
    AND c.cha_type = 't'
LEFT JOIN yii_doc.prices_all pa ON pa.id = ca.ca_pa_id
WHERE sp.isMarketplace = 0
  AND sp.supplier = '42'
  AND ps.price_id IS NULL
  AND c.id IS NOT NULL
  AND pa.id IS NOT NULL