# Casting is done to get rid of a BIGINT UNSIGNED related error
SELECT... |
8 years ago |
SELECT r.rev_page, r.rev_comment, r.rev_len, r_prev.rev_len,... |
8 years ago |
SELECT r.rev_page, r.rev_comment, r.rev_len, r_prev.len, ABS(CAST(r.rev_len... |
8 years ago |
SELECT r.rev_page, r.rev_comment, r.rev_len, r_prev.len, ABS(CAST(r.rev_len... |
8 years ago |
SELECT rev_page, rev_comment, rev_len FROM wikidatawiki_p.revision r
JOIN... |
8 years ago |
SELECT rev_page, rev_comment FROM wikidatawiki_p.revision
JOIN... |
8 years ago |
SELECT rev_page, rev_comment FROM wikidatawiki_p.revision
JOIN... |
8 years ago |
SELECT rev_page, rev_comment FROM wikidatawiki_p.revision
JOIN... |
8 years ago |
SELECT COUNT(DISTINCT(rev_page)) FROM wikidatawiki_p.revision
JOIN... |
8 years ago |
SELECT COUNT(DISTINCT(rev_page)) FROM wikidatawiki_p.revision
JOIN... |
8 years ago |