SELECT
  CONCAT('a',mv_person_id) as guid,
  CONCAT('a',mv_person_id) as grouping_id,
  CONCAT(first_name,' ', last_name),
  CONCAT(first_name,' ', last_name),
  CONCAT(first_name,' ', last_name),
  'People',
  GROUP_CONCAT(
    CONCAT(
      date_format(start_date_time, '%Y-%m-%dT%H:%i:%SZ') , ' | ',
      ifnull(s.prg_svc_id, 'null') , ' | ' ,
      ifnull(fp.franchise_parent_type,'null') , ' | '  ,
      MD5(concat(s.prg_svc_id,s.start_date_time)), ' | ' ,
      ifnull(fp.franchise_guid, 'null')
    )
  ) as airings,
  GROUP_CONCAT(s.prg_svc_id,UNIX_TIMESTAMP(s.start_date_time))
FROM  franchise_people fp
LEFT JOIN mediaview_tms.schedules s ON s.tms_id = fp.tms_id
WHERE ( fp.role_type = 'cast' OR fp.role = 'Director' OR fp.role = 'Host' OR fp.role = 'Producer' OR fp.role = 'Executive Producer' )
GROUP BY mv_person_id
HAVING airings IS NOT NULL;