| USE enwiki_p;
SET @year_ago = DATE_SUB(NOW(), INTERVAL 1 YEAR);
SELECT... |
6 years ago |
| SELECT page_title, page_len, COUNT(afl_id) AS afl_count, gt_lat, gt_lon
FROM... |
6 years ago |
| SELECT page_title, page_len, COUNT(afl_id), gt_lat, gt_lon
FROM... |
6 years ago |
| SELECT page_title, page_len, COUNT(*), gt_lat, gt_lon
FROM... |
6 years ago |
| SELECT page_title, page_len, COUNT(*)
FROM enwiki_p.abuse_filter_log
JOIN... |
6 years ago |
| SELECT afl_id, afl_title, page_len
FROM enwiki_p.abuse_filter_log
JOIN... |
6 years ago |
| SELECT afl_id, afl_title, page_len
FROM enwiki_p.abuse_filter_log
JOIN... |
6 years ago |
| SHOW TABLES FROM enwiki_p; |
6 years ago |
| DESCRIBE enwiki_p.page; |
6 years ago |
| SHOW TABLES FROM enwiki_p; |
6 years ago |
| SHOW TABLES WHERE Tables_in_test LIKE 'enwiki_p.%'; |
6 years ago |
| SELECT afl_id, afl_title, old_text
FROM enwiki_p.abuse_filter_log
JOIN... |
6 years ago |
| SELECT afl_id, afl_title, old_text
FROM enwiki_p.abuse_filter_log
JOIN... |
6 years ago |
| SELECT afl_id, afl_title, old_text
FROM enwiki_p.abuse_filter_log
JOIN... |
6 years ago |
| SELECT afl_id, afl_title, old_text
FROM enwiki_p.abuse_filter_log
JOIN text... |
6 years ago |
| SELECT afl_id, afl_title, old_text
FROM enwiki_p.abuse_filter_log
JOIN text... |
6 years ago |
| SELECT afl_id, afl_title, old_text
FROM enwiki_p.abuse_filter_log
JOIN... |
6 years ago |
| SELECT afl_id, afl_title, TRIM(LEADING 'stored-text:' FROM... |
6 years ago |
| SELECT afl_id, afl_title, afl_var_dump TEXT
FROM... |
6 years ago |
| SELECT afl_id, afl_title, afl_var_dump TEXT
FROM... |
6 years ago |
| SELECT afl_id, afl_title, afl_var_dump AS TEXT
FROM... |
6 years ago |
| SELECT afl_id, afl_title, COLUMN_GET(afl_var_dump, "new_size" AS... |
6 years ago |
| SELECT afl_id, afl_title, afl_var_dump
FROM enwiki_p.abuse_filter_log
WHERE... |
6 years ago |
| SELECT afl_id, afl_title, afl_var_dump
FROM enwiki_p.abuse_filter_log
WHERE... |
6 years ago |
| SELECT afl_id, afl_title, afl_actions
FROM enwiki_p.abuse_filter_log
WHERE... |
6 years ago |
| SELECT afl_id, afl_title, afl_timestamp
FROM enwiki_p.abuse_filter_log
WHERE... |
6 years ago |
| SELECT afl_id, afl_title
FROM enwiki_p.abuse_filter_log
LIMIT 5; |
6 years ago |
| SELECT afl_id, afl_title,
FROM enwiki_p.abuse_filter_log
LIMIT 5; |
6 years ago |
| SELECT *
FROM enwiki_p.abuse_filter_log
WHERE afl_title LIKE "%High School%"
LIMIT 5; |
6 years ago |
| SELECT *
FROM enwiki_p.logging
WHERE log_type = "abusefilter" AND log_action... |
6 years ago |
| SELECT log_title, log_params, log_action
FROM enwiki_p.logging
WHERE... |
6 years ago |
| SELECT log_title, log_params, log_action
FROM enwiki_p.logging
WHERE... |
6 years ago |
| SELECT log_params, log_action
FROM enwiki_p.logging
WHERE log_type =... |
6 years ago |
| SELECT log_params, log_action
FROM enwiki_p.logging
WHERE log_type =... |
6 years ago |
| SELECT *
FROM enwiki_p.logging
WHERE log_type = "abusefilter" AND log_action... |
6 years ago |
| SELECT *
FROM enwiki_p.logging
WHERE log_type = "abusefilter" AND log_action... |
6 years ago |
