SELECT `sharePhotoFiles`.`medID` as `medID`, `sharePhotoFiles`.`medProfId` as `medProfId`, `sharePhotoFiles`.`medExt` as `medExt`, `sharePhotoFiles`.`medTitle` as `medTitle`, `sharePhotoFiles`.`medUri` as `medUri`, `sharePhotoFiles`.`medDesc` as `medDesc`, `sharePhotoFiles`.`medTags` as `medTags`, `sharePhotoFiles`.`medDate` as `medDate`, `sharePhotoFiles`.`medViews` as `medViews`, `sharePhotoFiles`.`Approved` as `Approved`,  
				COUNT(`share1`.`medID`) as `medCount`, 
				`Profiles`.`NickName`
			FROM `sharePhotoFiles`
			LEFT JOIN `sharePhotoFiles` as `share1` USING (`medProfId`)
			INNER JOIN `Profiles` ON `Profiles`.`ID`=`sharePhotoFiles`.`medProfId`
			WHERE `sharePhotoFiles`.`medID` = 0
			GROUP BY `share1`.`medProfId`