SELECT record.title,
       record.seriesid,
       ( SELECT COUNT(program.title)
           FROM program
          WHERE program.title = record.title ) AS `play count`,
       ( SELECT GROUP_CONCAT(DISTINCT program.seriesid)
           FROM program
          WHERE program.title = record.title ) AS `play seriesid`
  FROM record
 WHERE record.seriesid NOT IN ( SELECT program.seriesid
                                  FROM program
                                 WHERE program.title = record.title )
HAVING `play count` > 0
;