Untitled query #32650

SQL

use knwiki_p;
select count(p.page_id) from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_timestamp > '20180530235959' and r.rev_timestamp < '20190101000000' and r.rev_user_text in ("BschandrasgrVidyu44","Manjappabg","M G Harish","T.sujatha","శ్రీరామమూర్తి","Pradeejeeva","PavilachhiArpitha. V.rao","Kaveridas linganapura","Shivakumar22266","Shwetha MP","Sangeetha s kokrady","Pradeepchikkati","Abdul Sattarbm5","Mallikarjuna bagoor","Kashammakavya","Mardanbi","Nabisab RB","Pranam shetty.kalladka","Rakshith Bangera","Sanjeev jagli","Prashanth hugar","Lalitha nitin","Maruthesh durgra","Yogini suki","Priyanka Mavinkar","Chaithra KM","Sajeeda Athar");
select concat("[[:kn:",p.page_title,"]]"),r.rev_timestamp from revision r, page p where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_page = p.page_id and r.rev_user_text in ("BschandrasgrVidyu44","Manjappabg","M G Harish","T.sujatha","శ్రీరామమూర్తి","Pradeejeeva","PavilachhiArpitha. V.rao","Kaveridas linganapura","Shivakumar22266","Shwetha MP","Sangeetha s kokrady","Pradeepchikkati","Abdul Sattarbm5","Mallikarjuna bagoor","Kashammakavya","Mardanbi","Nabisab RB","Pranam shetty.kalladka","Rakshith Bangera","Sanjeev jagli","Prashanth hugar","Lalitha nitin","Maruthesh durgra","Yogini suki","Priyanka Mavinkar","Chaithra KM","Sajeeda Athar") and r.rev_timestamp > '20180630235959' and r.rev_timestamp < '20190101000000';
SQL

Checking query status...
