CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `sinprorio06`@`%` 
    SQL SECURITY DEFINER
VIEW `wp_view_post` AS
    SELECT 
        `wp_term_relationships`.`object_id` AS `object_id`,
        `wp_term_relationships`.`term_taxonomy_id` AS `term_taxonomy_id`,
        `wp_term_relationships`.`term_order` AS `term_order`,
        `wp_posts`.`ID` AS `ID`,
        `wp_posts`.`post_author` AS `post_author`,
        `wp_posts`.`post_date` AS `post_date`,
        `wp_posts`.`post_date_gmt` AS `post_date_gmt`,
        `wp_posts`.`post_content` AS `post_content`,
        `wp_posts`.`post_title` AS `post_title`,
        `wp_posts`.`post_excerpt` AS `post_excerpt`,
        `wp_posts`.`post_status` AS `post_status`,
        `wp_posts`.`comment_status` AS `comment_status`,
        `wp_posts`.`ping_status` AS `ping_status`,
        `wp_posts`.`post_password` AS `post_password`,
        `wp_posts`.`post_name` AS `post_name`,
        `wp_posts`.`to_ping` AS `to_ping`,
        `wp_posts`.`pinged` AS `pinged`,
        `wp_posts`.`post_modified` AS `post_modified`,
        `wp_posts`.`post_modified_gmt` AS `post_modified_gmt`,
        `wp_posts`.`post_content_filtered` AS `post_content_filtered`,
        `wp_posts`.`post_parent` AS `post_parent`,
        `wp_posts`.`guid` AS `guid`,
        `wp_posts`.`menu_order` AS `menu_order`,
        `wp_posts`.`post_type` AS `post_type`,
        `wp_posts`.`post_mime_type` AS `post_mime_type`,
        `wp_posts`.`comment_count` AS `comment_count`,
        `wp_terms`.`term_id` AS `term_id`,
        `wp_terms`.`name` AS `name`,
        `wp_terms`.`slug` AS `slug`,
        `wp_terms`.`term_group` AS `term_group`
    FROM
        ((`wp_term_relationships`
        JOIN `wp_posts` ON (`wp_term_relationships`.`object_id` = `wp_posts`.`ID`))
        JOIN `wp_terms` ON (`wp_terms`.`term_id` = `wp_term_relationships`.`term_taxonomy_id`))
Este artigo foi útil ?
SimNão

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Close Search Window