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

pet accessories Organic household products energy saving, surveys, advice building maintenance, renovation Tree clearing groceries Household paint white goods, white goods servicing domestic chemicals office cleaning servicing, repair maintenance Gardening Public utilities record public/communal area maintenance Population Pump Maintenance home entertainment, electronics Cleaning Cleaning cleaning and maintanence services road constuction, maintenance and management Cleaning services Maintenance of lifts Maintenance of fire alarm equipment breakdown after cleaning lakástakarékpénztári savings Domestic Air Conditioning Maintenance Maintenance of air conditioning cabinets strip maintenance bodily improvement program enhancement program Building and automotive products Autumn kerttakarítás elevator installation, maintenance Lift Maintenance Maintenance contract Stairway cleaning Residential cleaning Apartment Cleaning Factories cleaning Cleaning plant Cleaning Shops Cleaning Facilities Schools Cleaning Offices Cleaning Transfer clean-up Toilet cleaning Painting after cleaning Mechanized harvesting Cleaning deep garages Hall cleaning Toilet cleaning Public daily cleaning Any cleaning Household shelf Elevator maintenance Population register Household paper goods Maintaining registration Electric Operation and Maintenance Household goods game Digital Map Database maintenance Keeping errors to improve Hours to prevent errors Maintenance treatment of errors Posture exercises Physiotherapy posture Cleansing Strip External surface cleaning of buildings CNC machine tool maintenance Maintenance contract Computer Maintenance Cleaning Silos Weak maintenance of complex IT systems Records-range packing order Funeral ceremony Regulation of livestock Debrecen Electric maintenance Residential cleaning Property cleaning Cleaning of public institutions Bathroom Cleaning Clean room clothes Clean room Clean room services Clean room clothing Cleanroom technology Monitoring System Maintenance Seasonal opening hours Condominiums Cleaning Wholesale Home Appliances COMPLEX - KIT stock records system Maintenance of gas sensors Household chemical jars Road maintenance Public land, reservation in Szeged Industrial Facilities Maintenance Electricity cost savings Saving Energy Advertisement Cleaning, Clean Graffiti removal Industrial and domestic sewing machines Energy savings Elevator maintenance Elevator maintenance Contacts with foreign partners Register Maintenance of roof insulations Analytic records Labour records Maintenance and repair of injection molds TORO irrigation installation, maintenance and servicing Garden and park maintenance contract. Periodic review of fire fighting equipment and maintenance Maintenance of fire-water pools Household goods Domestic appliance service in Miskolc Refurbished Appliances Chemical-free cleaning Timesheet Working time records Fire extinguisher monitoring, maintenance Safety cleaning Household water treatment Residential elevator maintenance Maintenance Lifts Elevator maintenance Lift Truck Maintenance Clean Water Pump Household glass



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 "Advertisement Cleaning, Clean" ) 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 = "32793" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150