|
|
Updated 566 Days ago
Behind The Scenes: The Breeders Video Featuring Arch Rival Roller Girls
by Melody Meiners in 
- The Story
- Featured Video
The story
There was either a fight scene in the video or a brownie fell on the ground. The Arch Rival Rollers Girls had their skates oiled, elbow pads strapped and they were ready for their close-up on Saturday. The Breeders, who made a splash on the music scene in '93 with their single "Cannonball," are rel Check out the full story.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='6898'
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
- It rocks!
- Its just stupid.
- Its SPAM.
- Its offensive.
- Nevermind.
EnYaNightmare 566 Days agoWhat do you think?
We want to hear from you! Take five seconds to join ToastedRav.com or log in.