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

building maintenance, renovation wood protection Foam servicing, repair maintenance Pool filter Pump Maintenance cleaning and maintanence services Fire Alarm Fire Alarm Systems Fire Alarm fire alarms fire safety Fire Protection Fire-fighting equipment Fire-fighting tool Fire-fighting equipment Interface fire protection investigation Fire Protection Publication Fire protection systems Fire Protection Regulations Fire Protection Exam Fire protection specialist examination Fire protection inspection Fire protection board Maintenance of lifts Fire alarm device announcer Maintenance of fire alarm equipment Fire doors Steel doors, fire-fighting Air Conditioning Maintenance Maintenance of air conditioning cabinets strip maintenance elevator installation, maintenance Lift Maintenance Maintenance contract Fire-fighting advice Outdoor swimming pool construction Elevator maintenance Electric Operation and Maintenance Pool parquet Digital Map Database maintenance Fire protection glazing Radiation protection glazing MODELS Planning CNC machine tool maintenance Computer Maintenance Fire Protection Catalog Weak maintenance of complex IT systems Pools Construction Docks MODELS Production Pool cover Custom Pools Construction Individual swimming pools Indoor Swimming Pool Pool cleaning WEDA B680 pool cleaner Pools clean panels Large pool cleaning Automatic pool cleaner WEDA B680 pool cleaner Remotely controlled swimming pool cleaner Electric maintenance Monitoring System Maintenance Foil pool Pool film Zalakaros apartment with pool Maintenance of gas sensors Industrial Facilities Maintenance Rigid-hose systems Flat-hose systems Nozzles Dry line and power supply cabinets Fire Safety Hydrant boxes and fittings Fire extinguishers Clips, clip, keys Underground hydrant Underground trains Wall hole Fire Protection Fire extinguisher holder Pictograms UV stickers UV Signs Fire alarm and escape plan WPA Design of fire protection equipment Firefighting equipment Sprinkler systems Water mist extinguishing systems Sprinkler systems Elevator maintenance Elevator maintenance Hydromassage pools Shop work and fire safety Fire safety signs Health and safety signs Cape Apron Working garments Maintenance of roof insulations Maintenance and repair of injection molds Pool insulation Pool insulation TORO irrigation installation, maintenance and servicing Gas and smoke detector After lighting and table Periodic review of fire fighting equipment and maintenance Install hydrants Maintenance of fire-water pools Sunnypool metal foil pools Pool replacement films Sole basins, acrylic stairs Polypropylene tanks Fiberglass pools Pool heating, dehumidification Pool vacuum cleaners Fire extinguisher monitoring, maintenance Residential elevator maintenance Maintenance Lifts Elevator maintenance Lift Truck Maintenance



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 "Maintenance of fire-water pools" ) 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 = "34288" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150