SELECT `RayMusicFiles`.`ID` as `medID`, `RayMusicFiles`.`Owner` as `medProfId`, `RayMusicFiles`.`Title` as `medTitle`, `RayMusicFiles`.`Uri` as `medUri`, `RayMusicFiles`.`Description` as `medDesc`, `RayMusicFiles`.`Tags` as `medTags`, `RayMusicFiles`.`Date` as `medDate`, `RayMusicFiles`.`Listens` as `medViews`, `RayMusicFiles`.`Approved` as `Approved`, COUNT(`share1`.`ID`) as `medCount`, `Profiles`.`NickName` FROM `RayMusicFiles` LEFT JOIN `RayMusicFiles` as `share1` USING (`Owner`) INNER JOIN `Profiles` ON `Profiles`.`ID`=`RayMusicFiles`.`Owner` WHERE `RayMusicFiles`.`ID` = 0 GROUP BY `share1`.`Owner`