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

This query is marked as a draft This query has been published by لوقا.
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 flaggedpages.*,page.page_title from flaggedpages
join page on flaggedpages.fp_page_id = page.page_id
limit 10
*/


/*
SELECT count(pl_2_title)
FROM (
    SELECT DISTINCT log_title AS "pl_2_title"
    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 "pl_2_title"
    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
WHERE pl_2_title NOT IN (
    SELECT page.page_title 
    FROM flaggedpages
    JOIN page ON flaggedpages.fp_page_id = page.page_id
)
*/



/*
SELECT pl_2_title
FROM (
    SELECT DISTINCT log_title AS "pl_2_title"
    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 "pl_2_title"
    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
    and page.page_id NOT IN ( SELECT fp_page_id FROM flaggedpages )
) AS pages_list
*/
/*
SELECT count(pl_2_title)
FROM (
    SELECT DISTINCT log_title AS "pl_2_title"
    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 "pl_2_title"
    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
    and page.page_id NOT IN ( SELECT fp_page_id FROM flaggedpages )
) AS pages_list

*/
/*
SELECT count(pl_2_title)
FROM (
    SELECT DISTINCT log_title AS "pl_2_title"
    FROM logging
    WHERE log_type IN ("review") 
    AND log_namespace IN (0)
    AND log_timestamp > 20230127000000
    UNION
    SELECT DISTINCT page.page_title AS "pl_2_title"
    FROM revision
    INNER JOIN page ON revision.rev_page = page.page_id
    WHERE page.page_namespace IN (0)
    AND rev_timestamp > 20230127000000
) AS pages_list
*/

SELECT pl_2_title
FROM (
    SELECT DISTINCT log_title AS "pl_2_title"
    FROM logging
    WHERE log_type IN ("review") 
    AND log_namespace IN (0)
    AND log_timestamp > 20230129000000
  	limit 10
    UNION
    SELECT DISTINCT page.page_title AS "pl_2_title"
    FROM revision
    INNER JOIN page ON revision.rev_page = page.page_id
    WHERE page.page_namespace IN (0)
    AND rev_timestamp > 20230129000000 and page_is_redirect = 0
 	 limit 10
) AS pages_list
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
