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 economic information economic advice light building structures agriculture experts Agricultural machinery Agricultural machine parts Agricultural machinery agricultual machinery, spares, appliances agricultural goods suppliers agriculture experts agricultural service agricultural associations, companies, farmers Printing jobs overall design Edit and print design marketing design, management, campaigns Building energy Winwatt interface Economic specialist Economic textbooks Building within the Pest Control Outside the building insect control residential construction construction of farm buildings Construction plumbers Agricultural machinery for rubber parts Woody plants construction Historic buildings tartószerkezetének Design Design events individual production buildings economics texts Specialist exhibition design Studio, design, construction TV Studio design, construction TV Studio Design HVAC systems design, construction unique design brochures Access control systems for Video systems for Power network construction Commercial construction economic advice Printing Economic IT training External surface cleaning of buildings Foam letters buildings Integrated computer network design Integrated telephone design Structured cabling systems for Weak implementation of complex IT systems Translation of economic texts Solar design, construction Solar collectors design, construction Energy-efficient housing design Overhead cable network construction Earth cable network construction Exhibition pavilions construction Construction of exhibition stands Economic mediator National Development and Economy Ministry Agricultural products Agricultural Chain Indoor spraying Outside the building spray Static and Economic Planning of IT Training Foreign Economic Sales Training Audio-visual systems design, construction Agricultural vocational school Agricultural Technician Agricultural Training fixer Foreign Economic Administrator Training Buildings, structures for the static design and design review Economic Information Technology Training Alternative construction systems Office buildings heating, cooling Air conditioning of office buildings Agricultural film Technical, commercial, legal and economic translation of texts Companies founded Economic transformation of societies Removal companies Stockist and gate construction Bituminous roof insulation and PVC construction Privacy planning, preparation, Energy certification of buildings Complex design of office buildings Commercial and residential building design Decorative objects projecting



Home > Detailed search > construction of farm buildings

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 "construction of farm buildings" ) 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 = "22257" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150