mysql> SELECT * FROM wp_posts WHERE ID IN (96,110)\G
*************************** 1. row ***************************
                   ID: 96
          post_author: 1
            post_date: 2009-05-17 21:13:03
        post_date_gmt: 2009-05-18 03:13:03
         post_content: ON THE COVER: Son Volt photographed by Marty Perez.
           post_title: Issue #1 Fall 1995 - Son Volt
         post_excerpt: 
          post_status: publish
       comment_status: open
          ping_status: open
        post_password: 
            post_name: issue-1-fall-1995-son-volt-2
              to_ping: 
               pinged: 
        post_modified: 2009-05-17 21:13:03
    post_modified_gmt: 2009-05-18 03:13:03
post_content_filtered: 
          post_parent: 0
                 guid: http://nd.hoochiepep.home/?p=96
           menu_order: 0
            post_type: post
       post_mime_type: 
        comment_count: 0
*************************** 2. row ***************************
                   ID: 110
          post_author: 1
            post_date: 2009-05-17 21:11:13
        post_date_gmt: 2009-05-18 03:11:13
         post_content: ON THE COVER: Son Volt photographed by Marty Perez.
           post_title: Issue #1 Fall 1995 - Son Volt
         post_excerpt: 
          post_status: inherit
       comment_status: open
          ping_status: open
        post_password: 
            post_name: 96-revision
              to_ping: 
               pinged: 
        post_modified: 2009-05-17 21:11:13
    post_modified_gmt: 2009-05-18 03:11:13
post_content_filtered: 
          post_parent: 96
                 guid: http://nd.hoochiepep.home/2009/05/96-revision/
           menu_order: 0
            post_type: revision
       post_mime_type: 
        comment_count: 0
2 rows in set (0.00 sec)

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;

Empty set (0.00 sec)