set @date_start = "2020-10-01";
set @date_finish = "2020-12-31";

		select
		pa.id pa_id,
		f.brand,
		f.art_num,
		sum(IF(i.prihod_kor > 0, i.prihod_kor, i.prihod)) income,
		dg.name_ru category,
		max(if(pb.barcode is not null, 1, 0)) barcode
		from fin.fin_in f
		left join fin.invoice_fin i on i.fin_id = f.id
		left join order_product op on f.product_id = op.id
		left join prices_all pa on pa.id = op.price_all_id
		left join (SELECT dg.GA_ID, MAX(dg.name_ru) name_ru FROM dok_ga dg GROUP BY dg.GA_ID) dg on dg.GA_ID = pa.pa_ga_id_search
		left join (SELECT pb.pa_id, MAX(pb.barcode) barcode FROM prices_all_barcodes pb GROUP BY pb.pa_id) pb on pb.pa_id = pa.id
		where date_prihod between @date_start and @date_finish /* AND f.art_num = 'WA9581' */
		group by pa_id