create view TC as select `sv_posts`.`ID` AS `id`, max((case when (`sv_postmeta`.`meta_key` = _utf8'student_name') then `sv_postmeta`.`meta_value` end)) AS `student_name`, max((case when (`sv_postmeta`.`meta_key` = _utf8'scholar_no') then `sv_postmeta`.`meta_value` end)) AS `scholar_no`, max((case when (`sv_postmeta`.`meta_key` = _utf8'tc_download') then `sv_postmeta`.`meta_value` end)) AS `tc_download` from (`sv_posts` join `sv_postmeta` on((`sv_postmeta`.`post_id` = `sv_posts`.`ID`))) where (`sv_posts`.`post_type` = _utf8'addtc') group by `sv_posts`.`ID`