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

SQL

select CONCAT('"',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
)
SQL

Checking query status...
