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 Diving equipment Diving school Scuba Diving Lessons Diving technique Diving shop Diving Computer diving accessories, divers Diving school Diver training Diving Scuba-diving session Diving Program Diving Diving Diving Tour Diving trips Photo education IT training R & D education Scuba art education German language Teaching Education education, education management Educational resources Educational applications Education organization education methodology Italian language Sport Diver sports tuition Tennis training Fire protection education Music education music tuition Teaching Reservation Individual tennis training Group tennis training adult tennis kids tennis Copra diving pump Education, demonstration tools Fishing Education High level of education High level of English education Arabic language training Finnish language teaching Dog training Remedial education 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 Intensive German grammar school education German-speaking children and education German-speaking children in primary education Pumps Submersible Ministry of Education and Culture Diving Private teaching Intensive language training Grammar-school education General education is idiomatic END corporate language training Hungarian as a foreign language Educational furniture Teaching aid Educational model Education Diary Submersible budapest Safety Education



Horn Magyarország

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 "Scuba Diving Lessons" ) 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 = "17110" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150