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 coverings, -tools, -machinery Shoe repair materials polishing materials, tools and and machinery packing packing technology Packaging Packaging packing materials Packages Packers packing machines Packaging Packed confectionery Confectionery materials Pastry decoration Decorative materials 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 Bubble pack plastics, plastic goods plastic works artists' materials, accessories printers' materials adhesives multiplication materials insulation materials roofing and insulation materials fireproof materials heating fuels chemical materials hazardous waste electrical insulation materials electrical fiting and maintenance materials Waterproofing materials Sealants Liquid sealant Soldering material Variable with each other decorative materials Shutter for black-out material Of textiles for hotels destruction of confidential material soldering material Thermal conductivity materials Individual packaging of poultry products Packaged poultry products Resources kemping patterned materials Children's decoration materials Packed flour Packaged bakery products Design packaging lines Food additives Dental materials acid-resistant materials Minerals Trizact of surface polishing Diamond discs and diamond abrasives flexililis banknote packing banknote packing vákumos Packaging servicing Packaging machinery and equipment Packaging materials Production of promotional materials mineral water packaging beverage packaging Protective materials Packaging and gift accessories pastry equipment Car care materials Flooring materials Vacuum 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 foil publications hozzácsomagolás nyomdatermékekhez GOODS hozzácsomagolása Textile filter materials Insulation materials Tray Packer Fried paper baking cases Paper trays Lace cake Confectionery packaging materials Waxy cake pads Bon-bon boxes Confectionery Supplies Cake Stands Silicon Baking Silicon Foam bag Chocolate molds Jelly molds Decorative Tapes Food coloring dyes Wilton Products Vegetable sculpture Fruit Sculpture Thermo Boxes Chocolate materialize Collection Form Sensory garbage Teflon film oven Teflon film Used packaging Refurbished packaging Subscribers marketing materials score Records-range packing order Rental packaging materials Industrial insulation Ardex building materials Transport of dangerous goods Kazincbarcika Packaging waste Far East materials Industrial Plastics ARAL Lubricants Improver Material joints Pet Packaging Fresh fruit packaging Fresh vegetable packing Manufacture of paper packaging materials Lightweight materials Wrapping film Stock Resources Sauna building materials Multimedia Dairy insulating materials Protect the wood against moisture Stone repair materials Automatic weighing packaging Manufacture of individual packaging Pellet Packaging Cold pack Seed pack Premix packaging Fertilizer Packaging Packaging Budapest 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 Materials for the furniture industry Balancing Surface Materials Packaging Materials Trade Tesa Packaging Tapes Glass Packaging



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