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 (24,23,21)
GROUP BY ID

The trumpet quartet Bella Tromba, has recently gone live with their new website. Having worked alongside Artist Logs for more time than is really healthy on this project, it is a nice one to finally get out the door.
The best news is, that they’re blogging. About all things chamber music, and particularly brass chamber music. So keep an eye out and make sure to subscribe to the blog.
Database error: [Table 'artistlo_weblog.wp_comments' doesn't exist]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 24 AND comment_approved = '1';
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';
A website that is increasingly impressing me these days is the Fine Arts Brass site. There is a lot that these guys are doing right, and I’m not just talking about their phenomenal performing skills!
They are building a community around their message board, and the site is a constantly fluctuating reflection of their personality. It really is fun to go and spend a few minutes looking around. Go check it out.
I’ve been lucky enough to see these guys perform a couple of times—and work with some of their members in the past—and their site truly is a reflection of the excitement and personality you get at one of their recitals or concerts. If only more chamber ensembles put in the time and effort to create sites like this!
Database error: [Table 'artistlo_weblog.wp_comments' doesn't exist]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 21 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