SELECT G.Nombre, G.idGrupo FROM ((Menus M INNER JOIN GRU_gruposMenus GM ON GM.menu = M.codM) INNER JOIN GRU_grupos G ON G.idGrupo = GM.grupo) INNER JOIN GRU_tiposGrupos TG ON TG.idTipoGrupo = G.tipo WHERE codM = 2719 AND TG.Nombre = 'Valores añadidos' AND M.visible = 1 GROUP BY G.Nombre, G.idGrupo
If you like the intense flavour of chorizo with a touch of spice, this is the one for you. A spicy chorizo but not too spicy. You'll be surprised by its flavour.
Grupo Empresarial Palacios Alimentación, S.A. | Ctra. de Logroño, S/N 26120 Albelda de Iregua (La Rioja) Tel.: (+34) 902 ... see telephoneFax: (+34) 941... see faxOrder fax: (+34) 941... see order fax
Warning
Available soon