  
|
Latest Videos
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.
Join area law enforcement and Special Olympics Missouri for a refreshing dip into Lake Saint Louis on February 6th! Polar Bears all over the St. Louis area are planning for the Polar Bear Plunge. Start gathering your Polar Bears and working on your costumes and spirit now! Each Polar Bear raises a "bear" minimum of $75. (Polar Bears must be age 14+). Registration starts at Noon and the plunging begins at 2pm.
Click here to learn more about the 2009 Polar Bear Plunge, brought to you by Shop 'n Save, Mama Lucia's Pizza, Fazio's Ravioli, Mama Lucia's Hearty Quick Start Breakfast, and Hot Mama Breads.
|
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='31271' 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.