|   Căutare detaliatăGot error 28 from storage engine
 select 
			c.eredeti_id ceg_id, c.cegnev, c.irsz,  c.utca, c.email,c.web, 
			c.tel_korzet, c.tel_szam,
			c.tel2_korzet, c.tel2_szam,
			c.fax_korzet, c.fax_szam, c.mobil_korzet, c.mobil_szam, 
			c.fax2_korzet, c.fax2_szam, c.mobil2_korzet, c.mobil2_szam, 
			c.webaruhaz, c.blog, 
			c.kiemelt, c.kulcsszo, 
			c.ajanlatURL,
			c.web2, c.email2, c.skype, c.logo,
			v.megnev varos_nev,
			c.egyk k_id , c.eredeti_id vi_id , p.pozicio
		from ceg c		
		left join varos v on c.varos_id = v.varos_id
		left join megye m on v.megye_id = m.megye_id
		left join k_ceg_cimszo k on c.eredeti_id = k.ceg_id
		left join cimszo sz on sz.eredeti_id = k.cimszo_id
		left join 
				pozicio p on 
				p.partner=c.eredeti_id and 
				(0 or p.fogalom like "Difuzor" ) and now()>=p.tol and now()<=ig where k.cimszo_id=sz.eredeti_id and c.eredeti_id=k.ceg_id and (  sz.eredeti_id = "34845"  )
		group by c.eredeti_id
		order by p.pozicio is null, p.pozicio, c.hirdmeret desc
		limit 150
 |