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

Window installation animal feeds/pet foods Arca Architecture Design interior design taps, tap fittings pipe manufacture construction contractors construction advice architects and building contractors building contractors, services architects and building contractors building contractors, services building contractors, services wholesale outlets, depots translation, proofreading, mediation Certification of translations hotels youth hostels industrial construction cable tv Fireplace Construction Gate Phone door entry systems Add Entry Phones chimneys, -sweeping, -building landscaping Gardening exhibition creation Kitchen Faucets dog- cat-and pet foods, accessories ropes utilities construction, design flat building architectural engineering underground construction detoxification Scales Certification motels satellite television Doors and windows installation Printing jobs overall design Edit and print design Organ building radio, television, vcr repair walkie-talkie servicing and accessories marketing design, management, campaigns Sauna Building Safe Installation sewage disposal faxes telephones, telephone service providers telephone networks, exchanges telecommunication telemarketing teletext television- and radio manufacture, distribution television channels, programmes television technology road constuction, maintenance and management railway construction videophones, -conferences electrical network building, fitting waterworks water supply network servicing, maintenance Water meter calibration Lift installation Installation of lifts Playground construction Building Fireplaces Telescopic loaders Installation of doors and windows residential construction construction of farm buildings Receipt paper Receipt paper Mixed paper receipt Color newspaper takeover black-and-white newspaper takeover software architecture substruction Building electric ship car phone flottafigyelő system installation distribution of satellite images processing of satellite images Mongolian-type dishes Vegetarian Dishes Grill food Stainless steel ropes Hydraulic engineering works Architectural Design Programs Construction plumbers Telefire Sink faucet Woody plants construction Install playground wood interior design Holding civil engineering Semi-frozen meat construction and demolition debris transport housing loans free loans long-term loans Short-term loans subsidized loans mortgage loans Design events Company publication Bicycle construction letting of premises watering pumps Mexican Dishes Mobile phone to pay Buying a mobile phone endless belts transferred halls Mortgage-based loans chartered architect Laser hair removal Construction of garden ponds exhibition design Space covers the construction of Studio, design, construction TV Studio design, construction TV Studio Design HVAC systems design, construction mediation of construction sites Phone register electricity networks unique design brochures Outdoor swimming pool construction installed on generators Telescopic sliding doors Access control systems for Network deployment Optical network deployment IT network deployment Video systems for Power network construction Construction of administrative tasks Brand building Commercial construction telemedicine Metal shutters installed television broadcasting Construction management tasks Jászapáti complex architectural design architectural consultancy balance sheets authentication bottling plant installed Massage chairs, air-cushion Massage chairs Architect wastewater treatment technology industrial wastewater Gas Construction Civil engineering work Architectural Glass Design Fireplace construction materials Stove construction materials lelátórendszer Construction Building mobile színpadtető Telecommunications Construction law reformételek Printing Boiler Installation Model construction Swimming pool construction Windshield installation Car stereo installation Roof installation Additional heating installation Reversing radar installation Installation of wireless phones Install alarms Dust separators Dust filter equipment Donaldson Tori DCE Ventilation equipment Quick knit chains Scrubbers Ground control Powder handling equipment Shut-off valves powder Pneumatic conveyors Wearing lining pipes Oil separation Mobile oil separation equipment Sludge Treatment Disposal of sewage sludge Sewage sludge disposal Sewage sludge into compost Water treatment plant's design Water utility services Utility Sewage treatment plant construction Pre-treatment of waste Incineration Drinking water purification Soil rehabilitation Degrémont technology Safege service engineer Wastewater Cornelia intercom Comelit intercom A public call for verification Draw authentication Furniture safes installed DPM reader installation DPM code generation systems installed Integrated computer network design Integrated telephone design Structured cabling systems for Weak implementation of complex IT systems Telephone cut Modern telephone Electric gate and intercom installation Housing estate in your mailbox Translation of documents without authentication Road gap strip Pools Construction Docks Custom Pools Construction Detoxification lúgosítással Solar design, construction Solar collectors design, construction Grain logistics site Bicycle construction Erd Bicycle construction Erd Residential architectural design Architectural plan for approval Preparation of architectural visualization Forensic Architecture Architectural design of flats Selective collection installation Islands Kazincbarcika Overhead cable network construction Earth cable network construction Calibration equipment Verification of heat meters Mirror Wall Construction Automatic door installation Glass door, glass wall installation Curtain Wall Construction Fax Home and office telephone Telephone, fax, answering devices Construction of synthetic grass football pitches Branches, formation of trade missions and consultants Edge of the site setting Parcel division Required to cut Exhibition pavilions construction Construction of exhibition stands Police dog scented travel site Insurance risk 24-hour telephone assistance Site registration Camera Setup Hungarian and international cuisine Air conditioning installation Building Monitoring System Phone Aquaplus And construction of rock retaining walls Construction of retaining walls Construction of rock Indoor Gardens Building Installation of garden ponds Built in hydrology Balance authentication Fair traded companies Xenon kits for the subsequent incorporation Phone Tower Swimming Pool Construction Tips Telescopic Ladder Environmental Information 24-hour customer service Environmental training courses Environmental training Environmental Events Environmental Information Club Environmental professional events Installation of generators, installation Installation and repair of gas sensors Audio-visual systems design, construction Legrand entryphones Architect Studio Plastic waste recycling Antiques to buy, sell Highways Balint Analytics Remediation Consulting Water testing Wastewater testing Emission measurements Ground analytics Accredited laboratory Emissions Certification Waste tire collection Utilization of waste tires Telemontázs Bt Telephone and electronic customer care assistant training Telephone PBX Analog and digital telephone equipment Cordless DECT Phones Suspensory interior design Gereb got angry because of the attachment Press House Construction Studio Construction Cave construction Gym Construction Depilation Tile Construction Student telephone Closed circuit television monitoring Construction film Construction of industrial floor Alternative construction systems Sauna building materials OPEL car tuning and custom building Installed language lab Vent fittings Frozen prepared meals Laser design, construction, integration Pipeline construction Compressor station construction Industrial plants, factories security fence construction Orchard cordon fences and building systems Building plasters Architectural glass trade Pavement building Sports field construction Palygrounds Structural insulation Install gas detection Technology pipeline installation CCCTV monitoring and intercom Television production department assistant Landscaping materials Fence construction Construction of new track Subway construction Building of roads, squares, parks construction Work of Art building, civil engineering major projects Organic architecture Living Architecture Solar installation Building collectibles dealer, replacement and repair Underfloor heating building Building heating system Installation of automatic air vent, and the exchange of Fain cool building systems Viacolorozás, outdoor enclosures, parking lot construction TORO irrigation installation, maintenance and servicing Planting Legalization Authentication certificate of incorporation Signature and notarization Install hydrants Dewatering pump Automatic irrigation installations Stockist and gate construction Chimney rebuilding Chimney installation Chimney danger inhalation anesthesia Installation of windows, construction Glass roof construction and repair Bituminous roof insulation and PVC construction PBX Digital door entry systems Privacy planning, preparation, Alarm System Installation Telephone Calling Lanyards Fire Ropes Five ambulances Elek Speakerphone Trunked radio telephone GSM Phone Line Extension Stationary Gas Detectors Digital door entry systems Telecommunications Cost Analysis Flat magnets, door pull building Intercom Installation Site Licensing Bomb Batteries Kitchen installation Wireless Phone Received expired medicines Transzteletonikus ECG Venting Phone alarm Interior design Boundary S Teleskop m Balaton site Geology Building Telescope servicing Roofing construction Kecskemét Decorative objects projecting Glass Installation Greenhouse construction Glass roof construction



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 "Sewage treatment plant construction" ) 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 = "27679" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150