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 from user_groups 
inner join user 
on user_groups.ug_user = user.user_id
where user_groups.ug_expiry is not null
limit 10
*/
select COUNT(ug_user),ug_group from user_groups GROUP BY ug_group

SQL

Checking query status...