get posts list by template name

SQL

/*
select user_id,user_name ,user_editcount, DATE_FORMAT(user_registration,"%Y-%m-%d"), user_registration
from user 
where user_registration BETWEEN  20210429000000 and 20210430000000 and user_editcount >= 1 
ORDER BY user_editcount DESC
*/
#select user_id from user where user_name = "لوقا";
/*
select user_groups.*,user.user_name,user.user_editcount from user_groups 
inner join user 
on user_groups.ug_user = user.user_id
where user_groups.ug_group = "sysop"
ORDER BY user_editcount DESC

#limit 10
*/
#select COUNT(ug_user),ug_group from user_groups GROUP BY ug_group

#select * from ug_group where ug_user in ("775023")

select * from page_restrictions where pr_cascade in (1)
 limit 100
SQL

Checking query status...
