CREATE VIEW `v_courses`  AS  
select `courses`.`id` AS `id`,`courses`.`formation_level_id` AS `formation_level_id`,`formation_levels`.`name` AS `formation_level_name`,
`courses`.`user_id` AS `user_id`,`users`.`name` AS `user_name`,`courses`.`name` AS `name`,`courses`.`tags` AS `tags`,
`courses`.`score` AS `score`,`courses`.`cover` AS `cover`,`courses`.`evaluable` AS `evaluable`,
`courses`.`target` AS `target`, `courses`.`status` AS `status` 
from ((`courses` join `formation_levels` on((`formation_levels`.`id` = `courses`.`formation_level_id`))) 
join `users` on((`users`.`id` = `courses`.`user_id`))) ;

