Database error: [Table 'artistlo_weblog.wp_comments' doesn't exist]
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 (23)
GROUP BY ID

Someone knows the answer.
Ask over at RobsHouse.net - someone that gets it. Points 1 and 2 struck a chord with me in particular (and this was written over a year ago).
- Personal blog site. As a musician, I would like a site where I can write small articles, announcements, open letters etc., and not have to worry about the technical aspects of linking and publishing. I would like to decide whether users can comment on my entries, and have the power to unpublish them if I need to.
- There are few (if any) popular and modern forums for classical musicians. This is odd, since horn players alone can debate a topic such as mouthpieces or fingerings for ages. I would like to see a site with active forums for musicians.
Database error: [Table 'artistlo_weblog.wp_comments' doesn't exist]
SELECT * FROM wp_comments WHERE comment_post_ID = '23' AND comment_approved = '1' ORDER BY comment_date
Database error: [Table 'artistlo_weblog.wp_comments' doesn't exist]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = 23 AND comment_approved = '1'
No comments yet.
RSS feed for comments on this post.
Please keep comments relevant. We love communication and encourage it, but inappropriate or offensive comments will be edited or deleted.
Your privacy is important. We hate spam too, and your email address is not permanently stored and will never be used for any purpose.
The following HTML elements may be used: a, strong, em, title, cite, strike, abbr, acronym, & code. All other code will be stripped before posting.
The URL to TrackBack this entry is: http://artistlogs.com/weblog/what-do-musicians-needwant-in-a-site/trackback/
Artist Logs will transform the way you present yourself and communicate with your audience online. Contact us for a chat about what we can do for you. More about Artist Logs »
Database error: [Table 'artistlo_weblog.wp_comments' doesn't exist]
SELECT * FROM wp_comments ORDER BY comment_date DESC LIMIT 0 ,
5