CREATE OR REPLACE VIEW vw_contenidos AS select `contenidos`.`id` AS `id`,`contenidos`.`id_tipo` AS `id_tipo`,`contenidos`.`titulo` AS `titulo`,`contenidos`.`guid` AS `guid`,`contenidos`.`subtitulo` AS `subtitulo`,`contenidos`.`resumen` AS `resumen`,`contenidos`.`descripcion` AS `descripcion`,`contenidos`.`palabras_clave` AS `palabras_clave`,`contenidos`.`url` AS `url`,`contenidos`.`autentificacion` AS `autentificacion`,`contenidos`.`target` AS `target`,`contenidos`.`lft` AS `lft`,`contenidos`.`rgt` AS `rgt`,`contenidos`.`sin_registro` AS `sin_registro`,`contenidos`.`plantilla` AS `plantilla`,`contenidos`.`col_size` AS `col_size`,`contenidos`.`col_height` AS `col_height`,`tipos_contenidos`.`nombre` AS `tipo`,`contenidos`.`icon` AS `icon`,`contenidos`.`color` AS `color`,`contenidos`.`destacado` AS `destacado` from (`contenidos` left join `tipos_contenidos` on((`contenidos`.`id_tipo` = `tipos_contenidos`.`id`)))