This archived news story is available only for your personal, non-commercial use. Information in the story may be outdated or superseded by additional information. Reading or replying the story in its archived form does not constitute a re-publiccation of the story.
Tonight's lesson on Simon's School of Rock is about cohabitation - namely the cohabitation between two singer-songwriters.
Our House by Crosby, Stills, Nash & Young was written by Graham Nash, who was living with Joni Mitchell at the time he wrote this in 1969. Both Nash & Mitchell had good, prolific songwriting years while living together, with Mitchell releasing Ladies of the Canyon at the same time as CSNY's Deja Vu. The romance may not have lasted, but it was good for music.
I'm not sure what lesson you can derive from that, other than the song is about Joni Mitchell.
Join me for another episode of Simon's School of Rock, weeknights at 8 on 106.5 the Arch.
SELECT blogPost.id, blogPost.blog_id, blogPost.slug, blogPost.member_id, blogPost.title, blogPost.votes, blogPost.comments, blogPost.body, blogPost.photo_id, blogPost.photo_width, blogPost.photo_position, blogPost.body_type, p1.origName as photo_name, p1.extension as photo_extension, p1.width as photo_size_width, if_comments, start_publish, end_publish, updated, blogPost.created, blogPost.display, member.screenname, member.first, member.last, member.signature, CONCAT(member.photo_id,'.',p2.extension) as photo, COUNT(DISTINCT blogPostPhoto.id) as gallery_count, blogCategory.id as category_id, blogCategory.name as category, blogCategory.link as category_url, blog.name as blog_name, blog.title as blog_title, blog.url as blog_url, blogPost.sticky FROM blogPost LEFT JOIN photo as p1 on (blogPost.photo_id=p1.id) LEFT JOIN member on (blogPost.member_id=member.id) LEFT JOIN blogPostPhoto on (blogPostPhoto.blogPost_id=blogPost.id) LEFT JOIN photo as p2 on (member.photo_id=p2.id) LEFT JOIN blogCategory on (blogPost.blogCategory_id=blogCategory.id) LEFT JOIN blog on (blogPost.blog_id=blog.id) WHERE blogPost.id='8495' AND blogPost.start_publish < now() AND (blogPost.end_publish = '0000-00-00 00:00:00' OR blogPost.end_publish > now()) AND blogPost.display = 'Y' GROUP BY blogPost.id
What do you think?
We want to hear from you! Take five seconds to join ToastedRav.com or log in.