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 (52)
GROUP BY ID
Update - 22 April 2006
We just launched the TicTap web search engine that incorporates this contextual ads technology for Amazon products.
Read the blog post announcing this.
——————————————————————
Does anyone know if it has been tried?
I’ve looked through the ECS documentation, and it has nothing that looks remotely like it.
WordPress database error: [Incorrect file format 'wp_comments']
SELECT * FROM wp_comments WHERE comment_post_ID = '52' AND comment_approved = '1' ORDER BY comment_date