Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.TOTAL_RANKING' in 'field list'
The SQL being executed was: SELECT abp.C_A_P_ID as id, acsp.SCHOOL_PROJECT_NAME as title, acsp.degreetype, acsp.fullname, abp.schoollen, acsp.PROFESSION_RANKING as usnewsranking,u.TOTAL_RANKING as university_total_ranking from COUNTRY_ABROAD_PROJECT as abp LEFT JOIN ABROAD_COLLEGE_SCHOOL_PROJECT as acsp ON abp.PK_A_C_S_P_ID = acsp.A_C_S_P_ID WHERE acsp.PK_COUNTRY_ID in ( SELECT PK_COUNTRY from university WHERE URLCODE = 'iu' ) and acsp.PK_MAJORID in ( SELECT PK_MAJOR from major_union WHERE URLCODE = 'computer' ) AND abp.C_A_P_ID not in ('.5842,5837.') AND acsp.PROFESSION_RANKING between 42 and 62 ORDER BY acsp.PROFESSION_RANKING desc LIMIT 10

Error Info: Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'u.TOTAL_RANKING' in 'field list'
)
$_GET = [
    'ename' => 'iu',
    'major_urlcode' => 'computer',
];

$_SESSION = [
    '__flash' => [],
];