SELECT
	IF (ss.id IN (20, 24), 1, 0) AS 'isDOK',
	IF (ss.isKyiv = 1 AND spa.avalaible >= 2, 1, 0) AS 'isKIEV',
	IF (ss.no_active_price IS NULL AND spa.avalaible >= 1, 1, 0) AS 'inUKR',
	IF (pa.pod_zakaz = 1, 1, 0) AS 'podZAKAZ',
	IF (pa.avalaible_gen = 2 OR spa.avalaible = 0, 1, 0) AS 'NONE'

	,'-----------' AS 'delim'

	,pa.id AS 'PA_ID'
	,ss.id
	,ss.isKyiv
	,spa.avalaible
	,ss.no_active_price
	,pa.pod_zakaz
	,pa.avalaible_gen
FROM prices_all pa
LEFT JOIN supplier_price sp ON pa.art_num = sp.art_num AND pa.brand_id = sp.brand_id
LEFT JOIN supplier_price_avalaible spa ON sp.`hash` = spa.`hash`
INNER JOIN supplier_storage ss ON spa.storage_id = ss.id
GROUP BY pa.id
-- LIMIT 100