USE enwiki_p;
SELECT DISTINCT RIGHT(LOG_TIMESTAMP,2)
FROM logging
ORDER BY... |
5 years ago |
USE enwiki_p;
SELECT DISTINCT left(LOG_TIMESTAMP,2)
FROM logging
ORDER BY... |
5 years ago |
USE enwiki_p;
SELECT *
FROM logging
ORDER BY log_timestamp DESC
LIMIT 100 |
5 years ago |
USE enwiki_p;
SELECT *
FROM logging
LIMIT 100 |
5 years ago |
USE enwiki_p;
SELECT *
FROM archive
WHERE ar_title LIKE '%List_of_%'
LIMIT 100 |
5 years ago |
USE enwiki_p;
SELECT *
FROM archive
LIMIT 100 |
5 years ago |
USE enwiki_p;
SELECT *
FROM user
LIMIT 100 |
5 years ago |
USE enwiki_p;
SELECT *
FROM Pages.archive
LIMIT 100 |
5 years ago |
USE enwiki_p;
SELECT *
FROM users.user
LIMIT 100 |
5 years ago |
USE enwiki_p;
SELECT TOP 100 *
FROM users.user |
5 years ago |
USE enwiki_p;
SELECT TOP 100 *
FROM users.user |
5 years ago |