SELECT `blog`.*, `blog_category`.`blog_categoryname`, `blog_tags`.`tag_name`
FROM `blog`
LEFT JOIN `blog_category` ON `blog_category`.`blog_cat_id` = `blog`.`blog_category`
LEFT JOIN `blog_tags` ON `blog_tags`.`tag_id`  = `blog`.`blog_tag`
WHERE `blog`.`is_deleted` = 'no'
AND `blog`.`is_active` = '1'
AND `blog`.`blog_tag` IN('4')
ORDER BY `blog`.`blog_id`
 LIMIT 3