Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'product_offers' in 'SELECT' (SQL: select product_offers as main_name, COUNT(*) as total from `cabinets_table_view` where (`availability` = InStock or `jc_availability` = InStock) and (`selling_price` >= 100 or `selling_jc_price` >= 100) group by `product_offers`) in file /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 712 #0 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback() #1 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(359): Illuminate\Database\Connection->run() #2 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2413): Illuminate\Database\Connection->select() #3 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect() #4 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2401): Illuminate\Database\Query\Builder->onceWithColumns() #6 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/app/Http/Controllers/Api/ServiceController.php(1254): Illuminate\Database\Query\Builder->get() #7 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\Api\ServiceController->product_category_wise() #8 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction() #9 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(261): Illuminate\Routing\ControllerDispatcher->dispatch() #10 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController() #11 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(721): Illuminate\Routing\Route->run() #12 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #13 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #14 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Routing\Middleware\SubstituteBindings->handle() #15 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(127): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #16 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(58): Illuminate\Routing\Middleware\ThrottleRequests->handleRequest() #17 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Routing\Middleware\ThrottleRequests->handle() #18 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(127): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #19 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(93): Illuminate\Routing\Middleware\ThrottleRequests->handleRequest() #20 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(55): Illuminate\Routing\Middleware\ThrottleRequests->handleRequestUsingNamedLimiter() #21 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Routing\Middleware\ThrottleRequests->handle() #22 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #23 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(719): Illuminate\Pipeline\Pipeline->then() #24 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(698): Illuminate\Routing\Router->runRouteWithinStack() #25 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(662): Illuminate\Routing\Router->runRoute() #26 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(651): Illuminate\Routing\Router->dispatchToRoute() #27 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(167): Illuminate\Routing\Router->dispatch() #28 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #29 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #30 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #31 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle() #32 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #33 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #34 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\TrimStrings->handle() #35 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #36 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #37 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #38 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle() #39 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/fruitcake/laravel-cors/src/HandleCors.php(52): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #40 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fruitcake\Cors\HandleCors->handle() #41 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #42 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Http\Middleware\TrustProxies->handle() #43 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #44 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(142): Illuminate\Pipeline\Pipeline->then() #45 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(111): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #46 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/public/index.php(51): Illuminate\Foundation\Http\Kernel->handle() #47 /home/pcbyjc/domains/crm.pcbyjc.com/public_html/server.php(28): require_once('...') #48 {main}