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.
Warning
Available soon