2024.11.24 Sunday Emma
 
FAST SEARCH DETAILED SEARCH Search of certificate of incorporation EUROPEAN LEVEL SEARCH OUR PRODUCTS USEFUL INFORMATION ABOUT US JOB CONTACT  

RELATED
CLASSIFICATION INDEX

English teaching English education Scuba Diving Lessons Photo education IT training R & D education art education German language Teaching Education education, education management Educational resources Educational applications Education organization education methodology Italian language sports tuition Tennis training Fire Protection Fire-fighting equipment Fire-fighting tool Fire-fighting equipment Interface fire protection investigation Fire Protection Publication Fire protection education Fire protection systems Fire Protection Regulations Fire Protection Exam Fire protection specialist examination Fire protection inspection Fire protection board Music education music tuition Fire doors Steel doors, fire-fighting Teaching Reservation Individual tennis training Group tennis training adult tennis kids tennis Education, demonstration tools Fishing Education High level of education High level of English education Arabic language training Finnish language teaching Dog training Remedial education Fire-fighting advice Corporate language training Pre-school education English-speaking pre-school education Pre-school swimming lessons Business education English education English training for companies Adult advice and expertise Adult education advice Adult Forensic Advice educational institutions Public education as experts Public education proposals Preparing proposals for Public Education Making public education project Extra-curricular education Hungarian language education Literature education History of education Bentley products education Manufacture of fire-fighting signs Distribution of fire-fighting signs Fire Protection Catalog Intensive German grammar school education German-speaking children and education German-speaking children in primary education Ministry of Education and Culture Private teaching Intensive language training Grammar-school education General education is idiomatic END corporate language training Hungarian as a foreign language Wall hole Fire Protection Educational furniture Teaching aid Educational model Design of fire protection equipment Shop work and fire safety Fire safety signs Education Diary Safety Education Preparation work and fire protection regulations Fire Monitoring Station



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 "Fire protection education" ) 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 = "15686" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150