More improved SQL queries

[mailer.git] / inc / autopurge / purge-unconfirmed.php

diff --git a/inc/autopurge/purge-unconfirmed.php b/inc/autopurge/purge-unconfirmed.php
index f834a18be52f063486b2f67a05e84ccb374949fb..c8e1c68f38bea4b8773a25d54be93fedff2cb2b4 100644 (file)
--- a/inc/autopurge/purge-unconfirmed.php
+++ b/inc/autopurge/purge-unconfirmed.php
@@ -49,7 +49,7 @@ if (getConfig('autopurge_unconfirmed') == "Y") {
        $time = bigintval(getConfig('ap_un_time'));
        $result_uncon = SQL_QUERY_ESC("SELECT userid, email, joined
 FROM `{!_MYSQL_PREFIX!}_user_data`
-WHERE status='UNCONFIRMED' AND joined < (UNIX_TIMESTAMP() - %s)
+WHERE `status`='UNCONFIRMED' AND joined < (UNIX_TIMESTAMP() - %s)
 ORDER BY userid ASC",
         array($time), __FILE__, __LINE__);
        if (SQL_NUMROWS($result_uncon) > 0) {