order by virker ikke helt
jeg har en query her:$sql = "SELECT track.*, SUM(user_top5.points) AS points, hitlist.last_week
FROM ($DB.eb_track track
LEFT JOIN $DB.eb_user_top5 user_top5 ON track.id=user_top5.track_id)
LEFT JOIN $DB.eb_hitlist hitlist ON track.id=hitlist.track_id
WHERE user_top5.time>$exceed_time
GROUP BY track.id
ORDER BY points DESC, hitlist.last_week";
ved ikke lige om man kan overskue meningen i det? men hvis points er ens skal den sortere efter last_week, men KUN hvis last_week er over 0