Difference between revisions of "User:Justa"
| Line 6: | Line 6: | ||
|nickname=Justa | |nickname=Justa | ||
}} | }} | ||
| + | Just a postit-note for myself with info on mediawikidb | ||
| + | select user.user_id,user.user_name,user_email,user.user_email_authenticated from user where user_id not in (select distinct ipb_user from ipblocks); | ||
| + | or | ||
| + | select user.user_id,user.user_name,user_email,user.user_email_authenticated from user left join ipblocks on user.user_id = ipblocks.ipb_user where ipblocks.ipb_user IS NULL; | ||
| + | |||
| + | Gonna get you; fscking wiki-spammers | ||
Revision as of 16:48, 14 May 2012
| TechInc Member | |
|---|---|
| nickname | Dear Leader |
| Memberstatus | board |
| contact@sociallife.removethis.org | |
| Part of Projects | TableOfFire |
| Manages | HP Laserjet 4050TN |
Just a postit-note for myself with info on mediawikidb select user.user_id,user.user_name,user_email,user.user_email_authenticated from user where user_id not in (select distinct ipb_user from ipblocks); or select user.user_id,user.user_name,user_email,user.user_email_authenticated from user left join ipblocks on user.user_id = ipblocks.ipb_user where ipblocks.ipb_user IS NULL;
Gonna get you; fscking wiki-spammers
