WordPress.org

Make WordPress Core

Ticket #8731: trac_8731_sample.txt

File trac_8731_sample.txt, 2.1 KB (added by gortsleigh, 5 years ago)

Relevant wp_posts rows and generated SQL for a simple query

Line 
1mysql> SELECT * FROM wp_posts WHERE ID IN (96,110)\G
2*************************** 1. row ***************************
3                   ID: 96
4          post_author: 1
5            post_date: 2009-05-17 21:13:03
6        post_date_gmt: 2009-05-18 03:13:03
7         post_content: ON THE COVER: Son Volt photographed by Marty Perez.
8           post_title: Issue #1 Fall 1995 - Son Volt
9         post_excerpt:
10          post_status: publish
11       comment_status: open
12          ping_status: open
13        post_password:
14            post_name: issue-1-fall-1995-son-volt-2
15              to_ping:
16               pinged:
17        post_modified: 2009-05-17 21:13:03
18    post_modified_gmt: 2009-05-18 03:13:03
19post_content_filtered:
20          post_parent: 0
21                 guid: http://nd.hoochiepep.home/?p=96
22           menu_order: 0
23            post_type: post
24       post_mime_type:
25        comment_count: 0
26*************************** 2. row ***************************
27                   ID: 110
28          post_author: 1
29            post_date: 2009-05-17 21:11:13
30        post_date_gmt: 2009-05-18 03:11:13
31         post_content: ON THE COVER: Son Volt photographed by Marty Perez.
32           post_title: Issue #1 Fall 1995 - Son Volt
33         post_excerpt:
34          post_status: inherit
35       comment_status: open
36          ping_status: open
37        post_password:
38            post_name: 96-revision
39              to_ping:
40               pinged:
41        post_modified: 2009-05-17 21:11:13
42    post_modified_gmt: 2009-05-18 03:11:13
43post_content_filtered:
44          post_parent: 96
45                 guid: http://nd.hoochiepep.home/2009/05/96-revision/
46           menu_order: 0
47            post_type: revision
48       post_mime_type:
49        comment_count: 0
502 rows in set (0.00 sec)
51
52mysql>  SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts   JOIN wp_posts AS p2 ON (wp_posts.post_parent = p2.ID)    WHERE 1=1  AND wp_posts.ID IN (96)  AND ((wp_posts.post_status = 'publish') OR (wp_posts.post_status = 'inherit' AND (p2.post_status = 'publish')))  ORDER BY wp_posts.post_date DESC LIMIT 0, 25;
53
54Empty set (0.00 sec)