مستخدمين اليوم

SQL

/*
#select CONCAT('"',log_title,'",') 
select log_title
from logging 
where log_type in ("newusers") 
and log_timestamp > DATE_SUB(NOW(), INTERVAL 1 day) 
and log_title not in (
  select page.page_title from categorylinks 
  inner join page on page.page_id = categorylinks.cl_from
  where cl_to like "أسماء_مستخدمين_مخالفة_مرشحة_للمنع" 
  and cl_type in ("page")
)
and log_title not in (
	select replace(user.user_name," ","_") as "user_name_temp" from ipblocks
	inner join user on ipblocks.ipb_user = user.user_id
)

*/


 select log_title as "q_log_title"
        from logging 
        where log_type in ("newusers") 
        and log_timestamp BETWEEN 20221207000000 AND 20221207235959
        and log_title not in (
          select page.page_title from categorylinks 
          inner join page on page.page_id = categorylinks.cl_from
          where cl_to like "أسماء_مستخدمين_مخالفة_مرشحة_للمنع" 
          and cl_type in ("page")
        )
        and log_title not in (
            select replace(user.user_name," ","_") as "user_name_temp" from ipblocks
            inner join user on ipblocks.ipb_user = user.user_id
        )
SQL

Checking query status...
