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,20)
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';
Why the heck not?
This offering from trumpet player Adam Dickson certainly clattered my funny bone. It is well worth checking out, mostly for a good laugh rather than info on his next recital (which happens to be in Michigan, USA).
For those without the time to download the movie (28MB), it is basically a spoof of a Hollywood type film trailer, complete with booming American voice over and Hans Zimmer inspired score. It describes the battle between the rise of avant garde music (played by various frightening and underhand characters, including one wrapped up in tin foil) and the traditional classical composers (portrayed by Adam and his trumpet). The climax of the piece contains a dramatic rendition of the trumpet solo from the opening of Mussorgsky’s Pictures at an exhibition. It’s very funny stuff.
In this age of digital marketing this kind of material has become very relevant, even in the classical music industry it would appear. And although I’ve never seen this type of approach before, it is one that I would certainly not rule out using in the future.
Companies such as Ford, Virgin, and Starbucks have all used viral marketing campaigns for web movies, often with great success.
Database error: [Table 'artistlo_weblog.wp_comments' doesn't exist]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 20 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