SELECT bg.blog_id,bg.blog_title,bg.blog_text,bg.status,bg.created_by,bg.main_photo,DATE_FORMAT(bg.created_date,'%b %d, %Y')as createddt,bct.category FROM blog_master_table bg LEFT JOIN blog_category_table bct ON bct.category_id=bg.category_id WHERE bg.status = 'Active' order by blog_id DESC
