| 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) |
|---|