Lucas_Werkmeister_WMDE added a comment.
Managed to find a pair of duplicates via the recent changes tagged as sitelink change from connected wiki <https://www.wikidata.org/wiki/Special:RecentChanges?hidepageedits=1&hidecategorization=1&hidelog=1&tagfilter=client-linkitem-change&limit=500&days=3&enhanced=1&urlversion=2> (the dewiki and ptwiki articles were clearly translations of one another, with a left parenthesis missing in the same place in both) and merged them <https://www.wikidata.org/w/index.php?title=Q112664122&diff=1665686076&oldid=1664718451> using the merge gadget. I was //not// able to reproduce the issue. name=before merge MariaDB [wikidatawiki]> SELECT wbit_item_id, wby_name, wbx_text, wbxl_language FROM wbt_item_terms JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id JOIN wbt_type ON wbtl_type_id = wby_id JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id JOIN wbt_text ON wbxl_text_id = wbx_id WHERE wbit_item_id IN (112664122, 112671429); +--------------+----------+----------+---------------+ | wbit_item_id | wby_name | wbx_text | wbxl_language | +--------------+----------+----------+---------------+ | 112664122 | label | Vyeyra | de | | 112671429 | label | Vyeyra | es | | 112671429 | label | Vyeyra | pt | +--------------+----------+----------+---------------+ 3 rows in set (0.005 sec) name=after merge MariaDB [wikidatawiki]> SELECT wbit_item_id, wby_name, wbx_text, wbxl_language FROM wbt_item_terms JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id JOIN wbt_type ON wbtl_type_id = wby_id JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id JOIN wbt_text ON wbxl_text_id = wbx_id WHERE wbit_item_id IN (112664122, 112671429); +--------------+----------+----------+---------------+ | wbit_item_id | wby_name | wbx_text | wbxl_language | +--------------+----------+----------+---------------+ | 112664122 | label | Vyeyra | de | | 112664122 | label | Vyeyra | es | | 112664122 | label | Vyeyra | pt | +--------------+----------+----------+---------------+ 3 rows in set (0.001 sec) TASK DETAIL https://phabricator.wikimedia.org/T309445 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Lucas_Werkmeister_WMDE Cc: karapayneWMDE, Addshore, Manuel, Lucas_Werkmeister_WMDE, Aklapper, Moebeus, Astuthiodit_1, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________ Wikidata-bugs mailing list -- [email protected] To unsubscribe send an email to [email protected]
