  
|
Latest Videos
See More Video »
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.
Thanks to Facebook friend Laurie for this heads up. Green Beans Coffee Co. has coffee shops in U.S. military bases all over the world - even temporary ones in Iraq and Afghanistan. They've come up with an idea of how we can say "thanks" to the men and women of the military. For as little as $2, you can buy a cup of coffee for a G.I. and even include a personal message.
Go to http://www.greenbeanscoffee.com/coj/index.php
|
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='22218' 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.