mikroskops - Quarry

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

use commonswiki_p;
select el_to, page_title, (select el2.el_to from externallinks el2 where el2.el_from=page_id and el_to like "http://www.panoramio.com/photo/%" limit 1)
from externallinks
join page on el_from=page_id and page_namespace=6
where el_to like "http://www.panoramio.com/user/395055%"
limit 15

SQL

use commonswiki_p;
select (select el2.el_to from externallinks el2 where el2.el_from=page_id and el_to like "http://www.panoramio.com/photo/%" limit 1) as "elto"
from externallinks
join page on el_from=page_id and page_namespace=6
where el_to like "http://www.panoramio.com/user/7669737%"

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...