| # Casting is done to get rid of a BIGINT UNSIGNED related errpr
select... |
7 years ago |
| select SUM(ABS(CAST(r.rev_len as SIGNED)-CAST(r_prev.rev_len as SIGNED))) as... |
7 years ago |
| select ABS(CAST(r.rev_len as SIGNED)-CAST(r_prev.rev_len as SIGNED)) as... |
7 years ago |
| select ABS(r.rev_len-r_prev.rev_len) as rev_len_diff # trying to sum this... |
7 years ago |
| select ABS(r.rev_len-r_prev.rev_len) as rev_len_diff # trying to sum this... |
7 years ago |
| select ABS(r.rev_len-r_prev.rev_len) as rev_len_diff # trying to sum this... |
7 years ago |
| select ABS(r.rev_len-r_prev.rev_len) as rev_len_diff # trying to sum this... |
7 years ago |
| select ABS(r.rev_len-r_prev.rev_len) as rev_len_diff # trying to sum this... |
7 years ago |
| select SUM(CAST(ABS(r.rev_len-r_prev.rev_len) as SIGNED)) as... |
7 years ago |
| select SUM(CAST(ABS(r.rev_len-r_prev.rev_len) as UNSIGNED)) as... |
7 years ago |
| select SUM(CAST(ABS(r.rev_len-r_prev.rev_len) as SIGNED)) as... |
7 years ago |
| select CAST(ABS(r.rev_len-r_prev.rev_len) as SIGNED) as rev_len_diff
from... |
7 years ago |
| select ABS(r.rev_len-r_prev.rev_len) as rev_len_diff
from... |
7 years ago |
| select sum(abs(r.rev_len-r_prev.rev_len)) as rev_len_diff
from... |
7 years ago |
| select abs(r.rev_len-r_prev.rev_len) as rev_len_diff
from... |
7 years ago |
| select sum(abs(r.rev_len-r_prev.rev_len)) as sum_rev_len_diff
from... |
7 years ago |
| select r.rev_parent_id, r.rev_id as new_rev_id, r_prev.rev_id as... |
7 years ago |
| select r.rev_parent_id, r.rev_id as new_rev_id, r_prev.rev_id as... |
7 years ago |
| select r.rev_parent_id, r.rev_id as new_rev_id, r_prev.rev_id as... |
7 years ago |
| select r.rev_parent_id, r.rev_id as new_rev_id, r.rev_len as new_rev_len,... |
7 years ago |
| select r.rev_parent_id, r.rev_len, r_prev.rev_len
from svwiki_p.change_tag... |
7 years ago |
| select r.rev_parent_id, r.rev_len, r_prev.rev_id
from svwiki_p.change_tag... |
7 years ago |
| select r.rev_parent_id, r.rev_len
from svwiki_p.change_tag c
join... |
7 years ago |
| select r.rev_parent_id, r.rev_len, r_prev.rev_len
from svwiki_p.change_tag... |
7 years ago |
| select r.rev_parent_id, r.rev_len
from svwiki_p.change_tag c
join... |
7 years ago |
| select r.rev_parent_id, r.rev_len
from svwiki_p.change_tag c
join... |
7 years ago |
| select r.rev_parent_id, r.rev_len, r_prev.rev_len
from svwiki_p.change_tag... |
7 years ago |
| select r.rev_parent_id, r.rev_len, r_prev.rev_len
from svwiki_p.change_tag... |
7 years ago |
| select r.rev_parent_id, r.rev_len, r_prev.rev_len
from svwiki_p.change_tag... |
7 years ago |
| select r.rev_parent_id, r.rev_len, r_prev.rev_len
from svwiki_p.change_tag... |
7 years ago |
| select r.rev_parent_id, r.rev_len, r_prev.rev_len
from svwiki_p.change_tag... |
7 years ago |
| select r.rev_parent_id, r.rev_len, r_prev.rev_len
from svwiki_p.change_tag... |
7 years ago |
| select r.rev_parent_id, r.rev_len, r_prev.rev_len
from svwiki_p.change_tag... |
7 years ago |
| select r.rev_parent_id, r.rev_len, (
SELECT r2.rev_len as prev_len
FROM... |
7 years ago |
| select r.rev_parent_id, r.rev_len, prev_len, (
SELECT r2.rev_len as... |
7 years ago |
| select r.rev_parent_id, r.rev_len, prev_len
from svwiki_p.change_tag c
join... |
7 years ago |
| select r.rev_parent_id, r.rev_len, prev_len
from svwiki_p.change_tag c
join... |
7 years ago |
| select r.rev_parent_id, r.rev_len, prev_len
from svwiki_p.change_tag c
join... |
7 years ago |
| select r.rev_parent_id, r.rev_len, prev_len
from svwiki_p.change_tag c
join... |
7 years ago |
| select r.rev_parent_id, r.rev_len, prev_len
from svwiki_p.change_tag c
join... |
7 years ago |
| select r.rev_parent_id, r.rev_len
from svwiki_p.change_tag c
join... |
7 years ago |
| select r.*
from svwiki_p.change_tag c
join svwiki_p.revision r
on... |
7 years ago |
| select r.rev_user_text as username, count(r.rev_id) as usage_count
from... |
7 years ago |
