How to pass users pw through email?

[John Lester]

I'm getting a parse error when I have this code un-commented, I suspect it's the LEFT JOIN but then again what do I know

I'm trying to join the user table to pull the email column so the mod doesn't return the email error if there is no email column in the table.

    // If you selected to change existing thread subscriptions this code will be executed
    if ($vbulletin->options['advanced_unsubscribe_link_existing_thread_sub'])
       {
         // Sets existing thread subscriptions to through control panel only
         $db->query{"
                   UPDATE " .TABLE_PREFIX. "subscribethread
                   LEFT JOIN " .TABLE_PREFIX. "user AS user ON (user.email = user.userid)
                   SET emailupdate = 0
                   WHERE emailupdate IN (1,2,3)
                   AND userid = $id
                   AND email= '" . $db->escape_string($email) . "'");
       }