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