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 contractors, services building contractors, services power indusrty technology Printing jobs overall design Edit and print design marketing design, management, campaigns computer networkks media media networks, -improvement, - services telephones, telephone service providers power grids construction of farm buildings Construction plumbers Woody plants construction Design events exhibition design Studio, design, construction TV Studio design, construction TV Studio Design HVAC systems design, construction electrical installation electricity networks unique design brochures Access control systems for Video systems for Power networks Power network construction Commercial construction Low voltage networks High voltage switchgear and transformer design High voltage switchgear and transformer installation High voltage switchgear and transformer installation Printing Digital cable TV networks to assess Telecommunications networks, digital survey Integrated computer network design Integrated telephone design Structured cabling systems for Weak implementation of complex IT systems Medium voltage power distribution networks planning High voltage electrical equipment design Solar design, construction Solar collectors design, construction Overhead cable network construction Earth cable network construction Exhibition pavilions construction Construction of exhibition stands Audio-visual systems design, construction Alternative construction systems Stockist and gate construction Bituminous roof insulation and PVC construction Privacy planning, preparation, Power wire and cable Decorative objects projecting



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