select HOUR(r.rev_timestamp), COUNT(*) as n_revs from revision_userindex... |
3 years ago |
select YEAR(r.rev_timestamp), COUNT(*) as n_revs from revision_userindex... |
3 years ago |
select YEAR(r.rev_timestamp), COUNT(*) as n_revs from revision_userindex... |
3 years ago |
select YEAR(r.rev_timestamp), COUNT(*) as n_revs from revision_userindex... |
3 years ago |
select YEAR(r.rev_timestamp), COUNT(*) as n_revs from revision_userindex... |
3 years ago |
select a.actor_name, r.rev_actor as actor_id, COUNT(*) as n_revs from... |
3 years ago |
SELECT *, YEAR(rev_timestamp) FROM revision_userindex ORDER BY RAND() LIMIT 10; |
3 years ago |
SELECT * FROM revision_userindex ORDER BY RAND() LIMIT 10; |
3 years ago |
SELECT * FROM page ORDER BY RAND() LIMIT 50; |
3 years ago |
SELECT * FROM page ORDER BY RAND() LIMIT 5; |
3 years ago |
SELECT * FROM page ORDER BY RANDOM() LIMIT 5; |
3 years ago |
SELECT * FROM page ORDER BY newid() LIMIT 5; |
3 years ago |
SELECT TOP 1 * FROM page ORDER BY newid(); |
3 years ago |
select * from page a
where a.page_title like '%Judith%'; |
3 years ago |
select * from page a
where CONTAINS(a.page_title, 'Judith'); |
3 years ago |
select * from page a
where CONTAINS(a.page_title, 'Judith'); |
3 years ago |
select * from page a
where CONTAINS(a.page_title, "Judith"); |
3 years ago |
select * from page
where CONTAINS(page_title, "Judith"); |
3 years ago |
select * from page
where CONTAINS(page_title, "Judith") |
3 years ago |
select * from page
ORDER BY RAND()
LIMIT 5; |
3 years ago |
select * from page
limit 5; |
3 years ago |
select page_id from page
limit 5; |
3 years ago |
select count(page_id) from page; |
3 years ago |
SHOW TABLES FROM enwiki_p; |
3 years ago |