WordPress.org
Get WordPress

Make WordPress Core

Ticket #8731: trac_8731_sample.txt

File trac_8731_sample.txt, 2.1 KB (added by gortsleigh, 17 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)