SELECT
	spd.art_num AS 'SP_ART_NUM',
	spd.brand_id AS 'SP_BRAND_ID',
	pa.art_num AS 'PA_ART_NUM',
	pa.brand_id AS 'PA_BRAND_ID',
	pa.id,
	spd.supplier
FROM `supplier_price_duplicate` spd
LEFT JOIN prices_all pa
ON spd.art_num = pa.art_num
AND spd.brand_id = pa.brand_id

WHERE pa.id IS NULL
AND (spd.brand_id IS NOT NULL AND spd.brand_id <> 0)
AND spd.art_num IS NOT NULL