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

Company flag construction design and management Wedding trade management Exhibition - fair presentation and organization Conference Organization conference management Accounting firms leasing, leasing firms agricultural associations, companies, farmers education, education management Education organization marketing design, management, campaigns Events Photographing events Banquet party and reception organisation, hosting Event management organisational advice Moving Companies Professional event organizing Conferences Organization of press conferences Snack events Corporate partner Hunting organization Design events postal services firms Organization of press conference Program fell by the organization Betting Dog events Organizational culture rental equipment for events Furniture hire for events organization of presentations organization of gala dinners organizing garden parties Weddings organization Organization of corporate presentations corporate management presentations visualization events events decorative design pyrotechnics events clinical research studies Business Language Courses Corporate language training Forged bush Business education Corporate Training Training firms English training for companies sound events Burial organization Advertise organization of work Corporate events organization Company events Book organization Seminars Cultural Banquet Organization of cultural events Exhibition organizers Business Stationery Chinese Partner Search Organization of work Plant organization Private and corporate administration Private and business passenger Extra bowls events Family events Fair traded companies Environmental training courses Environmental Events Environmental professional events END corporate language training VW car rental companies Preserving, protecting civil liability companies Wedding Events Weddings, events, transportation of persons conducting Theater hall meetings, XVII.kerület Enterprise Car Rentals Glazing Company



Home > Detailed search > Corporate events organization
AROBS Pannonia Software Kft

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 "Corporate events organization" ) 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 = "26882" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150