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,22)
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 COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 23 AND comment_approved = '1';
Since offering our free site & communication assessment we have—not surprisingly—had a fair amount of requests for this service. So many in fact that we have had to start asking for sites to meet certain criteria before we begin to work on the assessment.
The criteria are simple, and are as follows:
I don’t think that this is a lot to ask. A professional artist who is using the web to promote their work should be prepared to pay the minimal domain name and hosting charges that come with that. We are only talking AL30 - AL40 a year here, not exactly big money.
The great thing about the web of course is that it is dead simple for anyone to publish anything with minimal expertise or money. However, when a site is an important part of your professional life it has to rise above the average self-published look and feel. If the Fine Arts Brass Ensemble had a home page address of www.get-free-web.com/members/finearts/webspace then you probably wouldn’t think they were particularly special. Image is an important part of promoting musicians, and your domain name should be a integral part of your image.
When looking at requests that come in for our free service, I always try and be as fair as possible. I don’t want to turn away people that do not fulfill the criteria, and I always take the time to look at the sites and offer a few simple pieces of advice. The advice invariably starts with recommendations to remove any advertising on the site and to spend a small amount of money on a proper domain name.
Database error: [Table 'artistlo_weblog.wp_comments' doesn't exist]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 22 AND comment_approved = '1';
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