SELECT SQL_CALC_FOUND_ROWS DISTINCT blogs.blog_id, blogs.website_id, blogs.ext_website, blogs.category_id, blogs.user_cat_id, blogs.profile_id, blogs.blog_date, blogs.onsite, blogs.banner, blogs.media_url, blogs.media_width, blogs.media_height FROM pogo616_pogolog.blogs LEFT JOIN pogo616_pogolog.blog_text ON blog_text.blog_id=blogs.blog_id WHERE blogs.removed='N' AND substr(blog_text.language,1,2)='en' AND blogs.user_cat_id!=10038 AND blogs.profile_id=44 AND blog_text.time_published<='2015-08-01 22:11:38' AND blog_text.time_published<='2015-08-01 22:11:38' ORDER BY blogs.blog_date DESC, blogs.blog_id DESC LIMIT 0,20