استعلامات مهمه في الوقت الحاضر

SQL

/*
count os ~= 8000
select COUNT(DISTINCT log_title) as "logo count" from logging 
where log_type in ("review") 
and log_namespace in (0)
and log_timestamp between 20221205000000 and 20230127000000
#limit 10

# count is 380316
select count(DISTINCT page.page_title ) as "page count" from revision
inner join page on revision.rev_page = page.page_id
where page.page_namespace in (0)
and rev_timestamp between 20221205000000 and 20230127000000


*/

/*

select DISTINCT log_title as "logo count" from logging 
where log_type in ("review") 
and log_namespace in (0)
and log_timestamp between 20221205000000 and 20230127000000

UNION

select DISTINCT page.page_title as "page count" from revision
inner join page on revision.rev_page = page.page_id
where page.page_namespace in (0)
and rev_timestamp between 20221205000000 and 20230127000000

*/



/*
SELECT COUNT(*) 
FROM (
  select DISTINCT log_title as "logo count" from logging 
  where log_type in ("review") 
  and log_namespace in (0)
  and log_timestamp between 20221205000000 and 20230127000000

  UNION

  select DISTINCT page.page_title as "page count" from revision
  inner join page on revision.rev_page = page.page_id
  where page.page_namespace in (0)
  and rev_timestamp between 20221205000000 and 20230127000000
) AS pages_list



*/

select * from flaggedpages limit 10
SQL

Checking query status...
