multi - adds, last seven days, crosswiki

This query is marked as a draft This query has been published by Count Count.

SQL

-- multi - adds, last day, crosswiki
select
    hst_host,
    count(distinct rev_page) as cnt,
    sum(rev_reverted = 1) as rev,
    sum(rev_reverted = 0) as nrev,
    hst_added_count,
    hst_removed_count
FROM
    addedlink al
    JOIN host h ON al.al_host = h.hst_id
    JOIN revision r ON al.al_rev = r.rev_id
    JOIN db d on r.rev_db = d.db_id
WHERE
    r.rev_timestamp >= NOW() - INTERVAL 7 DAY
    AND hst_added_count < 100
group by
    hst_host
having
    rev > 0
    and nrev > 0
    and count(distinct rev_db) > 1
order by
    cnt;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...