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

scents and aromas minerals Car decoration Car decoration Party coverings, -tools, -machinery Shoe repair materials polishing materials, tools and and machinery packing materials Pastry decoration dcorations Decoration green plants Decorative materials Decorative Paint Decorative Design Decorative glass building materials Building Materials Wholesale and retail trade Wooden materials Timber Purchase Pharmaceutical Pharmaceutical development Pharmaceutical manufacturing Pharmaceutical research medicines and therapeutic products, serums Pharmaceutical packaging materials Pharmacy packaging Hygienic fillers knitwear Balloon Decorations Balloon decoration plastics, plastic goods plastic works artists' materials, accessories printers' materials adhesives multiplication materials insulation materials Birthday roofing and insulation materials fireproof materials heating fuels chemical materials hazardous waste electrical insulation materials electrical fiting and maintenance materials Flower decoration Flower decoration Waterproofing materials Sealants Liquid sealant Decoration material Soldering material Variable with each other decorative materials Shutter for black-out material Of textiles for hotels Interior decoration destruction of confidential material soldering material Thermal conductivity materials Resources kemping patterned materials Children's decoration materials Decorative lighting Decor Food additives Decorative coating Dental materials acid-resistant materials Minerals Trizact of surface polishing Diamond discs and diamond abrasives flexililis Packaging materials Production of promotional materials Car decoration 3D Decorations Lighting decoration Facade decoration Wall Decoration Protective materials events decorative design Car care materials Flooring materials Party product Birthday Decorations Balloon Decorations Jet Seal materials Electrical materials to obtain Vilanyszerelési materials to obtain Fireplace construction materials Stove construction materials Tiled stove linings koszorúkötészeti materials Decoration works Glass Decorations Textile filter materials Insulation materials Confectionery packaging materials Decorative cup Clocks Table clocks Metal bushing Metal furniture Suspended wicker pots Easter Products Christmas Decorations Mugs Rattan Furniture Oil lamps Valentine's Day Products Floral supplies Subscribers marketing materials score Rental packaging materials Industrial insulation Internal decoration techniques Ardex building materials Transport of dangerous goods Kazincbarcika Far East materials Home decorations Indoor flower Industrial Plastics Party Decorations Party Products ARAL Lubricants Improver Material joints Decorative stickers Manufacture of paper packaging materials Lightweight materials Stock Resources Sauna building materials Multimedia Dairy insulating materials Protect the wood against moisture Stone repair materials Making Decorations Decorations And maintenance aids Sole and heel materials Construction Materials Budapest Fuels Timber Landscaping materials Iron materials Thervolin insulation and sealing LOCTITE adhesives and sealing materials Stainless and heat-resistant materials Party shop Helium balloon shop Materials for the furniture industry Balancing Surface Materials Decorative Paints Packaging Materials Trade Chocolate Decorations



Home > Detailed search > Decorative materials

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