Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P9909
(An Untitled Masterwork)
Active
Public
Actions
Authored by
Addshore
on Dec 17 2019, 10:52 AM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F31478840: raw.txt
Dec 17 2019, 10:52 AM
2019-12-17 10:52:36 (UTC+0)
Subscribers
None
mysql:research@dbstore1005.eqiad.wmnet [wikidatawiki]> SELECT page_title, page_touched, page_latest
-> FROM page
-> WHERE
-> page_namespace = 120
-> AND page_title IN
-> (
-> SELECT DISTINCT CONCAT('P', wbpt_property_id) as page_title
-> 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 ORDER BY wbpt_property_id
-> );
+------------+----------------+-------------+
| page_title | page_touched | page_latest |
+------------+----------------+-------------+
| P1056 | 20191129145724 | 1064773150 |
| P1594 | 20191129190626 | 1065568046 |
| P163 | 20191121214532 | 1058300925 |
| P1705 | 20191207173511 | 1071412858 |
| P175 | 20191212142313 | 1074744961 |
| P1885 | 20191009114242 | 1028686032 |
| P1951 | 20191009121721 | 1028695995 |
| P2176 | 20191119021501 | 1055964683 |
| P225 | 20191114233538 | 1052979003 |
| P2358 | 20191120233900 | 1057473807 |
| P2359 | 20191123160524 | 1059551572 |
| P2561 | 20191201183913 | 1065635100 |
| P2579 | 20191108230034 | 1048591614 |
| P2634 | 20190811071714 | 994860742 |
| P2827 | 20191010082847 | 1029126137 |
| P287 | 20191006111657 | 1026877644 |
| P3113 | 20190705064019 | 974348872 |
| P361 | 20191215200353 | 1076850067 |
| P39 | 20191207092841 | 1071096118 |
| P4155 | 20191110170837 | 1049960531 |
| P4329 | 20191012155726 | 1030657166 |
| P433 | 20191129023440 | 1064983335 |
| P4552 | 20191002095835 | 1024403621 |
| P4970 | 20191120195022 | 1057300912 |
| P503 | 20190905092630 | 1008397981 |
| P512 | 20191203185439 | 1068951362 |
| P585 | 20191207211102 | 1071531587 |
| P634 | 20190924114821 | 1019152744 |
| P642 | 20191205055028 | 1069672182 |
| P812 | 20191015045139 | 1032247991 |
| P84 | 20191204125053 | 1069334093 |
| P86 | 20191205100535 | 1069752347 |
| P892 | 20191105093405 | 1045492164 |
| P951 | 20191214185524 | 1076121754 |
+------------+----------------+-------------+
34 rows in set (9 min 55.82 sec)
Event Timeline
Addshore
created this paste.
Dec 17 2019, 10:52 AM
2019-12-17 10:52:36 (UTC+0)
Addshore
mentioned this in
T237984: Some property labels are not displayed on Item pages
.
Log In to Comment