Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[42S22]: Column not found: 1054 Unknown column '2C51' 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_de` AS `type_name`, `restaurants_time`.`from`, `restaurants_time`.`to`, `restaurants_lang`.`name`, `restaurants_lang`.`description`, `restaurants_lang`.`address`, `filters`.`name_de` AS `check`, `restaurants`.`lat`, `restaurants`.`lng`, `restaurants`.`restaurant_id`, `restaurants`.`img`, ( 6371 * acos( cos( radians('52.52000659999999') )
* cos( radians( lat ) ) * cos( radians( lng ) - radians('13.404954') )
+ sin( radians('52.52000659999999') ) * sin( radians( lat ) ) ) ) AS distance FROM `restaurants` LEFT JOIN `kitchen_in_restaurant` ON `restaurants`.`restaurant_id` = `kitchen_in_restaurant`.`restaurant_id` LEFT JOIN `restaurants_tags` ON `restaurants`.`restaurant_id` = `restaurants_tags`.`restaurant_id` LEFT JOIN `restaurants_lang` ON `restaurants`.`restaurant_id` = `restaurants_lang`.`restaurant_id` LEFT JOIN `restaurants_time` ON `restaurants`.`restaurant_id` = `restaurants_time`.`restaurant_id` LEFT JOIN (SELECT `type`, `restaurant_id` AS `rest_id`, `data_id`, `order` FROM `rotation` WHERE (rotation.type=6) 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 LEFT JOIN `kitchen` ON kitchen.kitchen_id=kitchen_in_restaurant.kitchen_id LEFT JOIN `tag` ON tag.tag_id=restaurants_tags.tag_id WHERE
(sub_rotation.type=6 OR sub_rotation.type IS NULL)
AND restaurants.status=1
AND restaurants.booking=1
AND restaurants_lang.language_id=6
AND restaurants_time.weekday=1 AND (restaurants.avg_check=244) AND (kitchen_in_restaurant.kitchen_id=40%2C51) GROUP BY `restaurants`.`restaurant_id` HAVING (`distance` < 30) OR (distance is NULL)) `c`

Error Info: Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column '2C51' in 'where clause'
)
$_GET = [
    'city' => 'berlin',
    'filters_kitchen' => '40%2C51',
    'filters_check' => '244',
];

$_SESSION = [
    '__flash' => [],
    '__returnUrl' => '/de/berlin/reserve?filters_kitchen=40%252C51&filters_check=244',
];