Need query to remove subscriptions

[Farcaster]

Given you criteria, you could use this statement to delete the subscriptions for these users for MySQL v4.1+:

[SQL]DELETE sf FROM subscribeforum sf, user u WHERE u.userid = sf.userid AND u.email = CONVERT( _utf8 ' '
USING latin1 ) COLLATE latin1_swedish_ci;

DELETE se FROM subscribeevent se, user u WHERE u.userid = se.userid AND u.email = CONVERT( _utf8 ' '
USING latin1 ) COLLATE latin1_swedish_ci;

DELETE st FROM subscribethread st, user u WHERE u.userid = st.userid AND u.email = CONVERT( _utf8 ' '
USING latin1 ) COLLATE latin1_swedish_ci;[/SQL]