Exception

Database Exceptionyii\db\Exception

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'row_number, @employer_id:=employer_id as row_employer_id, t.* from (SELECT `j...' at line 1
The SQL being executed was: SELECT count(*) FROM ( SELECT @row_number := IF(@employer_id = employer_id, @row_number + 1, 1) AS row_number, @employer_id:=employer_id as row_employer_id, t.* from (SELECT `job`.`slug` AS `job_slug`, `job`.`working_time`, `job`.`contact_id`, `job`.`number`, `job`.`expire_time`, `job`.`priority`, `job`.`urgent`, `job`.`update_time`, `job`.`salary`, `job`.`employer_id`, `job`.`status` AS `status`, `job`.`id` AS `id`, `job`.`title` AS `title`, `job`.`view_count` AS `view_count`, `employer`.`title` AS `employer_title`, `employer`.`vip`, `employer`.`vip_start_time`, `employer`.`vip_end_time`, `employer`.`slug` AS `employer_slug`, `employer`.`logo`, `employer`.`phone` FROM `job` INNER JOIN `employer` ON employer.id = job.employer_id INNER JOIN `job_city` ON job.id = job_city.job_id WHERE ((((`employer`.`status` = '1')) AND (`job_city`.`city_id` = 44)) AND (`job`.`expire_time` > 1710844642)) AND (`job`.`status` = '1') ORDER BY `employer`.`vip` DESC, `job`.`update_time` DESC LIMIT 1000000) t CROSS JOIN (SELECT @employer_id:=0, @row_number :=0) AS dummy) AS V WHERE row_number <= 5

Error Info: Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'row_number, @employer_id:=employer_id as row_employer_id, t.* from (SELECT `j...' at line 1
)
$_GET = [
    'slug' => 'tai-long-an',
    'k' => '44',
];