USE enwiki_p;
SELECT ptrp_page_id, page_title
FROM pagetriage_page p
JOIN... |
7 years ago |
USE enwiki_p;
SELECT ptrp_page_id, ptrp_deleted, ptrt_tag_name, ptrpt_value... |
7 years ago |
USE enwiki_p;
SELECT ptrp_page_id, ptrp_deleted, ptrt_tag_name, ptrpt_value... |
7 years ago |
USE enwiki_p;
SELECT ptrp_page_id, ptrp_deleted, ptrt_tag_name FROM... |
7 years ago |
USE enwiki_p;
SELECT COUNT(DISTINCT ptrp_page_id) FROM pagetriage_page... |
7 years ago |
USE enwiki_p;
SELECT COUNT(DISTINCT ptrp_page_id) FROM pagetriage_page... |
7 years ago |
USE enwiki_p;
SELECT COUNT(DISTINCT ptrp_page_id) FROM pagetriage_page
LEFT... |
7 years ago |
USE enwiki_p;
SELECT COUNT(pagetriage_page.*) FROM pagetriage_page
LEFT... |
7 years ago |
USE enwiki_p;
SELECT COUNT(DISTINCT ptrp_page_id) FROM pagetriage_page
LEFT... |
7 years ago |
USE enwiki_p;
SELECT COUNT(ptrp_page_id) FROM pagetriage_page
LEFT JOIN... |
7 years ago |
USE enwiki_p;
SELECT * FROM pagetriage_page
LEFT JOIN pagetriage_page_tags... |
7 years ago |
USE enwiki_p;
-- SELECT COUNT(*) FROM pagetriage_page JOIN page ON page_id =... |
7 years ago |
USE enwiki_p;
-- SELECT COUNT(*) FROM pagetriage_page JOIN page ON page_id =... |
7 years ago |
USE enwiki_p;
SELECT COUNT(*) FROM pagetriage_page JOIN page ON page_id =... |
7 years ago |
USE enwiki_p;
SELECT COUNT(page_id) FROM pagetriage_page JOIN page ON... |
7 years ago |
USE enwiki_p;
SELECT ROUND((
(SELECT COUNT(page_id) FROM pagetriage_page... |
7 years ago |
USE enwiki_p;
SELECT * FROM pagetriage_page
JOIN page ON page_id =... |
7 years ago |
use enwiki_p;
SELECT * FROM pagetriage_page
JOIN page ON page_id =... |
7 years ago |
use enwiki_p;
SELECT * FROM pagetriage_page
-- left JOIN page ON page_id =... |
7 years ago |
use enwiki_p;
SELECT COUNT(*) FROM pagetriage_page
-- left JOIN page ON... |
7 years ago |
use enwiki_p;
SELECT COUNT(*) FROM pagetriage_page
left JOIN page ON... |
7 years ago |
use enwiki_p;
SELECT COUNT(*) FROM pagetriage_page
JOIN page ON page_id =... |
7 years ago |
use enwiki_p;
SELECT COUNT(*) FROM pagetriage_page
JOIN page ON page_id =... |
7 years ago |
use enwiki_p;
SELECT COUNT(*) FROM pagetriage_page WHERE ptrp_reviewed = 0... |
7 years ago |
use enwiki_p;
SELECT COUNT(*) FROM pagetriage_page WHERE ptrp_reviewed = 0... |
7 years ago |
use s51306__copyright_p;
-- show tables;
-- describe wikiprojects;
-- show... |
8 years ago |
use s51306__copyright_p;
-- show tables;
-- describe wikiprojects;
show... |
8 years ago |
use s51306__copyright_p;
-- show tables;
-- describe wikiprojects;
show... |
8 years ago |
use s51306__copyright_p;
-- show tables;
-- describe wikiprojects;
show... |
8 years ago |
use s51306__copyright_p;
-- show tables;
-- describe wikiprojects;
explain... |
8 years ago |
use s51306__copyright_p;
-- show tables;
-- describe wikiprojects;
explain... |
8 years ago |
use s51306__copyright_p;
-- show tables;
describe wikiprojects;
select... |
8 years ago |
use s51306__copyright_p;
-- show tables;
describe wikiprojects;
select... |
8 years ago |
use s51306__copyright_p;
-- show tables;
describe wikiprojects;
select... |
8 years ago |
use s51306__copyright_p;
-- show tables;
describe wikiprojects;
select... |
8 years ago |
use s51306__copyright_p;
-- show tables;
describe wikiprojects;
-- select... |
8 years ago |
use s51306__copyright_p;
show tables;
-- describe copyright_diffs;
-- select... |
8 years ago |
use s51306__copyright_p;
describe copyright_diffs;
-- select lang, project... |
8 years ago |
use s51306__copyright_p;
-- describe copyright_diffs;
select lang, project... |
8 years ago |
use s51306__copyright_p;
describe copyright_diffs; |
8 years ago |
use s51306__copyright_p;
show tables; |
8 years ago |
use s51306__copyright_p; |
8 years ago |