Просмотр поста

что то я с джойнами поссорился

$get_history = $this->db->query(
"SELECT `h`.`time`, `h`.`value`, `h`.`comment`, "
. "`u_f`.`nickname` AS `from`, `u_t`.`nickname` AS `to` "
. "FROM `module_balance_history` AS `h` "
. "LEFT JOIN `users` AS `u_t` ON `u_t`.`id` = `h`.`to`"
. "LEFT JOIN `users` AS `u_f` ON `u_f`.`id` = `h`.`from` "
. "WHERE `h`.`from` = '" . $this->user->id . "' OR `h`.`to` = '" . $this->user->id . "' "
. "ORDER BY `time` DESC "
. "LIMIT " . $limit['start'] . ", " . $limit['end']
);