Query Run
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 day ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
select * from pagelinks as pl left join (select * from page where... 1 week ago
select * from (select * from pagelinks) as pl left join (select * from page... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 1 week ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
-- select * from (select * from pagelinks where pagelinks.pl_from =... 2 weeks ago
select * from (select * from pagelinks where pagelinks.pl_from = 46575528)... 2 weeks ago
select * from (select * from pagelinks where pagelinks.pl_from = 46575528)... 2 weeks ago
select * from (select * from pagelinks where pagelinks.pl_from = 46575528)... 2 weeks ago
select * from (select * from pagelinks where pagelinks.pl_from = 46575528)... 2 weeks ago
select * from (select * from pagelinks where pagelinks.pl_from = 46575528)... 2 weeks ago
select * from (select * from pagelinks where pagelinks.pl_from = 46575528)... 2 weeks ago
select * from (select * from pagelinks where pagelinks.pl_from = 46575528)... 2 weeks ago
select * from (select * from pagelinks where pagelinks.pl_from = 46575528)... 2 weeks ago
select * from (select * from pagelinks where pagelinks.pl_from = 46575528)... 2 weeks ago
select * from (select * from pagelinks where pagelinks.pl_from = 64386913)... 2 weeks ago
select * from (select * from pagelinks where pagelinks.pl_from = 64386913)... 2 weeks ago
select * from (select * from pagelinks where pl_from = 64386913) as pl left... 2 weeks ago
select * from pagelinks left join page on page_id=pl_from left join... 2 weeks ago
select * from pagelinks left join page on page_id=pl_from left join... 2 weeks ago
SELECT pl_title Target, SUM(page_title IS NULL) LinkCount FROM... 2 weeks ago
SELECT * -- linktarget.lt_title, count(distinct spage.page_id) as... 2 weeks ago
SELECT * -- linktarget.lt_title, count(distinct spage.page_id) as... 2 weeks ago
SELECT * -- linktarget.lt_title, count(distinct spage.page_id) as... 2 weeks ago
SELECT linktarget.lt_title, count(distinct page.page_id) as LinkCount--... 2 weeks ago
SELECT linktarget.lt_title, count(distinct page.page_id) as LinkCount--... 2 weeks ago
SELECT linktarget.lt_title, count(distinct page.page_id) as LinkCount--... 2 weeks ago
SELECT page.page_title, linktarget.lt_title, count(lt_title) as LinkCount--... 2 weeks ago
SELECT page.page_title, linktarget.lt_title, count(lt_title) as LinkCount--... 2 weeks ago
SELECT * -- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS... 2 weeks ago
SELECT * -- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS... 2 weeks ago
SELECT * -- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS... 2 weeks ago
SELECT * -- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS... 2 weeks ago
SELECT * -- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS... 2 weeks ago
SELECT * -- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS... 2 weeks ago
SELECT * -- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS... 2 weeks ago
SELECT * -- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS... 2 weeks ago
SELECT * -- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS... 2 weeks ago
SELECT * -- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS... 2 weeks ago
SELECT * -- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS... 2 weeks ago
SELECT * -- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS... 2 weeks ago
SELECT * -- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS... 2 weeks ago
SELECT * -- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS... 2 weeks ago
SELECT pagelinks.pl_target_id AS Target -- , SUM(pagelinks.page_title IS... 2 weeks ago
SELECT pagelinks.pl_target_id AS Target, COUNT(pagelinks.pl_target_id) as... 2 weeks ago
SELECT pagelinks.pl_target_id AS Target -- , SUM(pagelinks.page_title IS... 2 weeks ago
SELECT pagelinks.pl_target_id AS Target -- , SUM(pagelinks.page_title IS... 2 weeks ago
SELECT pagelinks.pl_target_id AS Target ', SUM(pagelinks.page_title IS NULL)... 2 weeks ago
SELECT pagelinks.pl_target_id AS Target, SUM(page.page_title IS NULL) AS... 2 weeks ago
DESCRIBE pagelinks; DESCRIBE linktarget; DESCRIBE page; 2 weeks ago
DESCRIBE pagelinks; DESCRIBE linktarget; 2 weeks ago
DESCRIBE pagelinks; 2 weeks ago
SELECT pagelinks.pl_title AS Target, SUM(page.page_title IS NULL) AS... 2 weeks ago
SELECT pl_title AS Target, SUM(page_title IS NULL) AS LinkCount FROM... 2 weeks ago
SELECT pl_title AS Target, SUM(page_title IS NULL) AS LinkCount FROM... 2 weeks ago
SELECT pl_title Target, SUM(page_title IS NULL) LinkCount FROM... 2 weeks ago
SELECT pl_title Target, SUM(page_title IS NULL) LinkCount FROM... 2 weeks ago