CREATE TABLE  `XXX` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `Name` varchar(45) NOT NULL,
  `test` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE OR REPLACE VIEW `XXXV` AS select `X`.`ID` AS `ID`, `X`.`Name` AS `Name`, `X`.`test` from `XXX` AS `X` group by `X`.`Name` having (`X`.`test` = 1);

SELECT * FROM XXXV;