Untitled query #88935

SQL

select actor_name, user_editcount from actor,user
where 
 user_id=actor_user
and actor_name in ("Pranayraj1985","యర్రా రామారావు","Batthini Vinay Kumar Goud","Chaduvari","స్వరలాసిక","T.sujatha","పాలగిరి","శ్రీరామమూర్తి","Pavan santhosh.s","రవిచంద్ర","B.K.Viswanadh","Kopparthi janardhan1965","Divya4232","Nskjnv","Nagarani Bethi","V Bhavya","MYADAM ABHILASH","RATHOD SRAVAN","ప్రభాకర్ గౌడ్ నోముల","Kasyap","Tmamatha","Thirumalgoud","Mothiram123","Vjsuseela","Katta Srinivasa Rao","PARALA NAGARAJU","Kalasagary","kiran sidam","I.Mahesh","Saiphani02","Varaprasad Sidam","Svpnikhil","bvprasadtewiki","Edla praveen","Pinkypun","Vadanagiri bhaskar","Svgvenuvu","Mouryan","ప్రశాంతి","radhika41","Adbh266","A.Murali","Deepa kammagani","Ramesam54","Bathula Ganesh Goud","Athram Rajkumar","palakodety","srinivasrjy","Surenderk")
/* and rev1.rev_actor in (select rev_actor from revision,actor
where actor_id=rev_actor
and substr(rev_timestamp,1,6) >= "202306"
group by rev_actor
--                       having count(rev_actor)>0
                      )*/
and actor_id not in (select rev_actor from revision where rev_timestamp >=20230000000000)
-- and user_editcount>=500
order by user_editcount desc
SQL

Checking query status...
