USE lawiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE hrwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE kkwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE hiwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE hewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE kawiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE kawiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE glwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE etwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE eowiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE simplewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE dawiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE bgwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE bgwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE azwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE azwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE hywiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE huwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE trwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE cswiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE shwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE srwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE rowiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE nowiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE mswiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE kowiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE idwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE fiwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE euwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE fawiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE arwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE arwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE ukwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE ptwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE ptwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE ptwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE ptwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE fawiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE fawiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE fawiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE cawiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE zhwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE viwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE viwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE eswiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE ruwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE jawiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE plwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE plwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE nlwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE jawiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE itwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE frwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE svwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE svwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE enwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
USE enwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime,... |
7 years ago |
#USE dewiki_p;
##SELECT rev_user_text AS IP, rev_timestamp AS Datetime
#FROM... |
7 years ago |
#USE dewiki_p;
##SELECT rev_user_text AS IP, rev_timestamp AS Datetime
#FROM... |
7 years ago |
#USE dewiki_p;
##SELECT rev_user_text AS IP, rev_timestamp AS Datetime
#FROM... |
7 years ago |
#USE dewiki_p;
##SELECT rev_user_text AS IP, rev_timestamp AS Datetime
#FROM... |
7 years ago |
#USE dewiki_p;
##SELECT rev_user_text AS IP, rev_timestamp AS Datetime
#FROM... |
7 years ago |
#USE dewiki_p;
##SELECT rev_user_text AS IP, rev_timestamp AS Datetime
#FROM... |
7 years ago |
#USE dewiki_p;
##SELECT rev_user_text AS IP, rev_timestamp AS Datetime
#FROM... |
7 years ago |
#USE dewiki_p;
##SELECT rev_user_text AS IP, rev_timestamp AS Datetime
#FROM... |
7 years ago |
#USE dewiki_p;
##SELECT rev_user_text AS IP, rev_timestamp AS Datetime
#FROM... |
7 years ago |
#USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
#USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
#USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
#USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
#USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
#USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
USE dewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
#USE simplewiki_p AND cywiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS... |
7 years ago |
#USE simplewiki_p AND cywiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS... |
7 years ago |
USE simplewiki_p AND cywiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS... |
7 years ago |
USE simplewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
USE simplewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime
FROM... |
7 years ago |
USE simplewiki_p;
SELECT *
FROM revision JOIN page ON page_id = rev_page... |
7 years ago |
USE simplewiki_p;
SELECT *
FROM revision JOIN page ON page_id = rev_page... |
7 years ago |
#USE simplewiki_p;
#SELECT COUNT(rev_id) AS editcounts, page_title
#FROM... |
7 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, page_title
FROM... |
7 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, page_title
FROM... |
7 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name,... |
7 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name,... |
7 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id) AS editcounts FROM revision GROUP by... |
7 years ago |
USE simplewiki_p;
SELECT * FROM revision GROUP by rev_user LIMIT 1000;
|
7 years ago |
USE simplewiki_p;
SELECT * FROM revision GROUP by rev_user LIMIT 10;
|
7 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id), rev_user FROM revision GROUP by... |
7 years ago |
USE simplewiki_p;
SELECT COUNT(rev_id) FROM revision GROUP by rev_user LIMIT 10;
|
7 years ago |
USE simplewiki_p;
SELECT pl_title
FROM pagelinks
JOIN page ON page_id =... |
7 years ago |
SELECT
p.page_id AS "page_id",
CAST(p.page_title AS CHAR(10000)... |
7 years ago |
SELECT COUNT(*) AS langcounts, ll_from, page_title
FROM langlinks JOIN page... |
7 years ago |
SELECT COUNT(DISTINCT rev_user) AS usercounts, COUNT(rev_id) editcounts FROM... |
7 years ago |