SELECT SUBSTRING(comment_text, 1, 30) AS comment_start, count(*)
FROM... |
5 years ago |
SELECT SUBSTRING(comment_text, 1, 40) AS comment_start, count(*)
FROM... |
5 years ago |
SELECT SUBSTRING(comment_text, 1, 40) AS comment_start, count(*)
FROM... |
5 years ago |
SELECT SUBSTRING(comment_text, 1, 40) AS comment_start, count(*)
FROM... |
5 years ago |
SELECT SUBSTRING(comment_text, 1, 40) AS comment_start, count(*)
FROM... |
5 years ago |
SELECT SUBSTRING(comment_text, 1, 50) AS comment_start, count(*)
FROM... |
5 years ago |
SELECT SUBSTRING(comment_text, 1, 30) AS comment_start, count(*)
FROM... |
5 years ago |
SELECT SUBSTRING(comment_text, 1, 14) AS comment_start, count(*) FROM... |
5 years ago |
SELECT SUBSTRING(comment_text, 1, 14) AS comment_start, count(*) FROM... |
5 years ago |
SELECT comment_text, count(*), SUBSTRING(comment_text, 1, 14) AS... |
5 years ago |
SELECT comment_text, count(*), SUBSTRING(comment_text, 1, 5) AS a FROM... |
5 years ago |
SELECT comment_text, count(*) FROM logging JOIN comment ON... |
5 years ago |
SELECT comment_text, count(*) FROM logging JOIN comment ON... |
5 years ago |
SELECT comment_text, count(*) AS reason FROM logging JOIN comment ON... |
5 years ago |
SELECT *, SUBSTRING(comment.comment_text, 0, 14) AS reason FROM logging JOIN... |
5 years ago |
SELECT *, SUBSTRING(comment_text, 0, 14) FROM logging JOIN comment ON... |
5 years ago |
SELECT * FROM logging JOIN comment ON comment.comment_id =... |
5 years ago |
SELECT * FROM logging WHERE log_type="delete" AND log_action="revision"... |
5 years ago |
SELECT * FROM logging WHERE log_type="delete" AND log_action="revision"... |
5 years ago |
SELECT * FROM logging WHERE log_type="delete" ORDER BY log_id DESC LIMIT 10; |
5 years ago |
SELECT * FROM logging WHERE log_type="delete" LIMIT 10; |
5 years ago |
SELECT * FROM logging WHERE log_type="delete" LIMIT 5; |
5 years ago |
SELECT * FROM logging LIMIT 5; |
5 years ago |
SELECT * FROM revision WHERE rev_deleted > 0 AND rev_timestamp <... |
5 years ago |
SELECT rev_deleted, count(*) FROM revision WHERE rev_deleted > 0 AND... |
5 years ago |
SELECT * FROM revision WHERE rev_deleted > 0 AND rev_timestamp <... |
5 years ago |
SELECT * FROM revision WHERE rev_deleted > 0 AND rev_timestamp <... |
5 years ago |
SELECT * FROM revision JOIN page ON revision.rev_page = page.page_id WHERE... |
5 years ago |
SELECT * FROM revision WHERE rev_deleted > 0 AND rev_timestamp <... |
5 years ago |
SELECT * FROM revision WHERE rev_deleted > 0 AND rev_timestamp <... |
5 years ago |
SELECT * FROM revision JOIN comment ON revision.rev_comment_id =... |
5 years ago |
SELECT * FROM revision JOIN comment ON revision.rev_comment_id =... |
5 years ago |
SELECT * FROM revision WHERE rev_id=893900798; |
5 years ago |
DESCRIBE revision; |
5 years ago |