Page MenuHomePhabricator
Paste P9835

T239470 - Q10000002 - new tables before edit
ActivePublic
Actions

Authored by Addshore on Dec 9 2019, 10:34 AM.
Tags
None
Referenced Files
F31463613: raw.txt
Dec 9 2019, 10:34 AM
Subscribers
None
mysql:research@dbstore1005.eqiad.wmnet [wikidatawiki]> SELECT wbit_item_id as id, wby_name as type, wbxl_language as language, wbx_text as text, wbit_id, wbit_term_in_lang_id, wbtl_id FROM wbt_item_terms LEFT JOIN wbt_term_in_lang ON wbit_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 O N wbxl_text_id = wbx_id WHERE wbit_item_id = 10000002;
+----------+-------------+----------+------------------------------------------------------------+-----------+----------------------+-----------+
| id | type | language | text | wbit_id | wbit_term_in_lang_id | wbtl_id |
+----------+-------------+----------+------------------------------------------------------------+-----------+----------------------+-----------+
| 10000002 | label | sv | Kategori:Graphostroma | 184538013 | 82021746 | 82021746 |
| 10000002 | label | war | Kaarangay:Graphostroma | 184538014 | 82021747 | 82021747 |
| 10000002 | label | ceb | Kategoriya:Graphostroma | 184538015 | 82021748 | 82021748 |
| 10000002 | label | en | Category:Graphostroma | 184538016 | 82021749 | 82021749 |
| 10000002 | label | bg | Категория:Graphostroma | 184538017 | 82021750 | 82021750 |
| 10000002 | label | el | Κατηγορία:Graphostroma | 184538018 | 82021751 | 82021751 |
| 10000002 | NULL | NULL | NULL | 184538019 | 563002 | NULL |
| 10000002 | NULL | NULL | NULL | 184538020 | 563031 | NULL |
| 10000002 | NULL | NULL | NULL | 184538021 | 563003 | NULL |
| 10000002 | NULL | NULL | NULL | 184538022 | 574849 | NULL |
| 10000002 | NULL | NULL | NULL | 184538023 | 574850 | NULL |
| 10000002 | NULL | NULL | NULL | 184538024 | 574854 | NULL |
| 10000002 | NULL | NULL | NULL | 184538025 | 563004 | NULL |
| 10000002 | NULL | NULL | NULL | 184538026 | 574847 | NULL |
| 10000002 | NULL | NULL | NULL | 184538027 | 574852 | NULL |
| 10000002 | NULL | NULL | NULL | 184538028 | 563015 | NULL |
| 10000002 | NULL | NULL | NULL | 184538029 | 563030 | NULL |
| 10000002 | NULL | NULL | NULL | 184538030 | 574856 | NULL |
| 10000002 | NULL | NULL | NULL | 184538031 | 574851 | NULL |
| 10000002 | NULL | NULL | NULL | 184538032 | 563016 | NULL |
| 10000002 | NULL | NULL | NULL | 184538033 | 574857 | NULL |
| 10000002 | NULL | NULL | NULL | 184538034 | 235076 | NULL |
| 10000002 | NULL | NULL | NULL | 184538035 | 1633124 | NULL |
| 10000002 | NULL | NULL | NULL | 184538036 | 469337 | NULL |
| 10000002 | NULL | NULL | NULL | 184538037 | 563011 | NULL |
| 10000002 | NULL | NULL | NULL | 184538038 | 563017 | NULL |
| 10000002 | NULL | NULL | NULL | 184538039 | 563022 | NULL |
| 10000002 | NULL | NULL | NULL | 184538040 | 563006 | NULL |
| 10000002 | NULL | NULL | NULL | 184538041 | 563023 | NULL |
| 10000002 | NULL | NULL | NULL | 184538042 | 563024 | NULL |
| 10000002 | NULL | NULL | NULL | 184538043 | 689404 | NULL |
| 10000002 | NULL | NULL | NULL | 184538044 | 177464 | NULL |
| 10000002 | NULL | NULL | NULL | 184538045 | 563013 | NULL |
| 10000002 | NULL | NULL | NULL | 184538046 | 563029 | NULL |
| 10000002 | NULL | NULL | NULL | 184538047 | 563025 | NULL |
| 10000002 | NULL | NULL | NULL | 184538048 | 815734 | NULL |
| 10000002 | NULL | NULL | NULL | 184538049 | 574858 | NULL |
| 10000002 | NULL | NULL | NULL | 184538050 | 574859 | NULL |
| 10000002 | NULL | NULL | NULL | 184538051 | 574860 | NULL |
| 10000002 | NULL | NULL | NULL | 184538052 | 419856 | NULL |
| 10000002 | NULL | NULL | NULL | 184538053 | 563053 | NULL |
| 10000002 | NULL | NULL | NULL | 184538054 | 563045 | NULL |
| 10000002 | NULL | NULL | NULL | 184538055 | 563077 | NULL |
| 10000002 | NULL | NULL | NULL | 184538056 | 563064 | NULL |
| 10000002 | NULL | NULL | NULL | 184538057 | 574867 | NULL |
| 10000002 | NULL | NULL | NULL | 184538058 | 563042 | NULL |
| 10000002 | NULL | NULL | NULL | 184538059 | 563040 | NULL |
| 10000002 | NULL | NULL | NULL | 184538060 | 563060 | NULL |
| 10000002 | NULL | NULL | NULL | 184538061 | 563059 | NULL |
| 10000002 | NULL | NULL | NULL | 184538062 | 563081 | NULL |
| 10000002 | NULL | NULL | NULL | 184538063 | 563065 | NULL |
| 10000002 | NULL | NULL | NULL | 184538064 | 563071 | NULL |
| 10000002 | NULL | NULL | NULL | 184538065 | 810383 | NULL |
| 10000002 | NULL | NULL | NULL | 184538066 | 574866 | NULL |
| 10000002 | NULL | NULL | NULL | 184538067 | 563073 | NULL |
| 10000002 | NULL | NULL | NULL | 184538068 | 563061 | NULL |
| 10000002 | NULL | NULL | NULL | 184538069 | 574865 | NULL |
| 10000002 | NULL | NULL | NULL | 184538070 | 563044 | NULL |
| 10000002 | NULL | NULL | NULL | 184538071 | 810384 | NULL |
| 10000002 | NULL | NULL | NULL | 184538072 | 563043 | NULL |
| 10000002 | NULL | NULL | NULL | 184538073 | 574864 | NULL |
| 10000002 | NULL | NULL | NULL | 184538074 | 563041 | NULL |
| 10000002 | NULL | NULL | NULL | 184538075 | 563082 | NULL |
| 10000002 | NULL | NULL | NULL | 184538076 | 574861 | NULL |
| 10000002 | NULL | NULL | NULL | 184538077 | 563048 | NULL |
| 10000002 | NULL | NULL | NULL | 184538078 | 689401 | NULL |
| 10000002 | NULL | NULL | NULL | 184538079 | 563046 | NULL |
| 10000002 | NULL | NULL | NULL | 184538080 | 574862 | NULL |
| 10000002 | NULL | NULL | NULL | 184538081 | 563058 | NULL |
| 10000002 | NULL | NULL | NULL | 184538082 | 563078 | NULL |
| 10000002 | NULL | NULL | NULL | 184538083 | 563072 | NULL |
| 10000002 | NULL | NULL | NULL | 184538084 | 563056 | NULL |
| 10000002 | NULL | NULL | NULL | 184538085 | 563080 | NULL |
| 10000002 | NULL | NULL | NULL | 184538086 | 563057 | NULL |
| 10000002 | NULL | NULL | NULL | 184538087 | 563067 | NULL |
| 10000002 | NULL | NULL | NULL | 184538088 | 563066 | NULL |
| 10000002 | NULL | NULL | NULL | 184538089 | 563070 | NULL |
| 10000002 | NULL | NULL | NULL | 184538090 | 563068 | NULL |
| 10000002 | NULL | NULL | NULL | 184538091 | 574868 | NULL |
| 10000002 | NULL | NULL | NULL | 184538092 | 563079 | NULL |
| 10000002 | NULL | NULL | NULL | 184538093 | 563083 | NULL |
| 10000002 | NULL | NULL | NULL | 184538094 | 563055 | NULL |
| 10000002 | NULL | NULL | NULL | 184538095 | 563074 | NULL |
| 10000002 | NULL | NULL | NULL | 184538096 | 563063 | NULL |
| 10000002 | NULL | NULL | NULL | 184538097 | 563075 | NULL |
| 10000002 | NULL | NULL | NULL | 184538098 | 563084 | NULL |
| 10000002 | description | ta | விக்கிமீடியா பகுப்பு | 184538099 | 58246084 | 58246084 |
| 10000002 | NULL | NULL | NULL | 184538100 | 563085 | NULL |
| 10000002 | NULL | NULL | NULL | 184538101 | 563086 | NULL |
| 10000002 | NULL | NULL | NULL | 184538102 | 563087 | NULL |
| 10000002 | NULL | NULL | NULL | 184538103 | 563020 | NULL |
| 10000002 | NULL | NULL | NULL | 184538104 | 810385 | NULL |
| 10000002 | NULL | NULL | NULL | 184538105 | 563088 | NULL |
| 10000002 | NULL | NULL | NULL | 184538106 | 563089 | NULL |
| 10000002 | NULL | NULL | NULL | 184538107 | 563092 | NULL |
| 10000002 | NULL | NULL | NULL | 184538108 | 563090 | NULL |
| 10000002 | NULL | NULL | NULL | 184538109 | 563091 | NULL |
| 10000002 | NULL | NULL | NULL | 184538110 | 563100 | NULL |
| 10000002 | NULL | NULL | NULL | 184538111 | 563054 | NULL |
| 10000002 | NULL | NULL | NULL | 184538112 | 563110 | NULL |
| 10000002 | NULL | NULL | NULL | 184538113 | 563093 | NULL |
| 10000002 | NULL | NULL | NULL | 184538114 | 563076 | NULL |
| 10000002 | NULL | NULL | NULL | 184538115 | 563105 | NULL |
| 10000002 | NULL | NULL | NULL | 184538116 | 563094 | NULL |
| 10000002 | NULL | NULL | NULL | 184538117 | 563095 | NULL |
| 10000002 | NULL | NULL | NULL | 184538118 | 563124 | NULL |
| 10000002 | NULL | NULL | NULL | 184538119 | 563097 | NULL |
| 10000002 | NULL | NULL | NULL | 184538120 | 563111 | NULL |
| 10000002 | NULL | NULL | NULL | 184538121 | 563098 | NULL |
| 10000002 | NULL | NULL | NULL | 184538122 | 563099 | NULL |
| 10000002 | NULL | NULL | NULL | 184538123 | 563101 | NULL |
| 10000002 | NULL | NULL | NULL | 184538124 | 563102 | NULL |
| 10000002 | NULL | NULL | NULL | 184538125 | 810386 | NULL |
| 10000002 | NULL | NULL | NULL | 184538126 | 563103 | NULL |
| 10000002 | NULL | NULL | NULL | 184538127 | 563106 | NULL |
| 10000002 | NULL | NULL | NULL | 184538128 | 563107 | NULL |
| 10000002 | NULL | NULL | NULL | 184538129 | 563108 | NULL |
| 10000002 | NULL | NULL | NULL | 184538130 | 563109 | NULL |
| 10000002 | NULL | NULL | NULL | 184538131 | 563096 | NULL |
| 10000002 | NULL | NULL | NULL | 184538132 | 563112 | NULL |
| 10000002 | NULL | NULL | NULL | 184538133 | 563113 | NULL |
| 10000002 | NULL | NULL | NULL | 184538134 | 563114 | NULL |
| 10000002 | NULL | NULL | NULL | 184538135 | 563115 | NULL |
| 10000002 | NULL | NULL | NULL | 184538136 | 563116 | NULL |
| 10000002 | NULL | NULL | NULL | 184538137 | 563117 | NULL |
| 10000002 | NULL | NULL | NULL | 184538138 | 563118 | NULL |
| 10000002 | NULL | NULL | NULL | 184538139 | 563119 | NULL |
| 10000002 | NULL | NULL | NULL | 184538140 | 563120 | NULL |
| 10000002 | NULL | NULL | NULL | 184538141 | 563121 | NULL |
| 10000002 | NULL | NULL | NULL | 184538142 | 563069 | NULL |
| 10000002 | NULL | NULL | NULL | 184538143 | 810387 | NULL |
| 10000002 | NULL | NULL | NULL | 184538144 | 563122 | NULL |
| 10000002 | NULL | NULL | NULL | 184538145 | 563123 | NULL |
| 10000002 | NULL | NULL | NULL | 184538146 | 563125 | NULL |
| 10000002 | label | it | Categoria:Graphostroma | 986120960 | 211638657 | 211638657 |
+----------+-------------+----------+------------------------------------------------------------+-----------+----------------------+-----------+
135 rows in set (0.01 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