test commons - Quarry

SQL

use commonswiki_p;
#SELECT concat("[[:File:",p1.page_title,"]] / "), concat("[[:File:",p2.page_title,"]]"), e1.el_to
SELECT el_to, GROUP_CONCAT(DISTINCT page_title SEPARATOR '/')
#count(page_title)
#  concat("[[:File:",page_title,"]]"),
#  img_width, img_height
/*
FROM page p1, page p2, externallinks e1, externallinks e2
WHERE e1.el_to LIKE '%flickr.com/photos%' and e1.el_to = e2.el_to
and p1.page_id = e1.el_from and p2.page_title = e2.el_from 
and p1.page_namespace = 6 and p2.page_namespace = 6 
and p1.page_title <> p2.page_title*/
FROM page join externallinks on page_id = el_from and page_namespace = 6 
WHERE el_to LIKE '%flickr.com/photos%'
having count(distinct el_from)>1
#group by page_title
#having img_width > img_height and img_width < 1000
#limit 20;
SQL

Checking query status...
