thanks :-)
On Thu, Sep 4, 2014 at 11:44 AM, Jeremy Baron <jeremy(a)tuxmachine.com> wrote:
On Thu, Sep 4, 2014 at 10:37 AM, Magnus Manske
<magnusmanske(a)googlemail.com> wrote:
Except it's not in the interwiki table
either.
it sure is there:
MariaDB [commonswiki_p]> select * from page,iwlinks where
page_namespace=6 AND page_title='Edinburgh_Castle_-_06.jpg' AND
iwl_from=page.page_id AND iwl_prefix='wikidata'\G
*************************** 1. row ***************************
page_id: 35057065
page_namespace: 6
page_title: Edinburgh_Castle_-_06.jpg
page_restrictions:
page_counter: 0
page_is_redirect: 0
page_is_new: 0
page_random: 0.918411261694
page_touched: 20140904101906
page_links_updated: 20140904070656
page_latest: 133476796
page_len: 823
page_no_title_convert: 0
page_content_model: NULL
iwl_from: 35057065
iwl_prefix: wikidata
iwl_title: Q17570962
*************************** 2. row ***************************
page_id: 35057065
page_namespace: 6
page_title: Edinburgh_Castle_-_06.jpg
page_restrictions:
page_counter: 0
page_is_redirect: 0
page_is_new: 0
page_random: 0.918411261694
page_touched: 20140904101906
page_links_updated: 20140904070656
page_latest: 133476796
page_len: 823
page_no_title_convert: 0
page_content_model: NULL
iwl_from: 35057065
iwl_prefix: wikidata
iwl_title: Wikidata:Main_page
2 rows in set (0.00 sec)
-Jeremy
_______________________________________________
Commons-l mailing list
Commons-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/commons-l