SELECT * FROM metadatas WHERE value IN ('Monumento', 'Arquitectura')

SELECT * FROM metadatas2
WHERE ID IN (SELECT ID FROM
               (SELECT ID, NAME, COUNT(*) CANT FROM metadatas2
                GROUP BY ID,NAME)A
             WHERE CANT=2)
AND  value IN ('Monumento', 'Arquitectura')