Couldn't execute query : SELECT DISTINCT d.`DVDID`, dv.`ViewCount`
                    FROM `movieinfo` m, `dvdinfo` d, `dvdviewcount` dv
                    WHERE m.`MovieID` IN (7631) AND
                    d.`MovieID`=m.`MovieID` AND
                    d.`Active`=1 AND
                    dv.`DVDID`=d.`DVDID`
                    ORDER BY dv.`ViewCount` DESC