SELECT *
FROM revision LEFT JOIN actor ON (revision.rev_actor =... |
2 years ago |
SELECT *
FROM revision LEFT JOIN actor ON (revision.rev_actor =... |
2 years ago |
SELECT
DAYOFWEEK(rev_timestamp) AS dow,
HOUR(rev_timestamp) AS hour,
... |
2 years ago |
blank query |
2 years ago |
SELECT
DAYOFWEEK(rev_timestamp) AS dow,
HOUR(rev_timestamp) AS hour,
... |
2 years ago |
SELECT REPLACE(format(now(), "yyyyMMddHHmmssffff"), ",", "")
FROM
... |
2 years ago |
SELECT format(now(), "yyyyMMddHHmmssffff")
FROM
change_tag
LIMIT 10 |
2 years ago |
SELECT format(now(), "yyyymmddhhmmss")
FROM
change_tag
LIMIT 10 |
2 years ago |
SELECT CONVERT(DATETIME, now(), 127)
FROM
change_tag
LIMIT 10 |
2 years ago |
SELECT CONVERT(VARCHAR(20), now(), 'yyyymmddhhmmss')
FROM
change_tag
LIMIT 10 |
2 years ago |
SELECT CONVERT(DATETIME, now(), 'yyyymmddhhmmss')
FROM
change_tag
LIMIT 10 |
2 years ago |
SELECT CONVERT(VARCHAR, now(), 'yyyymmddhhmmss')
FROM
change_tag
LIMIT 10 |
2 years ago |
SELECT CONVERT(VARCHAR, (date_sub(now(), INTERVAL 1 WEEK)),... |
2 years ago |
SELECT CONVERT(DATETIME, (date_sub(now(), INTERVAL 1 WEEK)),... |
2 years ago |
SELECT CONVERT(DATETIME, date_sub(now(), INTERVAL 1 WEEK),... |
2 years ago |
SELECT date_sub(now(), INTERVAL 1 WEEK)
FROM
change_tag
LIMIT 10 |
2 years ago |
SELECT FORMAT(date_sub(now(), INTERVAL 1 WEEK), N'yyyymmddhhmmss')
FROM
... |
2 years ago |
SELECT *
FROM
change_tag
LIMIT 10 |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS noAction, logging.log_actor
FROM... |
2 years ago |
blank query |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS noAction, logging.log_actor
FROM... |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS noAction, logging.log_actor
FROM... |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS noAction, logging.log_actor
FROM... |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS noAction, logging.log_actor
FROM... |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS noAction
FROM... |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS noAction, logging.log_actor,... |
2 years ago |
USE viwiki_p;
SELECT *
FROM user_groups
LEFT JOIN user
ON user.user_id =... |
2 years ago |
USE viwiki_p;
SELECT *
FROM user_groups
WHERE ug_group LIKE "sysop"
LIMIT 10 |
2 years ago |
USE viwiki_p;
SELECT *
FROM logging
LEFT JOIN user_groups
ON... |
2 years ago |