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 (36)
GROUP BY ID
Does anyone want a TicTap API?
Damon and I have discussed this before, and we’ll like to hear what you want from it before we start designing one.
We intend to offer it free (if we do), of course 
Please tell us what the TicTap Web Service API should do for you!
WordPress database error: [Incorrect file format 'wp_comments']
SELECT * FROM wp_comments WHERE comment_post_ID = '36' AND comment_approved = '1' ORDER BY comment_date