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 (10)
GROUP BY ID
We’ve added 2 nifty features for music lovers.
When you click view “Music Tracks”, we’ll provide a link to the page at Amazon.com so that you can find song samples from that album.
In addition, we’ve added song title links to Yahoo! that searches for lyrics.
Give it a try with this example - Norah Jones albums.
Related Posts:
»Yahoo! Song and Podcast Search
»People-specific search
WordPress database error: [Incorrect file format 'wp_comments']
SELECT * FROM wp_comments WHERE comment_post_ID = '10' AND comment_approved = '1' ORDER BY comment_date