Товары склад ДОК

SELECT *
FROM yii_doc.supplier_price sp
LEFT JOIN yii_doc.supplier_price_avalaible spa ON spa.hash = sp.hash
WHERE supplier = '38'
  AND spa.avalaible > 0;