我是WP\\u LIST\\u表的新手，正在处理其他人的代码。我有几个连接我的查询

SELECT *
FROM wp_o_students st
INNER JOIN wp_o_schools sc
ON st.school_id = sc.school_id
INNER JOIN wp_marks_list ml
ON st.student_id = ml.student_id
ORDER BY $orderby
LIMIT %d OFFSET %d

如何将这些列设置为可排序？

\'school_id\' => __(\'School ID\', \'olympiad\'),
\'student_id\' => __(\'Student ID\', \'olympiad\'),
\'test_code\' => __(\'Test Code\', \'olympiad\'),
\'division\' => __(\'Division\', \'olympiad\'),
\'class_highest\' => __(\'Class Highest\', \'olympiad\'),
\'cutoff_marks\' => __(\'Cutoff Marks\', \'olympiad\'),
\'scored_marks\' => __(\'Scored Marks\', \'olympiad\'),
\'marks\' => __(\'Marks\', \'olympiad\'));

如果我在列名之前加上别名，那就行不通了。它在表中不显示结果，并且为空。我错过了什么？

SELECT st.student_id
FROM wp_o_students st
INNER JOIN wp_o_schools sc
ON st.school_id = sc.school_id
INNER JOIN wp_marks_list ml
ON st.student_id = ml.student_id
ORDER BY $orderby
LIMIT %d OFFSET %d

\'student_id\' => __(\'Student ID\', \'olympiad\'),