$result_data = SQL_QUERY_ESC("SELECT
s.`id`,
s.`subject`,
- p.`text`,
+ `p`.`text`,
s.`timestamp_ordered` AS `timestamp`,
s.`cat_id`,
pay.`price` AS `points`,
- p.`sender`,
+ `p`.`sender`,
pay.`time`,
- p.`data_type`
+ `p`.`data_type`
FROM
`{?_MYSQL_PREFIX?}_user_stats` AS `s`
LEFT JOIN
LEFT JOIN
`{?_MYSQL_PREFIX?}_payments` AS `pay`
ON
- p.`payment_id`=pay.`id`
+ `p`.`payment_id`=pay.`id`
WHERE
s.`id`=%s
LIMIT 1",
s.`timestamp_ordered` AS `timestamp`,
s.`cat_id`,
s.`payment_id`,
- p.`sender`
+ `p`.`sender`
FROM
`{?_MYSQL_PREFIX?}_user_stats` AS `s`
LEFT JOIN
`{?_MYSQL_PREFIX?}_pool` AS `p`
ON
- s.`pool_id`=p.`id`
+ s.`pool_id`=`p`.`id`
WHERE
s.`id`=%s
LIMIT 1",