test commons - Quarry

SQL

use commonswiki_p;
SELECT concat("[[:File:",p1.page_title,"]] / "), concat("[[:File:",p2.page_title,"]]"), e1.el_to
#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
#group by page_title
#having img_width > img_height and img_width < 1000
#limit 20;
SQL

Checking query status...
