WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #25775, comment 16


Ignore:
Timestamp:
12/06/2013 05:49:02 PM (7 years ago)
Author:
DrewAPicture
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #25775, comment 16

    initial v1  
    22
    33{{{
     4#!php
     5<?php
    46/*
    57basic-set consists of
     
    6264
    6365{{{
     66#!sql
    6467SELECT wp_2_posts.* FROM wp_2_posts INNER JOIN wp_2_term_relationships ON (wp_2_posts.ID = wp_2_term_relationships.object_id) LEFT JOIN wp_2_posts AS p2 ON (wp_2_posts.post_parent = p2.ID) WHERE 1=1 AND ( ( post_date_gmt >= '2011-05-17 22:00:00' AND post_date_gmt <= '2013-12-06 22:59:59' ) ) AND ( wp_2_term_relationships.term_taxonomy_id IN (5) ) AND wp_2_posts.post_type = 'post' AND ((wp_2_posts.post_status = 'publish') OR (wp_2_posts.post_status = 'inherit' AND (p2.post_status = 'publish'))) GROUP BY wp_2_posts.ID ORDER BY wp_2_posts.post_date DESC
    6568}}}
     
    7477
    7578{{{
     79#!sql
    7680SELECT wp_2_posts.* FROM wp_2_posts INNER JOIN wp_2_term_relationships ON (wp_2_posts.ID = wp_2_term_relationships.object_id) LEFT JOIN wp_2_posts AS p2 ON (wp_2_posts.post_parent = p2.ID) WHERE 1=1 AND ( ( wp_2_posts.post_date_gmt >= '2011-05-17 22:00:00' AND wp_2_posts.post_date_gmt <= '2013-12-06 22:59:59' ) ) AND ( wp_2_term_relationships.term_taxonomy_id IN (5) ) AND wp_2_posts.post_type = 'post' AND ((wp_2_posts.post_status = 'publish') OR (wp_2_posts.post_status = 'inherit' AND (p2.post_status = 'publish'))) GROUP BY wp_2_posts.ID ORDER BY wp_2_posts.post_date DESC
    7781}}}