CREATE OR REPLACE VIEW vw_version_history AS select `version_history`.`id` AS `id`,`version_history`.`id_usuario` AS `id_usuario`,`version_history`.`fecha` AS `fecha`,`version_history`.`titulo` AS `titulo`,`version_history`.`descripcion` AS `descripcion`,`version_history`.`color` AS `color`,`version_history`.`icon` AS `icon`,`version_history`.`notificado` AS `notificado`,concat(`usuarios`.`nombre`,' ',`usuarios`.`apellidos`) AS `usuario`,`media_files`.`download_code` AS `download_code`,`media_files`.`filename` AS `filename` from ((`version_history` left join `usuarios` on((`version_history`.`id_usuario` = `usuarios`.`id`))) left join `media_files` on((`usuarios`.`id_media` = `media_files`.`id`)))