  
|
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.Click on the CONTEST tab above for your chance to win a Gold's Gym bag, t-shirt, key chain, shower shoes and more.
Join Gold's Gym in January or February and receive FREE Enrollment And…NEW! STRONG START PACKAGE
They have packaged some of their most powerful tools and offerings into a new Strong Start Package for the New Year. The elements include the Monthly Nutrition Guidance,e Personalized Workout Plan and the FREE Group Exercise classes included with a Gold’smembership.
This article also has 1 Contest attached to it. 
|
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='30735' 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.