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 (9)
GROUP BY ID
A user wrote in to say that it’s often hard to remember what Asin and ISBN numbers mean in the saved search history.
Therefore, we have tweaked this feature a little, so that you can see the product name beside the Asin or ISBN number in future. Let’s hope this improves usability.
WordPress database error: [Incorrect file format 'wp_comments']
SELECT * FROM wp_comments WHERE comment_post_ID = '9' AND comment_approved = '1' ORDER BY comment_date