Page MenuHomePhabricator
Paste P9904

(An Untitled Masterwork)
ActivePublic
Actions

Authored by Addshore on Dec 17 2019, 10:28 AM.
Tags
None
Referenced Files
F31478805: raw.txt
Dec 17 2019, 10:28 AM
Subscribers
None
mysql:research@dbstore1005.eqiad.wmnet [wikidatawiki]> SELECT * FROM wbt_property_terms LEFT JOIN wbt_term_in_lang ON wbpt_term_in_lang_id = wbtl_id LEFT JOIN wbt_type ON wbtl_type_id = wby_id LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id LEFT JOIN wbt_text ON wbxl_text_id = wbx_id WHERE wby_name = 'label' AND wbx_text IS NULL;
+---------+------------------+----------------------+-----------+--------------+----------------------+--------+----------+-----------+---------------+--------------+--------+----------+
| wbpt_id | wbpt_property_id | wbpt_term_in_lang_id | wbtl_id | wbtl_type_id | wbtl_text_in_lang_id | wby_id | wby_name | wbxl_id | wbxl_language | wbxl_text_id | wbx_id | wbx_text |
+---------+------------------+----------------------+-----------+--------------+----------------------+--------+----------+-----------+---------------+--------------+--------+----------+
| 7310 | 39 | 7250 | 7250 | 1 | 7217 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 23272 | 163 | 23167 | 23167 | 1 | 23136 | 1 | label | 23136 | en-ca | 18965 | NULL | NULL |
| 41216 | 361 | 41012 | 41012 | 1 | 40906 | 1 | label | 40906 | hr | 33047 | NULL | NULL |
| 47558 | 433 | 47327 | 47327 | 1 | 47015 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 54952 | 503 | 54673 | 54673 | 1 | 54321 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 55705 | 512 | 55424 | 55424 | 1 | 55044 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 63754 | 585 | 63405 | 63405 | 1 | 62989 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 63756 | 585 | 63407 | 63407 | 1 | 62998 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 63764 | 585 | 63415 | 63415 | 1 | 63045 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 63772 | 585 | 63423 | 63423 | 1 | 63085 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 63781 | 585 | 63432 | 63432 | 1 | 63133 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 63822 | 585 | 63473 | 63473 | 1 | 63265 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 63838 | 585 | 63489 | 63489 | 1 | 63302 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 67488 | 634 | 67105 | 67105 | 1 | 66628 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 81124 | 812 | 80631 | 80631 | 1 | 80084 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 86812 | 892 | 86271 | 86271 | 1 | 85653 | 1 | label | 85653 | de | 70868 | NULL | NULL |
| 86824 | 892 | 86283 | 86283 | 1 | 85683 | 1 | label | 85683 | cs | 70868 | NULL | NULL |
| 86825 | 892 | 86284 | 86284 | 1 | 85684 | 1 | label | 85684 | sk | 70868 | NULL | NULL |
| 98968 | 1056 | 98340 | 98340 | 1 | 97635 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 147526 | 1885 | 146481 | 146481 | 1 | 145351 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 150695 | 1951 | 149613 | 149613 | 1 | 148450 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 150702 | 1951 | 149620 | 149620 | 1 | 148461 | 1 | label | 148461 | da | 124608 | NULL | NULL |
| 172500 | 2359 | 171169 | 171169 | 1 | 169780 | 1 | label | 169780 | fr | 143199 | NULL | NULL |
| 172504 | 2359 | 171173 | 171173 | 1 | 169792 | 1 | label | 169792 | es | 143199 | NULL | NULL |
| 172509 | 2359 | 171178 | 171178 | 1 | 169806 | 1 | label | 169806 | ca | 143199 | NULL | NULL |
| 172510 | 2359 | 171179 | 171179 | 1 | 169807 | 1 | label | 169807 | oc | 143199 | NULL | NULL |
| 181208 | 2561 | 179788 | 179788 | 1 | 124086 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 181212 | 2561 | 179792 | 179792 | 1 | 178324 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 181248 | 2561 | 179828 | 179828 | 1 | 74539 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 181264 | 2561 | 179844 | 179844 | 1 | 178402 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 192564 | 2827 | 190996 | 190996 | 1 | 189415 | 1 | label | 189415 | zh | 161167 | NULL | NULL |
| 205613 | 3113 | 203928 | 203928 | 1 | 202361 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 245529 | 4552 | 243592 | 243592 | 1 | 241664 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 254217 | 4970 | 252225 | 252225 | 1 | 250257 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 295901 | 2561 | 295271 | 295271 | 1 | 292821 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 300841 | 2579 | 50128097 | 50128097 | 1 | 49770990 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319220 | 2561 | 332201595 | 332201595 | 1 | 330328983 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319187 | 2176 | 341733873 | 341733873 | 1 | 332765554 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 318939 | 84 | 348294308 | 348294308 | 1 | 345801164 | 1 | label | 345801164 | en | 106828003 | NULL | NULL |
| 318940 | 84 | 348294309 | 348294309 | 1 | 345824366 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 318941 | 84 | 348294310 | 348294310 | 1 | 346361653 | 1 | label | 346361653 | en-ca | 106828003 | NULL | NULL |
| 318942 | 84 | 348294311 | 348294311 | 1 | 346361654 | 1 | label | 346361654 | en-gb | 106828003 | NULL | NULL |
| 319063 | 86 | 349343821 | 349343821 | 1 | 343316470 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319110 | 225 | 349346678 | 349346678 | 1 | 347292879 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319116 | 287 | 349348036 | 349348036 | 1 | 343106159 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319172 | 1594 | 349379594 | 349379594 | 1 | 347230538 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319195 | 2358 | 349402393 | 349402393 | 1 | 347468319 | 1 | label | 347468319 | gl | 104176965 | NULL | NULL |
| 319196 | 2359 | 349402394 | 349402394 | 1 | 347468324 | 1 | label | 347468324 | nl | 104959030 | NULL | NULL |
| 319216 | 2561 | 349407966 | 349407966 | 1 | 330357202 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319217 | 2561 | 349407967 | 349407967 | 1 | 340209005 | 1 | label | 340209005 | ur | 100463413 | NULL | NULL |
| 319218 | 2561 | 349407968 | 349407968 | 1 | 330357222 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319219 | 2561 | 349407969 | 349407969 | 1 | 330357224 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319227 | 2634 | 349409677 | 349409677 | 1 | 347475615 | 1 | label | 347475615 | sq | 99362282 | NULL | NULL |
| 319243 | 4155 | 349450026 | 349450026 | 1 | 347423893 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319246 | 4329 | 349455481 | 349455481 | 1 | 346872369 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319247 | 4329 | 349455482 | 349455482 | 1 | 327071361 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319248 | 4329 | 349455483 | 349455483 | 1 | 346872330 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319249 | 4329 | 349455484 | 349455484 | 1 | 346872333 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319250 | 4329 | 349455485 | 349455485 | 1 | 347521348 | 1 | label | 347521348 | it | 98825859 | NULL | NULL |
| 319251 | 4329 | 349455486 | 349455486 | 1 | 346872343 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319252 | 4329 | 349455487 | 349455487 | 1 | 346872347 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319253 | 4329 | 349455488 | 349455488 | 1 | 346872738 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319254 | 4329 | 349455489 | 349455489 | 1 | 337066227 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 319255 | 4329 | 349455490 | 349455490 | 1 | 346872735 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 320487 | 642 | 361461407 | 361461407 | 1 | 359474163 | 1 | label | 359474163 | nl | 110010309 | NULL | NULL |
| 320488 | 642 | 361461408 | 361461408 | 1 | 356961095 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 322349 | 1705 | 369802704 | 369802704 | 1 | 362223517 | 1 | label | NULL | NULL | NULL | NULL | NULL |
| 323788 | 175 | 379867083 | 379867083 | 1 | 377824335 | 1 | label | 377824335 | af | 117678367 | NULL | NULL |
| 324227 | 951 | 382690772 | 382690772 | 1 | 380630544 | 1 | label | 380630544 | en-gb | 119240100 | NULL | NULL |
+---------+------------------+----------------------+-----------+--------------+----------------------+--------+----------+-----------+---------------+--------------+--------+----------+
69 rows in set (11.74 sec)
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits