# Quarry for extracting details about new articles created during Punjab... |
6 months ago |
# Quarry for extracting details about new articles created during Punjab... |
11 months ago |
# Quarry for extracting details about new articles created during Punjab... |
11 months ago |
# Quarry for extracting details about new articles created during Punjab... |
11 months ago |
# Quarry for extracting details about new articles created during Punjab... |
11 months ago |
select * from revision r where rev_page = 353946 |
11 months ago |
SELECT COUNT(*) AS cnt, r.rev_timestamp, p.page_id, p.page_title,... |
11 months ago |
select * from revision r where rev_page = 353946 |
11 months ago |
select * from revison r where rev_page = 353946 |
11 months ago |
SELECT * FROM page p2
WHERE p2.page_namespace = 0 AND p2.page_title IN... |
11 months ago |
SELECT COUNT(*) AS cnt, r.rev_timestamp, p.page_id, p.page_title,... |
11 months ago |
SELECT COUNT(*) AS cnt, r.rev_timestamp, p.page_id, p.page_title,... |
11 months ago |
SELECT * FROM page p2
WHERE p2.page_namespace = 0 AND p2.page_title IN... |
11 months ago |
SELECT page_id FROM page p2
WHERE p2.page_namespace = 0 AND... |
11 months ago |
SELECT * FROM page
WHERE page_id IN (
SELECT cl_from FROM... |
11 months ago |
SELECT * FROM page
WHERE page_id IN (
SELECT cl_from FROM... |
11 months ago |
SELECT page_title FROM page
WHERE page_id IN (
SELECT cl_from... |
11 months ago |
SELECT cl_from FROM categorylinks
WHERE
cl_to =... |
11 months ago |
SELECT cl_from FROM categorylinks
WHERE
cl_to =... |
11 months ago |