[Bug 23847] Clean up table user_newtalk

https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 Umherirrender changed: What|Removed |Added Status|NEW |RESOLVED Resolution|

[Bug 23847] Clean up table user_newtalk

https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #16 from Umherirrender 2012-09-04 18:51:32 UTC --- Please add a status info. Thanks. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the as

[Bug 23847] Clean up table user_newtalk

https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #15 from Umherirrender 2012-08-27 19:25:07 UTC --- Please add a status info. Thanks. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the as

[Bug 23847] Clean up table user_newtalk

https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #14 from Umherirrender 2012-07-07 20:26:51 UTC --- Please add a status info. Thanks. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the as

[Bug 23847] Clean up table user_newtalk

https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #13 from Umherirrender 2012-04-14 19:23:37 UTC --- current(In reply to comment #12) > PAGE makes it unhappy means a sql error or a long query run time? Feel free to make the query better or split it in two queries (one for users a

[Bug 23847] Clean up table user_newtalk

https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #12 from Reedy 2011-09-16 12:52:59 UTC --- SELECT * FROM user_newtalk WHERE user_id IN ( SELECT n.user_id FROM ( user_newtalk n JOIN user u ON u.user_id = n.user_id ) LEFT JOIN page p ON u.user_name = p.page_title AND p.page_namesp

[Bug 23847] Clean up table user_newtalk

https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #11 from Reedy 2011-09-16 12:50:31 UTC --- Everywhere is now MySQL 5.1 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the

[Bug 23847] Clean up table user_newtalk

https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #10 from Reedy 2011-07-08 22:20:10 UTC --- (In reply to comment #7) > Special:Version says it's MySQL 5.1.46-facebook-r3489-log now ... and why is > it > Facebook? It's a facebook optimised version of MySQL There's still some clu

[Bug 23847] Clean up table user_newtalk

https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #9 from p858snake 2010-07-30 10:07:53 UTC --- bah i see it -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are

[Bug 23847] Clean up table user_newtalk

https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #8 from p858snake 2010-07-30 10:07:38 UTC --- (In reply to comment #7) > Special:Version says it's MySQL 5.1.46-facebook-r3489-log now ... and why is > it > Facebook? Which install are you looking at? -- Configure bugmail: https:

[Bug 23847] Clean up table user_newtalk

https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 Liangent changed: What|Removed |Added CC||liang...@gmail.com --- Comment #7 from Lian

[Bug 23847] Clean up table user_newtalk

https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #6 from Umherirrender 2010-07-30 09:44:31 UTC --- (In reply to comment #5) > Subqueries cannot be used in MySQL 4. Thanks for that informationen. Have anybody a better query? Each of the subquery should work stand alone. -- Co

[Bug 23847] Clean up table user_newtalk

https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 Roan Kattouw changed: What|Removed |Added CC||roan.katt...@gmail.com --- Comment #5 f

[Bug 23847] Clean up table user_newtalk

https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 Niklas Laxström changed: What|Removed |Added CC||niklas.laxst...@gmail.com