Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[42S22]: Column not found: 1054 Unknown column '2C35' 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_ua` AS `type_name`, `restaurants_time`.`from`, `restaurants_time`.`to`, `restaurants_lang`.`name`, `restaurants_lang`.`description`, `restaurants_lang`.`address`, `filters`.`name_ua` 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 `filters_to_restaurant` ON `restaurants`.`restaurant_id` = `filters_to_restaurant`.`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=3
AND restaurants_time.weekday=1 AND (restaurants.type=38) AND (filters_to_restaurant.filter_id=150) AND (kitchen_in_restaurant.kitchen_id=18%2C35%2C39%2C51) GROUP BY `restaurants`.`restaurant_id` HAVING (`distance` < 30) OR (distance is NULL)) `c`

Error Info: Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column '2C35' in 'where clause'
)
$_GET = [
    'city' => 'berlin',
    'filters_kitchen' => '18%2C35%2C39%2C51',
    'filters' => '150',
    'filters_type' => '38',
];

$_SESSION = [
    '__flash' => [],
    '__returnUrl' => '/ua/berlin/reserve?filters_kitchen=18%252C35%252C39%252C51&filters=150&filters_type=38',
];