SELECT art.*, sec.title section, sec.slug section_slug, sec.google_var google_var, sec.icon_file section_icon, chan.slug channel_slug, blog.title blog_title, blog.slug blog_slug, blog.subtitle blog_subtitle, blog.image_file blog_image FROM bb_admin.bb_articles as art LEFT JOIN bb_admin.bb_categories_articles as cat ON art.primary_category_id = cat.category_id LEFT JOIN bb_admin.bb_sections as sec ON art.primary_section_id = sec.section_id LEFT JOIN bb_admin.bb_channels as chan ON art.primary_channel_id = chan.channel_id LEFT JOIN bb_admin.bb_blogs as blog ON art.primary_blog_id = blog.blog_id WHERE art.status IN ('1','3') AND published <= '2013-05-23 01:27:24' AND art.primary_channel_id = '3' AND cat.slug = 'tips-from-ponds' GROUP BY art.article_id ORDER BY published DESC