select g.id, pr.price, ifnull(pic1.fname, pic2.fname) as pic,  g.name as name, p.name as parname,
		ifnull(g.text_begin, p.text_begin) as descript, rg.yname,
		rg.artik as vendorid,
		mpar.mparams,
                pp.add as pricedeliv,
				concat(fv3.tid, '_', case when fv1.flt_id=fv2.flt_id then fv1.tid else fv2.tid end, 
'/', case when ifnull(g.tid,'')!='' then g.tid else g.id end) as tflt,
		ifnull(fv1.txt_value, fv2.txt_value) as brand, ifnull(fv1.text2, fv2.text2) as country,
		fv3.id as cat,
		ifnull(fv1.ym, fv2.ym) as brand2,
		fv3.txt_value as categ
from 
goods g 

left join goods p on p.id = g.parent

		left join (pictures pic1,pictures_goods pg1) on g.id=pg1.good_id and pic1.type='foto' and pic1.id=pg1.pic_id
		left join (pictures pic2,pictures_goods pg2) on g.parent=pg2.good_id and pic2.type='foto' and pic2.id=pg2.pic_id
		join (price pr) on g.id=pr.good_id and pr.type='out' and pr.coun=0  and pr.price>1 
		left join (remains_goods rg) on g.id=rg.good_id 
		left join (goods_filters gf1) on g.id=gf1.good_id and gf1.flt_id=3
		left join (filters_values fv1) on gf1.value=fv1.id 
		left join (goods_filters gf2) on p.id=gf2.good_id and gf2.flt_id=3
		left join (filters_values fv2) on gf2.value=fv2.id
		
		left join (goods_filters gf3) on p.id=gf3.good_id and gf3.flt_id=1
		left join (filters_values fv3) on gf3.value=fv3.id 
		left join (price_params pp) on pp.type=fv3.id and pp.brand=ifnull(fv1.id, fv2.id)
								 and (pr.price between pp.mini and pp.maxi)
		,
			(select vals.gid id, group_concat( distinct case when (vals.flt_id is null or vals.srt=-1) then null else
			concat(vals.name, '=', ifnull(vals.int_value, ifnull(vals.ym, vals.txt_value)),'||' , vals.ed, '||', digits)
			  end  order by vals.srt separator ';' ) mparams
				 from (
				  select g.id gid,
				  group_concat(distinct ifnull(fv.txt_value,fv2.txt_value) order by c.srt separator ', ') txt_value,
				  group_concat(distinct ifnull(fv.text2,fv2.text2) order by fv.srt,fv2.srt separator ' ') text2,
				  group_concat(distinct ifnull(fv.ym,fv2.ym) order by fv.srt,fv2.srt separator ' ') ym,
				  
				 ifnull(gf.int_value, gf2.int_value) int_value,
				 ifnull(gf.flt_id, gf2.flt_id) flt_id,
				c.tid, c.name, f.ed, c.srt, c.digits
				from
				(goods g, cat_filters c, filters f)
				left join goods_filters gf  on gf.good_id=g.id and c.flt_id=gf.flt_id
				left join filters_values fv on fv.id=gf.value
				left join goods_filters gf2  on gf2.good_id=g.parent and c.flt_id=gf2.flt_id
				left join filters_values fv2 on fv2.id=gf2.value
				where
				g.parent is not null
				and c.type =7
				and c.mflt in(select value from goods_filters gff where g.parent=gff.good_id and gff.flt_id=1 )
				and c.flt_id=f.id
				and c.`srt`>-1
				and case when f.type=5 then fv.tid=substring_index(c.tid,'/',-1) else 1=1 end
				and g.id in(select good_id from remains where num>2)
				group by g.id, c.tid,case when f.type=5 then gf.value else '' end

				 ) vals
				group by vals.gid
				) mpar
 
		WHERE

 g.active=1
 and p.active=1

 and g.parent in(select good_id from goods_filters gf, filters_values fv where fv.flt_id=1 and ifnull(fv.ym,'')!='' and fv.id=gf.value)
 and g.id in(select good_id from remains_goods)
 
 group by g.id