Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'film_viewed.all' in 'order clause' (SQL: select `film_posts`.* from `film_posts` inner join `film_viewed` on `film_posts`.`id` = `film_viewed`.`post_id` where exists (select * from `film_studios` inner join `film_post_studios` on `film_studios`.`id` = `film_post_studios`.`studio_id` where `film_posts`.`id` = `film_post_studios`.`film_post_id` and `studio_id` = 938) order by `film_viewed`.`all` desc limit 10 offset 0) in file /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 760 #0 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #1 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Database/Connection.php(422): Illuminate\Database\Connection->run() #2 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\Database\Connection->select() #3 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2694): Illuminate\Database\Query\Builder->runSelect() #4 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3230): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2695): Illuminate\Database\Query\Builder->onceWithColumns() #6 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(710): Illuminate\Database\Query\Builder->get() #7 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(694): Illuminate\Database\Eloquent\Builder->getModels() #8 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(899): Illuminate\Database\Eloquent\Builder->get() #9 /www/wwwroot/animevui.com/qanime/app/Http/Controllers/List/ListCatagoriesController.php(136): Illuminate\Database\Eloquent\Builder->paginate() #10 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(397): App\Http\Controllers\List\ListCatagoriesController->App\Http\Controllers\List\{closure}() #11 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php(408): Illuminate\Cache\Repository->remember() #12 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338): Illuminate\Cache\CacheManager->__call() #13 /www/wwwroot/animevui.com/qanime/app/Http/Controllers/List/ListCatagoriesController.php(137): Illuminate\Support\Facades\Facade::__callStatic() #14 /www/wwwroot/animevui.com/qanime/app/Http/Controllers/List/ListCatagoriesController.php(38): App\Http\Controllers\List\ListCatagoriesController->paginateAtr() #15 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\List\ListCatagoriesController->index() #16 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction() #17 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\Routing\ControllerDispatcher->dispatch() #18 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController() #19 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\Routing\Route->run() #20 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #21 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #22 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle() #23 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #24 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle() #25 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #26 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\View\Middleware\ShareErrorsFromSession->handle() #27 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #28 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest() #29 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Session\Middleware\StartSession->handle() #30 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #31 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle() #32 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #33 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\EncryptCookies->handle() #34 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #35 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\Pipeline\Pipeline->then() #36 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\Routing\Router->runRouteWithinStack() #37 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\Routing\Router->runRoute() #38 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\Routing\Router->dispatchToRoute() #39 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\Routing\Router->dispatch() #40 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #41 /www/wwwroot/animevui.com/qanime/app/Http/Middleware/RedirectNonWww.php(25): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #42 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\RedirectNonWww->handle() #43 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #44 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #45 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle() #46 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #47 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #48 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle() #49 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #50 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #51 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #52 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle() #53 /www/wwwroot/animevui.com/qanime/vendor/fruitcake/laravel-cors/src/HandleCors.php(38): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #54 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Fruitcake\Cors\HandleCors->handle() #55 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #56 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle() #57 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #58 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\Pipeline\Pipeline->then() #59 /www/wwwroot/animevui.com/qanime/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #60 /www/wwwroot/animevui.com/qanime/public/index.php(52): Illuminate\Foundation\Http\Kernel->handle() #61 {main}