Just tried to sort one of my guilds Member Logs by 'Note'
This came up :
1054: Unknown column 'nisnull' in 'order clause'
SQL:
SELECT *, DATE_FORMAT( `update_time`, "%a %b %D, %l:%i %p" ) AS date, UNIX_TIMESTAMP(`update_time`) AS date_stamp FROM `roster_memberlog` AS members WHERE `guild_id` = "2"ORDER BY nisnull, `note` ASC, `date_stamp` DESC LIMIT 0,25;
File: lib\dbal\mysql.php
Line: 203
Link is My beta Roster
Happy Hunting