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

Portable Fireplaces energy saving, surveys, advice construction advice Fireplace Fireplace Construction Fireplaces fireplaces, stoves Fireplace stoves ovens chimneys, -sweeping, -building Hardwood starch Hardness Central heating fireplaces Firebox Combustion chamber deposits Wood Fireplace Building Fireplaces Fireplaces improve Fireplaces Supra fireplaces Unique Fireplaces Design consultancy Shading advice Fireplaces renovation refractory masonry oven lining chimneys Fire-fighting advice Quality hard firewood Hardening rigid PVC sheets Pizza oven Furnaces, boilers and masonry materials Fireplace construction materials Media consultancy Electronics advice Hardwood flooring Parking advice Software consultancy Hardware consultancy Reproductive advice Sweep sidewalks to improve Chimney mechanic course Chimney Chimney Chimney test Chimney Renovation Chimney lining Collector chimney Chimney inspection Chimney Technical Review Technical inspection of chimneys Tile transformation Tile transhipment Tile Construction Central heating furnace chambers connected Chimney advice Making Grill Fire deposits Preparation of marmite Solid carbide milling cutters Insulated chimney Chimney liner production Lined gázkémény Chimney rebuilding Chimney installation Chimney danger inhalation anesthesia Chimney distribution Mounted gas chimney Kazánkémény lining Chimney reconstruction Stainless steel chimney Steel chimney Renovation of chimneys Laboratory Furnace



Céginformáció

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