1 | mysql> 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 |
---|
19 | post_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 |
---|
43 | post_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 |
---|
50 | 2 rows in set (0.00 sec) |
---|
51 | |
---|
52 | mysql> 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 | |
---|
54 | Empty set (0.00 sec) |
---|