Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous (SQL: select `device`.*, `device`.`title` as `device_title` from `device_stores` as `device` inner join `brands` on `brands`.`id` = `device`.`brand_id` inner join `color_relations` as `cr` on `cr`.`store_item_id` = `device`.`id` and `cr`.`type` = 'device' where (`brand_id` = 17 and `status` = 1) group by `device`.`id` order by `created_at` asc limit 20 offset 0) in file /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 712 #0 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback() #1 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\Database\Connection->run() #2 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2414): Illuminate\Database\Connection->select() #3 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect() #4 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns() #6 /home/safirhamrah/domains/safirparts.com/public_html/laravel/app/Http/Controllers/SellController.php(166): Illuminate\Database\Query\Builder->get() #7 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\SellController->sellDevice() #8 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction() #9 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(262): Illuminate\Routing\ControllerDispatcher->dispatch() #10 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController() #11 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(721): Illuminate\Routing\Route->run() #12 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #13 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/jetstream/src/Http/Middleware/ShareInertiaData.php(61): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #14 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Laravel\Jetstream\Http\Middleware\ShareInertiaData->handle() #15 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/inertiajs/inertia-laravel/src/Middleware.php(13): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #16 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Inertia\Middleware->handle() #17 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #18 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Routing\Middleware\SubstituteBindings->handle() #19 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #20 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle() #21 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #22 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\View\Middleware\ShareErrorsFromSession->handle() #23 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Session/Middleware/AuthenticateSession.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #24 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Session\Middleware\AuthenticateSession->handle() #25 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #26 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest() #27 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Session\Middleware\StartSession->handle() #28 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #29 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle() #30 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #31 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Cookie\Middleware\EncryptCookies->handle() #32 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #33 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(723): Illuminate\Pipeline\Pipeline->then() #34 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(698): Illuminate\Routing\Router->runRouteWithinStack() #35 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(662): Illuminate\Routing\Router->runRoute() #36 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(651): Illuminate\Routing\Router->dispatchToRoute() #37 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(167): Illuminate\Routing\Router->dispatch() #38 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #39 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/livewire/livewire/src/DisableBrowserCache.php(19): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #40 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Livewire\DisableBrowserCache->handle() #41 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #42 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #43 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle() #44 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #45 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #46 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\TrimStrings->handle() #47 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #48 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #49 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #50 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle() #51 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/fruitcake/laravel-cors/src/HandleCors.php(38): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #52 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fruitcake\Cors\HandleCors->handle() #53 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #54 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fideloper\Proxy\TrustProxies->handle() #55 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #56 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(142): Illuminate\Pipeline\Pipeline->then() #57 /home/safirhamrah/domains/safirparts.com/public_html/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(111): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #58 /home/safirhamrah/domains/safirparts.com/public_html/index.php(52): Illuminate\Foundation\Http\Kernel->handle() #59 {main}