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

steel and steel constructions/structures Car equipment car spares automated technology engineers Car repair Wine Equipment leathers, dyeing Furniture assembly Diving equipment diving accessories, divers Channel assembly nightclub fittings health services, therapeutic skin care, therapy accessories electronic engineers and servicing Elevator decorating painting dentists' suppliers central heating maintenance and repair bathroom accessories gas bottles and tanks gas servicing motor vehicle maintenance ships, nautical vehicles Strap locks, installation of sale Industrial paint, industrial paints vehicle spares, -fitting vehicle repair, -servicing Air conditioning installation kitchen appliances and furniture Kitchen Equipment dog- cat-and pet foods, accessories home furnishings bottled gas X-ray protective skiing accessories Sports equipment Sports Equipment sporting accessories balancing technology engineers and engineering fitting technology decorating containers technical fitting textile printing/dying reinforced steel fitting Protective Gear protective clothing, accessories electrical network building, fitting electrical fiting and maintenance materials wiring up of electrical installations plumbing and heating engineering water supply network servicing, maintenance plumbing Lock assembly Wholesale Kitchen Equipment Air conditioning installation Tire Trucks Karnis assembly Gas Installation plumbing installation corrosion protection of steel Solar Installation Car Art Equipment autogenous equipment lánghegesztő equipment Boat Equipment eyebrow dye eyelash dye Car power windows installation Wall painting Amarr garage doors installation Loader assembly Agricultural machinery for rubber parts Plumbing budapest Heating budapest Renting ski equipment Military Equipment Painting X-ray protection Dental Equipment Wholesale tanks savvédelme assembly of electronic and precision equipment electrical articles and electrical assembly special steel Eyebrow dyeing Eyelash dye lift installation in Budapest elevator installation, maintenance Painting after cleaning 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 Fabric painting 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 Office Equipment Windshield installation Electric windows installation Central locking installed Installation of wireless phones Car repair Szeged Cutting steel construction, demolition 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 Flat paint Building painting Protective equipment to prevent falls Distribution of air receivers Potable water purification Installation of earth-moving tires Drótpántos tire assembly Acélpántos tire assembly Survival Equipment Sports Equipment Gas Balatonlelle Central heating installation Balatonlelle Plumbing Balatonlelle Police Equipment Gas and heating Plumbing Alarm installation Porcelain Silk Water meter installation Central heating installation Analog Antenna Installation Digital Antenna Installation Ground Antenna Installation Satellite Antenna Installation INOX ship's apparel Carried advertisements mounting heights Painting of steel structures Outdoor air conditioning units mounted Pipe Post Mounting Dyeing leather jacket Medical electrical equipment assembly Press House Construction Bridge elevation Bridge renovation Residual fuel oil, gasoline breakdown Studio Construction Industrial Facilities Maintenance Tanks, towers, silos, steel installation, painting Advertisement placement Hazard Well Cleaning Cave rescue Cave construction Church renovation Gym Construction Dyeing day Silicone facade Boiler installation Technology pipeline installation First aid equipment Passive house design Coating of plastic parts Plastic containers On-site installation service by car Tire repair and installation Radiator assembly, and replacement Circulator pump replacement, and installation Towbars supply, installation Boxing equipment Buffer tanks Expansion tanks Filter container Steel constructions Security Door Installation Installation of windows, construction Alarm installation Cruise control installation Housing Alarm Installation Armor Door Installation Intercom Installation Flat magnet assembly Car Electronics Installation Akváriim equipment Glass painting surface



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 "Tanks, towers, silos, steel installation, painting" ) 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 = "32524" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150