CREATE OR REPLACE VIEW vw_menu_publico AS select `menu_publico`.`id` AS `id`,`menu_publico`.`id_plantilla` AS `id_plantilla`,`menu_publico`.`id_media` AS `id_media`,`menu_publico`.`titulo` AS `titulo`,`menu_publico`.`subtitulo` AS `subtitulo`,`menu_publico`.`descripcion` AS `descripcion`,`menu_publico`.`meta_keywords` AS `meta_keywords`,`menu_publico`.`meta_description` AS `meta_description`,`menu_publico`.`guid` AS `guid`,`menu_publico`.`lft` AS `lft`,`menu_publico`.`rgt` AS `rgt`,`menu_publico`.`activo` AS `activo`,`menu_publico`.`en_menu` AS `en_menu`,`plantillas`.`plantilla` AS `plantilla`,`plantillas`.`filename` AS `filename_plantilla`,`plantillas`.`widgets` AS `widgets` from (`menu_publico` left join `plantillas` on((`menu_publico`.`id_plantilla` = `plantillas`.`id`)))