+ $result_bonus = SQL_QUERY("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`='N'
+ORDER BY
+ `timestamp` DESC", __FILE__, __LINE__);