WordPress database error: [Incorrect file format 'wp_comments']
SELECT ID, COUNT( comment_ID ) AS ccount
FROM wp_posts
LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1')
WHERE post_status = 'publish' AND ID IN (100)
GROUP BY ID
TicTap now shows alternate formats for books, if they exist.
With this feature, it is easy to check if your favourite book (in hardcover) is also available in paperback, audio CD, and even MP3.
Try this Rich Dad, Poor Dad book for an example.
WordPress database error: [Incorrect file format 'wp_comments']
SELECT * FROM wp_comments WHERE comment_post_ID = '100' AND comment_approved = '1' ORDER BY comment_date