USE rowiki_p;
SELECT COUNT(1) AS very_strict FROM page
LEFT JOIN (
SELECT... |
3 years ago |
USE rowiki_p;
SELECT COUNT(1) FROM page
LEFT JOIN (
SELECT pp_page,... |
3 years ago |
USE rowiki_p;
SELECT COUNT(1) FROM page
LEFT JOIN (
SELECT pp_page,... |
3 years ago |
USE rowiki_p;
SELECT COUNT(1) FROM page
WHERE page_namespace = 0 AND... |
3 years ago |
USE rowiki_p;
SELECT rev_actor AS actor_id, actor_user AS user_id,... |
3 years ago |
USE rowiki_p;
SELECT rev_actor AS actor_id, actor_user AS user_id,... |
3 years ago |
USE rowiki_p;
SELECT rev_actor AS actor_id, actor_user AS user_id,... |
3 years ago |
USE rowiki_p;
SELECT rev_actor AS actor_id, actor_user AS user_id,... |
3 years ago |
USE rowiki_p;
SELECT rev_actor AS actor_id, actor_user AS user_id,... |
3 years ago |
USE rowiki_p;
SELECT rev_actor AS actor_id, actor_user AS user_id,... |
3 years ago |
USE rowiki_p;
SELECT rev_actor AS actor_id, actor_user, actor_name,... |
3 years ago |
USE rowiki_p;
SELECT rev_actor AS actor_id, actor_user, actor_name,... |
3 years ago |
USE rowiki_p;
SELECT rev_actor AS actor_id, actor_user, actor_name,... |
3 years ago |
USE rowiki_p;
SELECT * FROM page_props
WHERE pp_page = 596462 |
3 years ago |
USE rowiki_p;
SELECT * FROM page_props
WHERE pp_page = 596463 |
3 years ago |
use rowiki_p;
/*SELECT * FROM revision
WHERE rev_timestamp >= 20170000000000... |
3 years ago |
use rowiki_p;
/*SELECT * FROM revision
WHERE rev_timestamp >= 20170000000000... |
3 years ago |
use rowiki_p;
/*SELECT * FROM revision
WHERE rev_timestamp >= 20170000000000... |
3 years ago |
use rowiki_p;
/*SELECT * FROM revision
WHERE rev_timestamp >= 20170000000000... |
3 years ago |
use rowiki_p;
/*SELECT * FROM revision
WHERE rev_timestamp >= 20170000000000... |
3 years ago |
use rowiki_p;
/*SELECT * FROM revision
WHERE rev_timestamp >= 20170000000000... |
3 years ago |
use rowiki_p;
/*SELECT * FROM revision
WHERE rev_timestamp >= 20170000000000... |
3 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20170000000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20160700000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20160000000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20150700000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20150000000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20140700000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20140000000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20130700000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20130000000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20120700000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20120000000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20110700000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20110000000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20100700000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20100000000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20090700000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20090000000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20080700000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20080000000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20070000000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20060000000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20050000000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp >= 20040000000000... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp <... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp <... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
WHERE rev_timestamp <... |
7 years ago |
use rowiki_p;
SELECT * FROM revision
ORDER BY rev_id DESC
LIMIT 1000; |
7 years ago |
use rowiki_p;
SELECT * FROM revision
ORDER BY red_id DESC
LIMIT 1000; |
7 years ago |
use rowiki_p;
SELECT * FROM revision
LIMIT 1000; |
7 years ago |
use rowiki_p;
SELECT * FROM categorylinks WHERE cl_to='Roboți_Wikipedia' |
7 years ago |
SELECT user.user_id AS id, 0 AS admin, 1 AS bot FROM user
INNER JOIN... |
7 years ago |
SELECT user.user_id AS id, 0 AS admin, 1 AS bot FROM user
INNER JOIN... |
7 years ago |