Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[42S22]: Column not found: 1054 Unknown column '2C78' in 'where clause'
The SQL being executed was: SELECT COUNT(*) FROM (SELECT IF(sub_rotation.`order` IS NULL,1,0) AS `sorted`, `country`.`currency_id`, `restaurants`.`seo_url`, `restaurants`.`city`, `type_restaurant`.`name` AS `type_name`, `restaurants_time`.`from`, `restaurants_time`.`to`, `restaurants_lang`.`name`, `restaurants_lang`.`description`, `restaurants_lang`.`address`, `filters`.`name` AS `check`, `restaurants`.`lat`, `restaurants`.`lng`, `restaurants`.`restaurant_id`, `restaurants`.`img`, ( 6371 * acos( cos( radians('50.4501') )
* cos( radians( lat ) ) * cos( radians( lng ) - radians('30.5234') )
+ sin( radians('50.4501') ) * sin( radians( lat ) ) ) ) AS distance FROM `restaurants` INNER JOIN `restaurants_lang` ON `restaurants`.`restaurant_id` = `restaurants_lang`.`restaurant_id` INNER JOIN `restaurants_time` ON `restaurants`.`restaurant_id` = `restaurants_time`.`restaurant_id` LEFT JOIN `kitchen_in_restaurant` ON `restaurants`.`restaurant_id` = `kitchen_in_restaurant`.`restaurant_id` LEFT JOIN (SELECT `type`, `restaurant_id` AS `rest_id`, `data_id`, `order` FROM `rotation` WHERE ((`type`=3) AND (`data_id`=0)) AND (`date_update` >= 1708300800)) `sub_rotation` ON sub_rotation.rest_id=restaurants.restaurant_id INNER JOIN `type_restaurant` ON type_restaurant.type_id=restaurants.type INNER JOIN `filters` ON filters.filter_id=restaurants.avg_check INNER JOIN `country` ON country.country_id = restaurants.country_id WHERE restaurants.status=1 AND restaurants_lang.language_id=5 AND (restaurants.type=12) AND (kitchen_in_restaurant.kitchen_id=71%2C78) GROUP BY `restaurants`.`restaurant_id` HAVING (`distance` < 30) OR (distance is NULL)) `c`

Error Info: Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column '2C78' in 'where clause'
)
$_GET = [
    'city' => 'kyiv',
    'filters_type' => '12',
    'filters_kitchen' => '71%2C78',
];

$_SESSION = [
    '__flash' => [],
    '__returnUrl' => '/kyiv/restaurants?filters_type=12&filters_kitchen=71%252C78',
];