Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sasas' in 'where clause' (Connection: mysql, SQL: select `a`.`id`, `a`.`app_name`, `a`.`app_icon`, MAX(am.description) as description, `a`.`created_date`, `c`.`agency_name` as `developer`, GROUP_CONCAT(apc.name) as categories, GROUP_CONCAT(as.name) as sdg, IFNULL(d.downloads, 0) as download, IFNULL(e.rate, 0) as noOfRates, IFNULL(f.rate, 0) as oneStar, IFNULL(g.rate, 0) as twoStar, IFNULL(h.rate, 0) as threeStar, IFNULL(i.rate, 0) as fourStar, IFNULL(j.rate, 0) as fiveStar, IFNULL(k.rate, 0) as rate from `app_info` as `a` left join `app_developer` as `c` on `c`.`id` = `a`.`app_developer_id` left join `app_info_category` as `ac` on `ac`.`app_info_id` = `a`.`id` left join `app_category` as `apc` on `ac`.`category_id` = `apc`.`id` left join `app_info_sdg` as `ai` on `ai`.`app_info_id` = `a`.`id` left join `app_sdg` as `as` on `ai`.`sdg_id` = `as`.`id` left join `app_metadata` as `am` on `am`.`app_info_id` = `a`.`id` left join `app_developer` as `b` on `b`.`id` = `a`.`app_developer_id` left join (SELECT app_info_id, sum(downloads) as downloads FROM app_current_version WHERE app_info_id = sasas GROUP BY app_info_id) as d on `d`.`app_info_id` = `a`.`id` left join (SELECT app_info_id, count(*) as rate FROM app_rating WHERE app_info_id = sasas AND star_level IS NOT NULL GROUP BY app_info_id) as e on `e`.`app_info_id` = `a`.`id` left join (SELECT app_info_id, count(*) as rate FROM app_rating WHERE app_info_id = sasas AND star_level = 1 GROUP BY app_info_id) as f on `f`.`app_info_id` = `a`.`id` left join (SELECT app_info_id, count(*) as rate FROM app_rating WHERE app_info_id = sasas AND star_level = 2 GROUP BY app_info_id) as g on `g`.`app_info_id` = `a`.`id` left join (SELECT app_info_id, count(*) as rate FROM app_rating WHERE app_info_id = sasas AND star_level = 3 GROUP BY app_info_id) as h on `h`.`app_info_id` = `a`.`id` left join (SELECT app_info_id, count(*) as rate FROM app_rating WHERE app_info_id = sasas AND star_level = 4 GROUP BY app_info_id) as i on `i`.`app_info_id` = `a`.`id` left join (SELECT app_info_id, count(*) as rate FROM app_rating WHERE app_info_id = sasas AND star_level = 5 GROUP BY app_info_id) as j on `j`.`app_info_id` = `a`.`id` left join (SELECT app_info_id, sum(star_level) / count(*) as rate FROM app_rating WHERE app_info_id = sasas AND star_level IS NOT NULL GROUP BY app_info_id) as k on `k`.`app_info_id` = `a`.`id` where a.id = sasas and a.status = 1 and a.publish_flag = 1 group by `a`.`id`, `a`.`app_name`, `a`.`app_icon` limit 1) in file /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 829 #0 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): Illuminate\Database\Connection->run() #2 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2751): Illuminate\Database\Connection->select() #3 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2740): Illuminate\Database\Query\Builder->runSelect() #4 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3294): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2739): Illuminate\Database\Query\Builder->onceWithColumns() #6 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(333): Illuminate\Database\Query\Builder->get() #7 /var/www/gamma-project/app/Models/AppInfo.php(199): Illuminate\Database\Query\Builder->first() #8 /var/www/gamma-project/app/Http/Controllers/HomeController.php(409): App\Models\AppInfo::getDetails() #9 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\HomeController->app_details() #10 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction() #11 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Routing/Route.php(259): Illuminate\Routing\ControllerDispatcher->dispatch() #12 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController() #13 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(806): Illuminate\Routing\Route->run() #14 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #15 /var/www/gamma-project/app/Http/Middleware/ForceHttps.php(25): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #16 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\ForceHttps->handle() #17 /var/www/gamma-project/app/Http/Middleware/Language.php(26): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #18 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\Language->handle() #19 /var/www/gamma-project/app/Http/Middleware/Localization.php(24): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #20 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): App\Http\Middleware\Localization->handle() #21 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #22 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Routing\Middleware\SubstituteBindings->handle() #23 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #24 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle() #25 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #26 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\View\Middleware\ShareErrorsFromSession->handle() #27 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #28 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest() #29 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Session\Middleware\StartSession->handle() #30 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #31 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle() #32 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #33 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Cookie\Middleware\EncryptCookies->handle() #34 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #35 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(805): Illuminate\Pipeline\Pipeline->then() #36 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(784): Illuminate\Routing\Router->runRouteWithinStack() #37 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(748): Illuminate\Routing\Router->runRoute() #38 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Routing/Router.php(737): Illuminate\Routing\Router->dispatchToRoute() #39 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch() #40 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #41 /var/www/gamma-project/vendor/livewire/livewire/src/Features/SupportDisablingBackButtonCache/DisableBackButtonCacheMiddleware.php(19): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #42 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Livewire\Features\SupportDisablingBackButtonCache\DisableBackButtonCacheMiddleware->handle() #43 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #44 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #45 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle() #46 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #47 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #48 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\TrimStrings->handle() #49 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #50 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #51 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(99): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #52 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle() #53 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #54 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\HandleCors->handle() #55 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #56 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\TrustProxies->handle() #57 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #58 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then() #59 /var/www/gamma-project/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #60 /var/www/gamma-project/public/index.php(51): Illuminate\Foundation\Http\Kernel->handle() #61 {main}