X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmonthly%2Fmonthly_beg.php;h=17a38d2a8b69c10cdb168d03ffc86421271c92b9;hp=6f659675d45b654bc05eb8c3e3c81c75777a2b8a;hb=c47144dd555bbab4acdf9085e4623900dedb0e7c;hpb=3db876e775c0651ffdf15234f5d5c7a4eae4033c diff --git a/inc/monthly/monthly_beg.php b/inc/monthly/monthly_beg.php index 6f659675d4..17a38d2a8b 100644 --- a/inc/monthly/monthly_beg.php +++ b/inc/monthly/monthly_beg.php @@ -70,7 +70,7 @@ if (($curr != getConfig('last_month')) && (getConfig('last_month') > 0) && (getC // SQL string to check for accounts $result_main = SQL_QUERY_ESC("SELECT userid, email, gender, surname, family, beg_points AS points FROM `{!_MYSQL_PREFIX!}_user_data` -WHERE status='CONFIRMED'".$whereStatement1." AND beg_points > 0 +WHERE `status`='CONFIRMED'".$whereStatement1." AND beg_points > 0 ORDER BY beg_points DESC, userid LIMIT %s", array($whereStatement2), __FILE__, __LINE__);