SELECT spa.id
     , spa.avalaible
     , spt.id
     , spt.name AS supplier_name
     , pa.*
FROM yii_doc.prices_all pa
LEFT JOIN yii_doc.supplier_price sp ON sp.art_num = pa.art_num
    AND sp.brand_id = pa.brand_id
LEFT JOIN yii_doc.supplier_price_avalaible spa ON spa.hash = sp.hash
LEFT JOIN yii_doc.supplier_pattern spt ON spt.id = sp.supplier
WHERE pa.id = 1106289
  AND spa.id IS NOT NULL;