SELECT DISTINCTROW `tbatch` . `Id` AS `BatchId` , `tbatch` . `Title` AS `BatchName` FROM `tteachercontentassign` INNER JOIN `tbatch` ON `tbatch` . `id` = `tteachercontentassign` . `BatchId` WHERE `tteachercontentassign` . `TeacherContentId` = ? 