Illuminate\Database\QueryException: 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 '' at line 1 (SQL: select `cl`.`name` as `clubname`, `t`.* from (select * from(select `cta`.*, @weight_rank := if(@weight = `weightCategory`,@weight_rank + 1, 1) as weight_rank, @weight := `weightCategory` from (select * from (select *, (CASE WHEN weight BETWEEN 34 and 38 THEN "-38" WHEN weight BETWEEN 39 and 42 THEN "-42" WHEN weight BETWEEN 43 and 46 THEN "-46" WHEN weight BETWEEN 47 and 50 THEN "-50" WHEN weight BETWEEN 51 and 55 THEN "-55" WHEN weight BETWEEN 56 and 60 THEN "-60" WHEN weight BETWEEN 61 and 66 THEN "-66" WHEN weight BETWEEN 0 and 28 THEN "28" WHEN weight BETWEEN 28.01 and 31 THEN "31" WHEN weight BETWEEN 31.01 and 34 THEN "34" WHEN weight BETWEEN 34 and 38 THEN "38" WHEN weight BETWEEN 39 and 42 THEN "42" WHEN weight BETWEEN 43 and 46 THEN "46" WHEN weight BETWEEN 47 and 50 THEN "50" WHEN weight BETWEEN 51 and 55 THEN "55" WHEN weight BETWEEN 56 and 60 THEN "60" WHEN weight BETWEEN 61 and 66 THEN "66" WHEN weight BETWEEN 66.01 and 73 THEN "73" WHEN weight BETWEEN 73 and 200 THEN "73+" END) as `weightCategory` FROM `sportsmen` where `geo_id` = 60) in file /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 669 #0 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback(Object(Illuminate\Database\Query\Expression), Array, Object(Closure)) #1 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run(Object(Illuminate\Database\Query\Expression), Array, Object(Closure)) #2 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(349): Illuminate\Database\Connection->select(Object(Illuminate\Database\Query\Expression)) #3 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Database\DatabaseManager->__call('select', Array) #4 /var/www/projects/judo-league.com/app/Http/Controllers/Rating/Sportsman.php(92): Illuminate\Support\Facades\Facade::__callStatic('select', Array) #5 /var/www/projects/judo-league.com/app/Http/Controllers/Rating/Sportsman.php(143): App\Http\Controllers\Rating\Sportsman->render(Array, '\xD0\xBF\xD0\xB5\xD1\x80\xD0\xBC\xD1\x81\xD0\xBA\xD0\xB8\xD0...', 1, Array) #6 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\Rating\Sportsman->renderRegion('\xD0\xBF\xD1\x84\xD0\xBE', '\xD0\xBF\xD0\xB5\xD1\x80\xD0\xBC\xD1\x81\xD0\xBA\xD0\xB8\xD0...') #7 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('renderRegion', Array) #8 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\Rating\Sportsman), 'renderRegion') #9 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\Routing\Route->runController() #10 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\Routing\Route->run() #11 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #12 /var/www/projects/judo-league.com/app/Http/Middleware/GetIP.php(54): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #13 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\GetIP->handle(Object(Illuminate\Http\Request), Object(Closure)) #14 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #15 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #16 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #17 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #18 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #19 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #20 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(56): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #22 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #23 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #24 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #25 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #26 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #28 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #29 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route)) #30 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #31 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #32 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #34 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #35 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #38 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #39 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #40 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #41 /var/www/projects/judo-league.com/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #44 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #45 /var/www/projects/judo-league.com/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #46 /var/www/projects/judo-league.com/public/index.php(55): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #47 {main}