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

Andragogy Driving school driving schools Diving school Diving school University Universities universities Nursery seedling nursery universities Photo School School School home School furniture school furniture School furniture schools school accessories R & D education high schools Private school language schools, teachers of foreign languages Education education, education management Educational resources Education organization education methodology flying tuition, flying schools technical training dance and dance schools Music education Self-knowledge training English language German language Language School Courses Academic preparation Schools collection Education, demonstration tools Blackboard paint German-language schools Driving school Miskolc Fine Art Glass Design Fine Arts Dog School Remedial education Schools Cleaning Professional cleaners School paper and stationery Business education Primary school children magazines nursery products Driving school Budapest Trainings Mechanical technician training Economic IT training Advertising contact training Hospitality, Tourism Executive Training Sales Training Team training Personal management consulting Banking training Trade Training German private school German-speaking children in primary education Of graft School glassware Trade School Catering School Tourism School Tourism Foundation School School of Commerce Foundation Foundation School Catering Kindergarten teacher correspondence course IT training librarian Art education Professional painter Graphic department Electronic graphic training Animation department Applied photographic department Full-time Training Vocational School of Fine Arts Second degree PR course administrator Chimney mechanic course Massage therapy course Communication self-recognition training Food for sale Children and Youth supervisor training IT Commercial administrator Accredited adult education Training Programmer training Special body treatment courses Beautician Courses tattoo Legal Assistant Training Ophthalmic screening at school General education system Static IT Training Hospitality and tourism management from training Commercial Training Manager Tuition-free qualification European Union Business Department Manager Small-and Medium-Sized Business Manager Training Foreign Sales management training Advertising management from organizing training Foreign Trade Sales Training Marketing and advertising executive course Training Administrator Static and Economic Planning of IT Training Foreign Economic Sales Training Food technical school Agricultural vocational school Kenessey Gerjen Albert Primary School Tax Advisor Training Purchasing training Banking, investment product sales training Payroll Administrator Training Stenographer training Insurance Advisory Training Shop assistant, store manager training Typing, word processing training Children's assistant training Childcare training Hosstes training Secretary of Foreign Training Office assistant training Commercial Training Manager Foreign Economic Administrator Training Logistics Manager Training International Transportation Manager Training Fruit and vegetable seller Dangerous executive course Currency and the Treasurer valutaügyintéző Tour manager Social Security Administrator Taxi driver training Taxi operator training SWR Motorcycle license Servo-motor bikes Chemical Autogas Safety Course Light machinery and heavy machine course Service station operator and vendor training Bus driver training Engine Training Simulator Automatic transmission car training Automatic car for training Elementary education Grammar-school education Training courses Economic Information Technology Training Typists and word processing training Magasépítő Technician Training Civil engineering technician training IT Technology Training Financial Accounting Manager-Training Computer technician, maintenance training Personal Assistant Customer Service Training Telephone and electronic customer care assistant training Secretary Training Administrator Administrative Secretary Training Professional language Concord Language School Vocational training contribution Laboratory technician training Foreign Language Communicator Training Blackboards Demonstration instruments Educational posters Biological models Multimedia Projectors Projection Screen Language labs Teaching aid Educational model Caller picture Word cards Spot a private school Sports Private school sports Domestic appliance service in Miskolc Auto glazing Miskolc Distance Learning Center in Budapest University courses in German Music School Foreign Language Training Center ORIG Exam



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 "Vocational School of Fine Arts" ) 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 = "29441" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150