USE enwiki_p;
SELECT DISTINCT log_type FROM logging; |
7 years ago |
USE enwiki_p;
SELECT *
FROM logging
WHERE log_timestamp > 20170216000000
LIMIT 50; |
7 years ago |
USE enwiki_p;
SELECT *
FROM logging
WHERE log_timestamp > 20170216000000
LIMIT 1; |
7 years ago |
USE enwiki_p;
SELECT *
FROM logging
LIMIT 1; |
7 years ago |
USE enwiki_p;
SELECT *
FROM logging
WHERE log_timestamp > 20170217000000
LIMIT 1; |
7 years ago |
USE enwiki_p;
SELECT *
FROM logging
WHERE log_timestamp > 20170217053000
LIMIT 1; |
7 years ago |
USE enwiki_p;
SELECT *
FROM logging
WHERE log_timestamp > 20170217053000
LIMIT 50; |
7 years ago |
USE enwiki_p;
SELECT *
FROM logging
AND log_timestamp > 20170217053000
LIMIT 50; |
7 years ago |
USE enwiki_p;
SELECT *
FROM pagetriage_page
WHERE ptrp_last_reviewed_by = 4708675; |
7 years ago |
USE enwiki_p;
SELECT *
FROM pagetriage_page
LIMIT 10; |
7 years ago |
USE enwiki_p;
SELECT *
FROM logging
WHERE log_type = 'patrol'
LIMIT 10; |
7 years ago |
USE enwiki_p;
SELECT *
FROM logging
WHERE log_type = 'patrol'
AND... |
7 years ago |
USE enwiki_p;
SELECT *
FROM logging
WHERE log_type = 'patrol'
LIMIT 10; |
7 years ago |