PGCon Banner
Interested in BSD? Try BSDCan the week before PGCon.

Home
Registration
Schedule
Sponsors
Call for papers
Papers
Committee
Contact Us

Google+ Google+
Facebook Facebook
Follow PGCon on Twitter Twitter

Social
BOFs
 New Topic  |  Go to Top  |  Go to Topic  |  Search  |  Log In   Previous Message  |  Next Message 
 How I delete the spammers...
Author: Dan (148.177.1.---)
Date:   15-03-12 12:35

delete from forums_auth where ID NOT IN
(
select FA.id
from forums_auth FA JOIN pgcon2007 F on (F.userid = FA.id)
Union
select FA.id
from forums_auth FA JOIN pgcon2008 F on (F.userid = FA.id)
Union
select FA.id
from forums_auth FA JOIN pgcon2009 F on (F.userid = FA.id)
Union
select FA.id
from forums_auth FA JOIN pgcon2010 F on (F.userid = FA.id)
Union
select FA.id
from forums_auth FA JOIN pgcon2011 F on (F.userid = FA.id)
Union
select FA.id
from forums_auth FA JOIN pgcon2012 F on (F.userid = FA.id)
);

 Reply To This Message  |  Forum List  |  Flat View   Newer Topic  |  Older Topic 

 Topics Author  Date
 How I delete the spammers...   new
Dan 15-03-12 12:35 


 Forum List  |  Need a Login? Register Here 
 User Login
 User Name:
 Password:
 Remember my login:
   
 Forgot Your Password?
Enter your email address or user name below and a new password will be sent to the email address associated with your profile.
Hotel + Travel
U of O Campus
About Ottawa
Maps
Forum

Help out!
News
Privacy
Harassment
PostgreSQL?

PGCon 2007
PGCon 2008
PGCon 2009
PGCon 2010
PGCon 2011
PGCon 2012
PGCon 2013
Copyright © 2007-2014 PGCon. All rights reserved.
Valid HTML, and CSS