SELECT `engine4_sesblog_blogs`.*, `engine4_sesbasic_locations`.`lat`, `engine4_sesbasic_locations`.`lng` FROM `engine4_sesblog_blogs` LEFT JOIN `engine4_sesbasic_locations` ON engine4_sesbasic_locations.resource_id = engine4_sesblog_blogs.blog_id AND engine4_sesbasic_locations.resource_type = "sesblog_blog" WHERE (engine4_sesblog_blogs.owner_id <> 0) AND (engine4_sesblog_blogs.owner_id = 91991) AND (engine4_sesblog_blogs.draft = 0) AND (engine4_sesblog_blogs.publish_date <= '2024-11-26 06:30:44' OR engine4_sesblog_blogs.publish_date = '') AND (engine4_sesblog_blogs.is_approved = '1') AND (engine4_sesblog_blogs.draft = '') AND (engine4_sesblog_blogs.search = '1') AND (networks IS NULL || networks = "" ) ORDER BY `engine4_sesblog_blogs`.`creation_date` DESC