| SELECT
l.log_user,
CONCAT('[[User:', user_name, '|', user_name, ']]') AS... |
7 years ago |
| SELECT
l.log_user,
CONCAT('[[User:', user_name, '|', user_name, ']]') AS... |
7 years ago |
| SELECT
l.log_user,
CONCAT('[[User:', user_name, '|', user_name, ']]') AS... |
7 years ago |
| SELECT
l.log_user,
CONCAT('[[User:', user_name, '|', user_name, ']]') AS... |
7 years ago |
| SELECT
l.log_user,
CONCAT('[[User:', user_name, '|', user_name, ']]') AS... |
7 years ago |
| SELECT
log_user,
CONCAT('[[User:', user_name, '|', user_name, ']]') AS... |
7 years ago |
| SELECT
log_user,
user_name AS 'Username',
log_count AS 'Number of... |
7 years ago |
| SELECT
log_user,
user_name AS 'Username',
log_count AS 'Number of... |
7 years ago |
| SELECT log_timestamp,log_user_text,log_title AS... |
8 years ago |
| SELECT log_timestamp,log_user_text,log_title AS... |
8 years ago |
| SELECT log_timestamp,log_user_text,log_title AS 'thanked'
FROM... |
8 years ago |
| SELECT log_timestamp,log_user_text,log_title AS 'thanked'
FROM... |
8 years ago |
| SELECT * FROM logging_userindex
WHERE log_type = 'thanks'
ORDER BY log_id... |
8 years ago |
| SELECT * FROM logging_userindex
ORDER BY log_timestamp DESC
LIMIT 1000; |
8 years ago |
| SELECT * FROM logging_userindex
WHERE log_type != 'abusefilter'
AND... |
8 years ago |
| SELECT * FROM logging_userindex
WHERE log_type != 'abusefilter'
LIMIT 1000; |
8 years ago |
| SELECT * FROM logging_userindex
WHERE log_type != 'abusefilter'
AND log_type... |
8 years ago |
| SELECT * FROM logging_userindex
WHERE log_type != 'abusefilter'
AND log_type... |
8 years ago |
| SELECT * FROM logging_userindex LIMIT 1000; |
8 years ago |
| blank query |
8 years ago |
| SELECT * FROM `user` WHERE user_name='LeonRaper'; |
8 years ago |
| SELECT pl_title as title
FROM pagelinks
LEFT JOIN page
ON pl_namespace =... |
8 years ago |
| SELECT DISTINCT pl_title as title
FROM pagelinks
LEFT JOIN page
ON... |
8 years ago |
| SELECT DISTINCT pl_title as title
FROM pagelinks
LEFT JOIN page
ON... |
8 years ago |
| SELECT *
FROM pagelinks
LEFT JOIN page
ON pl_namespace = page_namespace AND... |
8 years ago |
| SELECT DISTINCT pl_title AS title
FROM pagelinks
LEFT JOIN page
ON... |
8 years ago |
| SELECT DISTINCT pl_title AS title
FROM pagelinks
LEFT JOIN page
ON... |
8 years ago |
| SELECT DISTINCT pl_title AS title
FROM pagelinks
LEFT JOIN page
ON... |
8 years ago |
| SELECT pl_title AS title
FROM pagelinks
LEFT JOIN page
ON pl_namespace =... |
8 years ago |
| SELECT DISTINCT pl_title AS title
FROM pagelinks
LEFT JOIN page
ON... |
8 years ago |
| SHOW CREATE TABLE page; |
8 years ago |
| SHOW CREATE TABLE pagelinks; |
8 years ago |
| DESCRIBE pagelinks; |
8 years ago |
| blank query |
8 years ago |
| SELECT
log_user,
user_name AS 'Username',
user_registration AS... |
8 years ago |
| SELECT
log_user,
user_name AS 'Username',
user_registration AS... |
8 years ago |
| SELECT
log_user,
user_name AS 'Username',
user_registration AS... |
8 years ago |
| SELECT
log_user,
user_name AS 'Username',
user_registration AS... |
8 years ago |
| SELECT
log_user,
user_name AS 'Username',
user_registration AS... |
8 years ago |
| SELECT
log_user,
user_name AS 'Username',
user_registration AS... |
8 years ago |
| SELECT
log_user,
user_name AS 'Username',
user_registration AS... |
8 years ago |
| SELECT
log_user,
user_name AS 'Username',
user_registration AS... |
8 years ago |
| SELECT
log_user,
user_name AS 'Username',
user_registration AS... |
8 years ago |
| SELECT
log_user,
user_name AS 'Username',
user_registration AS... |
8 years ago |
| SELECT
log_user,
user_name AS 'Username',
user_registration AS... |
8 years ago |
| DESCRIBE logging;
SHOW CREATE TABLE logging;
DESCRIBE logging_logindex;
SHOW... |
8 years ago |
| DESCRIBE logging;
SHOW CREATE TABLE logging;
DESCRIBE logging_logindex;
SHOW... |
8 years ago |
| DESCRIBE logging;
SHOW CREATE TABLE logging;
DESCRIBE logging_logindex;
SHOW... |
8 years ago |
| DESCRIBE logging;
SHOW CREATE TABLE logging;
DESCRIBE logging_logindex;
SHOW... |
8 years ago |
| DESCRIBE logging;
DESCRIBE logging_logindex;
DESCRIBE... |
8 years ago |
| DESCRIBE logging; |
8 years ago |
| DESCRIBE logging; |
8 years ago |
| DESCRIBE logging; |
8 years ago |
| DESCRIBE logging; |
8 years ago |
| DESCRIBE logging; |
8 years ago |
| DESCRIBE logging; |
8 years ago |
| DESCRIBE logging; |
8 years ago |
| DESCRIBE logging; |
8 years ago |
| DESCRIBE logging; |
8 years ago |
| SELECT COUNT(*)
FROM logging
WHERE log_type='patrol'
AND log_timestamp >=... |
8 years ago |
| SELECT COUNT(*)
FROM logging
WHERE log_type='patrol'
AND log_timestamp >=... |
8 years ago |
| SELECT COUNT(*)
FROM logging
WHERE log_type='patrol'
AND log_timestamp... |
8 years ago |
| SELECT COUNT(*)
FROM logging
WHERE log_type='patrol'
AND log_timestamp... |
8 years ago |
| SELECT COUNT(*)
FROM logging
WHERE log_type='patrol'
AND log_timestamp... |
8 years ago |
| SELECT COUNT(*)
FROM logging
WHERE log_type='patrol'
AND log_timestamp... |
8 years ago |
| SELECT COUNT(*)
FROM logging_userindex
WHERE log_type='patrol'
AND... |
8 years ago |
| SELECT COUNT(*)
FROM logging_userindex
WHERE log_type='patrol'
AND... |
8 years ago |
| blank query |
8 years ago |
| blank query |
8 years ago |
| blank query |
8 years ago |
| blank query |
8 years ago |
| blank query |
8 years ago |
| blank query |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
AND log_action <>... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
AND... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
AND... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
AND log_params LIKE... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
AND log_params LIKE... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
AND log_params NOT... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
AND log_params NOT... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
AND log_params NOT... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
ORDER BY... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
ORDER BY... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
ORDER BY... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
ORDER BY... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
ORDER BY... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
ORDER BY... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
AND... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
AND... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
AND... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
AND... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
AND... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
AND... |
8 years ago |
| SELECT *
FROM logging_userindex
WHERE log_type='patrol'
AND... |
8 years ago |
| blank query |
8 years ago |
| SELECT_abort
user_name AS 'Username',
user_registration AS... |
8 years ago |
| SELECT
user_name AS 'Username',
user_registration AS... |
8 years ago |
| SELECT
user_name AS 'Username',
user_registration AS... |
8 years ago |
| SELECT
recent_user_text AS 'Username',
user_registration AS... |
8 years ago |
| SELECT
recent_user_text AS 'Username',
rev_min AS 'First... |
8 years ago |
| SELECT
recent_user_text AS 'Username',
rev_min AS 'First... |
8 years ago |
| SELECT
recent_user_text AS 'Username',
rev_min AS 'First... |
8 years ago |
| SELECT
recent_user_text AS 'Username',
rev_min AS 'First... |
8 years ago |
| SELECT
recent_user_text AS 'Username',
rev_min AS 'First... |
8 years ago |
|
|
8 years ago |
| CREATE TEMPORARY TABLE IF NOT EXISTS recent_patrols AS
(
SELECT... |
8 years ago |
| CREATE TEMPORARY TABLE IF NOT EXISTS recent_patrols AS
(
SELECT... |
8 years ago |
| SELECT log_user_text AS recent_user_text, COUNT(*) AS recent_count
INTO... |
8 years ago |
| blank query |
8 years ago |
| SELECT DISTINCT log_action FROM logging_userindex
WHERE log_type='patrol'; |
8 years ago |
| SELECT * FROM logging_userindex
WHERE log_type='patrol'
ORDER BY... |
8 years ago |
| SELECT * FROM logging_userindex
WHERE log_type='patrol'
ORDER BY... |
8 years ago |
| SELECT * FROM logging_userindex
WHERE log_type='patrol'
ORDER BY... |
8 years ago |
| blank query |
8 years ago |
| SELECT * FROM revision_userindex WHERE rev_user_text='Cryptic' ORDER BY... |
8 years ago |
| blank query |
8 years ago |
| SELECT * FROM revision LIMIT 5; |
8 years ago |
| blank query |
8 years ago |
| SELECT DISTINCT log_user AS recent_user
FROM logging
WHERE... |
8 years ago |
