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

ABC supermarkets, grocery stores Trade in steel Component of trade animal trade car trade pawnbrokers' trade food Food processing Food materials food trade Food safety food shops food industry Food machine food industry machinery Food processing equipment manufacturing Food refrigeration Food trade food analysis Food shop Building material trade mass consumables-wholesale Wakame Grain trade Iveco spare parts trade trade promotion trade management foreign trade fine art dealing Real Tool of trade Machine tool trade Of tools eggs, egg processing, trade glass trade Fashion Wholesale Canned fish Algae Seaweed salads Station Wagon Nori Food processors Beverage Wholesale Food additives quick-frozen food wholesale Trade Waste Food thermometers Food industry equipment Ambulances, trade and repair Food industry cleaning food lisztérzékenyeknek Ajvar gyorskapuk food plants Meat Wholesale Food processing Battery trade Food flavor Food hose Grocery Eastern spices, flavors Far East materials English sauces Asian spices Food for sale Wholesale Flower Gas appliance retail and wholesale Food industry workwear Food Wholesaler HVAC Trade Food technical school Sweets Biscuits Praline Dessert Organic drinks Organic Teas Fruit drinks Pasta Rusk Glutenfree diet food Food for diabetics Food is lactose intolerant Frozen prepared meals Olive oil Architectural glass trade Earth-moving trade Construction machinery trade Material trade budapest Wholesale gas Wholesale gas appliance component Licensed drinking water and food coatings Yarn Wholesale Yarn Trade Security Door trade Fresh fruits and vegetables wholesale and export And commercial GPS service Windshield trade Chandelier trade Glass Retail



Horn Magyarország

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