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

antennae Car equipment car spares automated technology engineers Breakdown Abroad Car repair Wine Equipment Furniture assembly Diving equipment diving accessories, divers Channel assembly nightclub fittings health services, therapeutic skin care, therapy accessories electronic engineers and servicing Elevator dentists' suppliers central heating maintenance and repair bathroom accessories natural gas production land registers Survey survey, geodesy Surveying earth moving equipment gas servicing motor vehicle maintenance ships, nautical vehicles Strap locks, installation of sale vehicle spares, -fitting vehicle repair, -servicing Air conditioning installation kitchen appliances and furniture Kitchen Equipment dog- cat-and pet foods, accessories home furnishings Language courses abroad X-ray protective skiing accessories Sports equipment Sports Equipment sporting accessories balancing technology engineers and engineering fitting technology technical fitting aluminium oxide production reinforced steel fitting Protective Gear protective clothing, accessories electrical network building, fitting electrical fiting and maintenance materials wiring up of electrical installations Potting compost Potting compost plumbing and heating engineering water supply network servicing, maintenance plumbing Lock assembly Moving abroad Wholesale Kitchen Equipment Air conditioning installation Surveying maps Tire Trucks Karnis assembly Gas Installation plumbing installation cake shop Balatonföldvár Cocktail bar Balatonföldvár live music Balatonföldvár Rent a car Hungary Rent a Car Abroad rent a car abroad Solar Installation Car Art Equipment earth hand autogenous equipment lánghegesztő equipment Boat Equipment domestic transport of goods Domestic Shipping foreign transportation transport abroad transport of goods abroad Car Antennas Car power windows installation Natural gas Gas Prices Grounding sodratok Domestic accommodation Domestic Travel Amarr garage doors installation Loader assembly Agricultural machinery for rubber parts Plumbing budapest Heating budapest Renting ski equipment Military Equipment types of crop valuations X-ray protection Dental Equipment Wholesale Breakdown-rescue trucks from abroad Breakdown of accidents, technical rescue nationally assembly of electronic and precision equipment electrical articles and electrical assembly Earth metrology Domestic passenger luxury bus lift installation in Budapest elevator installation, maintenance Installation of security doors electrical installation Servo pump-out and installation Servo pump presentation Servo pump installation Servo pump presentation Servo pump-out and installation guarantee Equipment and car care articles Tire Towing Equipment Land underground railways Pályatervezési Breakdown territory of the country Breakdown nationally Crane assembly Electrical materials to obtain Vilanyszerelési materials to obtain High voltage switchgear and transformer installation Central heating Water-gas-heating Heat recovery installation Water csatornaszerelés mixtures sale Office Equipment Natural gas supply Natural gas firing Foreign purchases of medicines Medicines from abroad Windshield installation Electric windows installation Central locking installed Installation of wireless phones Car repair Szeged Ground control Domestic passenger Foreign passengers Ground Resistance Meters Electric gate and intercom installation Video systems design and installation Video system design and installation Heating cable installation Invested in the ground tanks and piping systems for corrosion protection dead domestic Protective equipment to prevent falls Installation of earth-moving tires Drótpántos tire assembly Acélpántos tire assembly Earth cable network construction Survival Equipment Earthquake measuring Sports Equipment Gas Balatonlelle Central heating installation Balatonlelle Plumbing Balatonlelle Police Equipment Foreign bond Gas and heating Plumbing Alarm installation Natural Gas Detectors Water meter installation Central heating installation Analog Antenna Installation Digital Antenna Installation Ground Antenna Installation Satellite Antenna Installation Ministry of Agriculture and Rural Development Foreign Tourism INOX ship's apparel Antennae Phone Tower Carried advertisements mounting heights Outdoor air conditioning units mounted Domestic carrier's Car insurance, cargo transport domestically Breakdown abroad Pipe Post Mounting Medical electrical equipment assembly Weddings abroad Tanks, towers, silos, steel installation, painting Earth-moving machine operator Terrestrial and satellite TV reception and distribution systems, radio programs Underground hydrant Underground trains Industrial facilities Earthworks Breakdown in the country and abroad Budapest, Szent Gellért Kelenföld parish Earth-moving trade Foreign authorities for administration Administration of pensions institutions abroad Foreign insurance companies in administration Contacts with foreign partners Required for employment in foreign correspondence Boiler installation Technology pipeline installation First aid equipment On-site installation service by car Tire repair and installation Radiator assembly, and replacement Circulator pump replacement, and installation Towbars supply, installation Domestic and foreign small - high-value properties Thailand Foreign property Thai Property Boxing equipment Security Door Installation Installation of windows, construction Land Registry documents Ground shorting Alarm installation Cruise control installation Housing Alarm Installation DC-controlled antenna switch Mobile phone antenna Armor Door Installation Intercom Installation Flat magnet assembly Car Electronics Installation Domestic passenger transport by bus Geology Building Domestic and international freight Domestic goods Domestic supply of fish Foreign supply of fish Land Credit Akváriim equipment



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 "Ground Antenna Installation" ) 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 = "29883" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150