Fork of Untitled query #26696 by Edgars2007
This query is marked as a draft This query has been published by Edgars2007.

SQL

AخA
 
use dewiki_p;
SELECT enp.page_namespace, enp.page_title, enel.el_to,
    (select pp.pp_value from page_props pp where pp.pp_page=enp.page_id and pp_propname='wikibase_item') as wd
FROM page enp, externallinks enel
WHERE (enel.el_index LIKE "http://com.geni%" or enel.el_index LIKE "https://com.geni%")
        AND enel.el_from = enp.page_id
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
All SQL code is licensed under CC0 License.

Checking query status...