|
|
Updated 11 Hours ago
The Final Look: Rams 27, Ravens 21
by ESPN Staff in 
- The Story
- Featured Video
The story
The Rams edged the Ravens 27-21 to close the pre-season with a 3-1 record. Steve Savard and D’Marco Farr had the call for 101 ESPN, and they bring you The Final Look from the broadcast booth. [attachment:7662] 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='57131'
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.