Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[42S22]: Column not found: 1054 Unknown column '2C36' 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`, `restaurants`.`booking`, `bl`.`bs_id`, `filters`.`name_de` AS `check`, `type_restaurant`.`name_de` AS `type_name`, `restaurants`.`img`, `bl`.`text`, `restaurants`.`bl_time`, `restaurants_lang`.`name`, `restaurants_lang`.`address`, `restaurants`.`lat`, `restaurants`.`lng`, `restaurants`.`restaurant_id`, ( 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 `bl` LEFT JOIN `restaurants` ON `bl`.`restaurant_id` = `restaurants`.`restaurant_id` LEFT JOIN (SELECT `type`, `restaurant_id` AS `rest_id`, `data_id`, `order` FROM `rotation` WHERE (rotation.type=2) AND (`date_update` >= 1709078400)) `sub_rotation` ON sub_rotation.rest_id=bl.restaurant_id INNER JOIN `type_restaurant` ON type_restaurant.type_id=restaurants.type INNER JOIN `filters` ON filters.filter_id=restaurants.avg_check LEFT JOIN `country` ON country.country_id = restaurants.country_id INNER JOIN `restaurants_lang` ON restaurants.restaurant_id=restaurants_lang.restaurant_id LEFT JOIN `kitchen_in_restaurant` ON restaurants.restaurant_id=kitchen_in_restaurant.restaurant_id LEFT JOIN `kitchen` ON kitchen.kitchen_id=kitchen_in_restaurant.kitchen_id LEFT JOIN `restaurants_tags` ON restaurants_tags.restaurant_id=kitchen_in_restaurant.restaurant_id LEFT JOIN `tag` ON tag.tag_id=restaurants_tags.tag_id LEFT JOIN `filters_to_restaurant` ON filters_to_restaurant.restaurant_id=restaurants.restaurant_id WHERE ((filters_to_restaurant.filter_id=152) AND (kitchen_in_restaurant.kitchen_id=4%2C36)) AND (restaurants.status=1) AND (restaurants.bl=1) AND (restaurants_lang.language_id=6) AND (bl.period=0 AND bl.date="1711584000") AND ((sub_rotation.type=2) OR (sub_rotation.type IS NULL)) GROUP BY `bl`.`bs_id` HAVING (`distance` < 30) OR (distance is NULL)) `c`

Error Info: Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column '2C36' in 'where clause'
)
$_GET = [
    'city' => 'berlin',
    'filters_kitchen' => '4%2C36',
    'filters' => '152',
];

$_SESSION = [
    '__flash' => [],
    '__returnUrl' => '/de/berlin/lunches?filters_kitchen=4%252C36&filters=152',
];