Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Integrity constraint violationyii\db\IntegrityException

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'url' in where clause is ambiguous
The SQL being executed was: SELECT a.usnewsranking, a.stunumber, a.tnumber, a.rate, a.proportion, a.deadline, b.CN_NAME title, b.description, b.EN_NAME ename, concat("https://oss.bailiedu.com/", f.F_MONGOID) thumb, b.urlcode, b.UNIVERSITY_ID id, b.ranktime FROM `yx_usauniv` AS a LEFT JOIN university AS b ON b.UNIVERSITY_ID = a.PK_UNIVERSITY LEFT JOIN province AS P ON b.PK_PROVINCE = P.PROVINCE_ID LEFT JOIN province AS area ON area.PROVINCE_ID = P.PARENTID LEFT JOIN files f ON f.F_ID = b.THUMB_FILES WHERE b.url != "" AND b.ZLOGO != "" AND b.EN_NAME like "Q%" AND url!='' and 1 = 1 ORDER BY a.usnewsranking + 0 asc

Error Info: Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'url' in where clause is ambiguous
)
$_GET = [
    'keywords' => 'Q',
];

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