Reedy added a comment.
Done against a production mysql server
MariaDB [ukwiki]> select page_id, page_title, pp_propname, pp_value
-> from page
-> join page_props on page_id = pp_page
-> where page_title = 'Шипайло' and page_namespace=0;
+---------+----------------+----------------+------------+
| page_id | page_title | pp_propname | pp_value |
+---------+----------------+----------------+------------+
| 4157074 | Шипайло | disambiguation | |
| 4157074 | Шипайло | wikibase_item | Q106255766 |
+---------+----------------+----------------+------------+
2 rows in set (0.000 sec)
MariaDB [ukwiki]>
compared against labs
MariaDB [ukwiki_p]> select page_id, page_title, pp_propname, pp_value
->
-> from page
->
-> left join page_props on page_id = pp_page
->
-> where page_title = 'Шипайло';
+---------+----------------+----------------+------------+
| page_id | page_title | pp_propname | pp_value |
+---------+----------------+----------------+------------+
| 4157074 | Шипайло | disambiguation | |
| 4157074 | Шипайло | wikibase_item | Q106255766 |
+---------+----------------+----------------+------------+
2 rows in set (1.98 sec)
Possibly replag?
TASK DETAIL
https://phabricator.wikimedia.org/T295229
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Reedy
Cc: Reedy, RhinosF1, Majavah, Aklapper, Base, Kanzat, Invadibot, maantietaja,
Akuckartz, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer,
_jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331
_______________________________________________
Wikidata-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
