CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `tv_parent_author` AS select `t_post_interactions`.`value` AS `docId`,`file_author`.`value` AS `value` from (`t_post_interactions` join `file_author` on((`t_post_interactions`.`docId` = `file_author`.`docId`)))