Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'format_id' in where clause is ambiguous (SQL: select `products`.*, `manufacturers`.`name` as `manufacturer_name` from `products` left join `manufacturers` on `manufacturers`.`id` = `products`.`manufacturer_id` left join `sample_pack_formats` on `sample_pack_formats`.`product_id` = `products`.`id` where `product_type` = 1 and `is_approved` = 1 and `format_id` = 1 and (`status` = 1 and `is_private` = 0 and `release_date` is null or `release_date` <= 2024-04-18 00:00:00) order by `created_at` desc limit 8) in file /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 678 #0 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(638): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(346): Illuminate\Database\Connection->run() #2 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2303): Illuminate\Database\Connection->select() #3 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2291): Illuminate\Database\Query\Builder->runSelect() #4 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2786): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2292): Illuminate\Database\Query\Builder->onceWithColumns() #6 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(549): Illuminate\Database\Query\Builder->get() #7 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(533): Illuminate\Database\Eloquent\Builder->getModels() #8 /var/www/vhosts/soundsspace.com/httpdocs/app/Http/Controllers/SamplePacksController.php(282): Illuminate\Database\Eloquent\Builder->get() #9 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\SamplePacksController->filterSamplePacks() #10 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction() #11 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(254): Illuminate\Routing\ControllerDispatcher->dispatch() #12 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Route.php(197): Illuminate\Routing\Route->runController() #13 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(692): Illuminate\Routing\Route->run() #14 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #15 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #16 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Routing\Middleware\SubstituteBindings->handle() #17 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #18 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle() #19 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #20 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\View\Middleware\ShareErrorsFromSession->handle() #21 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #22 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\Session\Middleware\StartSession->handleStatefulRequest() #23 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Session\Middleware\StartSession->handle() #24 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #25 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle() #26 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #27 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Cookie\Middleware\EncryptCookies->handle() #28 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #29 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(694): Illuminate\Pipeline\Pipeline->then() #30 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(669): Illuminate\Routing\Router->runRouteWithinStack() #31 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(635): Illuminate\Routing\Router->runRoute() #32 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\Routing\Router->dispatchToRoute() #33 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(166): Illuminate\Routing\Router->dispatch() #34 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #35 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #36 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #37 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #38 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #39 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #40 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #41 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(87): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #42 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle() #43 /var/www/vhosts/soundsspace.com/httpdocs/vendor/fruitcake/laravel-cors/src/HandleCors.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #44 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fruitcake\Cors\HandleCors->handle() #45 /var/www/vhosts/soundsspace.com/httpdocs/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #46 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fideloper\Proxy\TrustProxies->handle() #47 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #48 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(141): Illuminate\Pipeline\Pipeline->then() #49 /var/www/vhosts/soundsspace.com/httpdocs/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #50 /var/www/vhosts/soundsspace.com/httpdocs/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle() #51 {main}