Hjælp til SQL Query

SELECT T1.*
FROM scener AS T1
JOIN
(
    SELECT `DVDID`
    FROM scener
    GROUP BY `DVDID`
    HAVING COUNT(*) > 1
) T2
ON T1.`DVDID` = T2.`DVDID`

CREATE TABLE `scener` (
  `id` int(11) NOT NULL,
  `MovieID` int(11) NOT NULL,
  `DVDID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;


INSERT INTO `scener` (`id`, `MovieID`, `DVDID`) VALUES
(1, 20, 432),
(2, 21, 432),
(3, 22, 436),
(4, 23, 185);


ALTER TABLE `scener`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `scener`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;