SELECT `engine4_blog_blogs`.*, `engine4_core_tagmaps`.* FROM `engine4_blog_blogs`
 LEFT JOIN `engine4_core_tagmaps` ON engine4_core_tagmaps.resource_id = engine4_blog_blogs.blog_id WHERE (engine4_core_tagmaps.resource_type = 'blog') AND (engine4_core_tagmaps.tag_id = 9264) AND (engine4_blog_blogs.draft = '0') AND (approved =1) AND (parent_type = 'user') AND (networks IS NULL || networks = ""  ) ORDER BY `engine4_blog_blogs`.`creation_date` DESC