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-07-30 04:00:45' AND blog_text.time_published<='2015-07-30 04:00:45' ORDER BY blogs.blog_date DESC, blogs.blog_id DESC LIMIT 0,20