2025.10.29 Wednesday Nárcisz
 
FAST SEARCH DETAILED SEARCH Search of certificate of incorporation EUROPEAN LEVEL SEARCH OUR PRODUCTS USEFUL INFORMATION ABOUT US JOB CONTACT  

RELATED
CLASSIFICATION INDEX

Sand mine Basalt Coating Building materials Building material trade Trading of building materials Building materials distribution building material suppliers building materials Building Materials Wholesale and retail trade Wood and plastic exterior doors photoprotection, protective layer preparation die-casting Pearl gravel Sand sand, shingle Plastic cards Plastic shutter plastic processing laminating Plastics, plastics machinery plactic cards plastics, plastic goods plastic works Gravel Graded gravel Gravel -Sintered plastic filter Filling sand Gravel filling Mortar sand 2-4-year gravel 4-11-year gravel Cemetery gravel Garden gravel 11-22-year gravel parking 0-22-year gravel 32-56-a gravel 8/16-os gravel 24/40-es gravel 16/24-es gravel KULE gravel 0/8-as gravel 0/16-os gravel 0/24-es gravel 04-year double-sifted gravel Plastic roller Building materials transportation coated electrodes Plastic Case műanyagcsipesz plastic tweezers Galvanic coatings preparation Coating Plastic Components plastic shutters Industrial Plastic Working Plastic Working Fire-retardant coatings Wood coatings Industrial coatings Szeged Plastic Boxes REHAU plastic doors and windows Plastic bonded magnets plastic trays Plastic pots Plastic Abrasion-resistant coatings aftermarket plastic body components Plastic bags Non-slip plastic bags Fast-setting plastic Plastic closing Plasterboard tools Insulation materials Rolled steel profiles Coating and coated sheets Masonry elements Plastic kitchen products Plastic storage boxes Plastic bathroom products Industrial floor Galvanic production Plastic machinery cooling Plastic bags Plastic bag making Industrial plastic recycling Plastic bag manufacturing 0-22es gravel Masonry sand Industrial Plastics Plastic garden furniture Plastic shop cart Ruda-plaster Gletterek Screeds Stukatúr plasters Adhesive plasters Mechanic plasters Special plasters Material joints Leveling jack Buffer PRIMER Socket balancers Plastic Air shaft Lighting mine Masonry mortars Curbstones Canopy Flags Formwork elements Joist Ceiling On-site mixing mortar Semmelrock Rockwool Ytong Aco Terranova Baumit Knauf Rigips Leier Plastic waste recycling 5-chamber plastic windows 7-chamber plastic windows Mirela PE family Foam plates MORFICO family Estrich gettelő machines and pumps Tooling Construction film Construction of industrial floor Who's simmering anti- Edge sealing strip Base concrete Plastic Fans Plastic chairs Waterproofing mortars, floor Poured industrial floor coatings Corrugated bitumen sheets Cement-bonded Bitumen OSB Skilled mechanic gypsum Building plasters Outdoor filler Dental plasters Mould plasters Standard jointing Series mortar Ceramic tile Concrete tile Building Material Shop Plastic processing Plastic products PE plastic bag PE plastic bag PE plastic bag Plastic injection molding parts Coating of plastic parts Coating of plastic parts Plastic parts tamponing Plastic containers Metal and plastic accessories Material trade budapest Construction Materials Budapest Building Material Trading Budapest XVIII. district Fuels Timber Bricklayers Tools Wall coverings Coverings Landscaping materials Skins Bituminous seals Shingles Bricks Purfoam Bulk goods Iron materials Road salt spreaders Tile grout Tile adhesives Polyethylene plastic bag Pest County Production of polyethylene plastic bags Manufacture of plastic injection molded parts Design and manufacture of plastic injection molds Tank coating Heat-resistant coatings Licensed drinking water and food coatings Plastic, and production tools fémfröccs Manufacture of plastic tool förccsöntő Plastic barrels Plastic Bags Self-adhesive sticker Disposable plastic products Acid-resistant Brick Acid-resistant concrete Plastic coating Stainless steel storage tank Acid-resistant industrial floors Stainless steel casing kent Acid-resistant ceramic tiles Capsule Plastic bag warmers



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