Home > Detailed search > Private practice of Ophthalmology
Detailed search
Got error 28 from storage engineselect
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 "Private practice of Ophthalmology" ) 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 = "30294" )
group by c.eredeti_id
order by p.pozicio is null, p.pozicio, c.hirdmeret desc
limit 150
