Interested in BSD? Try BSDCan
the week before PGCon.
|
|
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
|
|
|