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

electrical elements electrical wiring vehicle electrics computer networkks media media networks, -improvement, - services telephones, telephone service providers electrical goods power grids electrical swithes electrical insulation materials electrical network building, fitting electrical goods, appliances electrical motors electrical goods retailers electrical fiting and maintenance materials Electrical controls Manufacture of electrical control Electricity Act Explosion-proof electric heater Electricity distributors Electricity distribution electrical articles and electrical assembly electrical installation electricity networks Network deployment Optical network deployment IT network deployment Power networks Power network construction Electrical equipment manufacturing Electrical measurements hálózatanalizáció And small electrical wholesale Low voltage networks Electric Operation and Maintenance electrical trades textbooks reconstruction, electricity Car electricity Budapest Electric power generation Electrical door contacts Digital cable TV networks to assess Telecommunications networks, digital survey Integrated computer network design Integrated telephone design Medium voltage power distribution networks planning High voltage electrical equipment design Low voltage electrical equipment design Overhead cable network construction Earth cable network construction Electrical Shop 11th Electrical Store district 11th Electrical Specialists district Legrand electrical fittings Cave construction Electrical network and station training Electrical network assembly Electricity cost savings Electrical measurements Measuring the quality of electricity Electricity metering Building collectibles dealer, replacement and repair Underfloor heating building Building heating system Fain cool building systems Electrical Insulating Gloves



Szőrtelenítés

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 "electricity networks" ) 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 = "25018" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150