- // 0 1 2 3 4 5 6 7 8 9 10 11 12
- $SQL2 = "SELECT id, subject, text, receivers, points, time, data_type, timestamp, url, cat_id, target_send, mails_sent, clicks
-FROM "._MYSQL_PREFIX."_bonus
-WHERE is_notify='Y'
-ORDER BY timestamp DESC";
+ $SQL2 = "SELECT
+ `id`, `subject`, `text`, `receivers`, `points`, `time`, `data_type`, `timestamp`, `url`, `cat_id`, `target_send`,
+ `mails_sent`, `clicks`, (`mails_sent` - `clicks`) AS `unconfirmed`
+FROM
+ `{?_MYSQL_PREFIX?}_bonus`
+WHERE
+ `is_notify`='Y'
+ORDER BY
+ `timestamp` DESC";