2025.08.14 Thursday Marcell
 
FAST SEARCH DETAILED SEARCH Search of certificate of incorporation EUROPEAN LEVEL SEARCH OUR PRODUCTS USEFUL INFORMATION ABOUT US JOB CONTACT  

RELATED
CLASSIFICATION INDEX

shaft-sinking underground construction shaft drilling, boring Freezing Frozen bakery products frozen goods personal transport Passenger bodyguards personnel advice Personnel training car purchase drive deep garages To detect hidden persons Holding civil engineering frozen meat Automatic person identification Double chair Security and protection work International passenger luxury bus Domestic passenger luxury bus Cleaning deep garages Staff functions Deep carpet washing Automobile brake EU passenger bus operator comfort Residential care for disabled persons lakóotthonos care of persons with disabilities day care for people with disabilities Digging deep Civil engineering work személytanúsítás Personalized partner Standard vehicle disc translator Personal management consulting Wedding passenger Domestic passenger Foreign passengers Private and business passenger Tailor-made security service Elevator Privacy Car rental Kecskemét PRIMER Save underground garage Save underground garage OTP personal loan Personal Copiers Frozen Vegetables Chilled fruit Frozen vegetables Frozen fruit Frozen Vegetables Civil engineering technician training Personal Assistant Customer Service Training Personalized Automation Personalized advice Frozen prepared meals Personal trainer training Work of Art building, civil engineering major projects Kuti deep pump Deep well pumps Passenger car production Manufacture of cutting tools, drawing Domestic passenger transport by bus Weddings, events, transportation of persons conducting International passenger transportation by bus Maintenance Lifts Cars and minibuses rent Personally, Property Protection and Private Detectives Association,



Home > Detailed search > Digging deep
Céginformáció

Detailed search

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 "Digging deep" ) 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 = "26582" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150