check topics that belongs to non english blogs

select * from topic_comments_history a where not exists (select 1 from user b where a.user_id =b.user_id) limit 1000000; select distinct c.topic_id, c.title, c.articles from user_blog a join topic_comments_history b using (user_id) join topic c using (topic_id) where a.lang !='en' and c.articles >=4 and c.articles <=10 and c.title regexp '^[^a-zA-Z0-9].*' limit 100000 Find english topics from non english blogs select distinct c.topic_id, c.title, c.articles from user_blog a join topic_comments_history b using (user_id) join topic c using (topic_id) where a.lang !='en' and c.articles >=4 and c.articles <=10 and c.title regexp '^[a-zA-Z0-9].*' limit 100000; and b.topic_id = 5113682; select * from topic where status = 1 and title regexp '^[^a-zA-Z0-9].*' limit 100000;