Facility name:
Country: Select Portogallo Ucraina Korea del Sud Irlanda Taiwan Filippine Argentina Australia Austria Belgium Brazil Bulgaria Canada China Colombia Costarica Czech Republic Dominican Republic Ecuador France Germany Greece Holland Hong Kong Hungary India Israel Japan Luxembourg Malta Mexico Morocco Perù Romania Russia Serbia Singapore Slovak Republic South africa Spain Sweden Switzerland Thailand United arab emirates United kingdom United States Venezuela State...AlabamaAlaskaArizonaArkansasCaliforniaCarolina del NordCarolina del SudColoradoConnecticutDakota del NordDakota del SudDelawareFloridaGeorgiaHawaiiIdahoIllinoisIndianaKansasKentukyLouisianaMaineMarylandMassachusettsMichiganMinnesotaMissisipiMissouriMontanaNebraskaNevadaNew HampshireNew JerseyNew MessicoNew YorkOhioOklahomaOregonPennsylvaniaPuerto RicoRhoadTennesseTexasUtahVermontVirginiaVirginia occidentaleWashingtonWyoming
City: Select
Gourmet offer: Select SELECT DISTINCT LV.idVoce AS idGourmet, LV.descrVoce AS descrGourmet FROM `rim`.anniq Q INNER JOIN `rim`.mangiare A ON Q.id = A.id INNER JOIN `generale`.listeval_voci LV WHERE LV.idLista =49 AND (A.originePiatti = LV.idVoce OR A.originePiatti2 = LV.idVoce) AND Q.marchio =1 ORDER BY LV.descrVoce Abruzzo Basilicata Calabria Campania Emilia Romagna Friuli Venezia Giulia Italia Lazio Liguria Lombardia Marche Molise Piemonte Puglia Sardegna Sicilia Toscana Trentino Alto Adige Umbria Valle d'Aosta Veneto