SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sale_price' in 'WHERE' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: eagledemo_newb2b, SQL: select count(*) as aggregate from `products` where `status` = 1 and `show_on_website` = 1 and `sale_price` between 1000 and 2000 and `products`.`deleted_at` is null)
Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))Illuminate\Database\Connection->run(string, array, object(Closure))Illuminate\Database\Connection->select(string, array, boolean)Illuminate\Database\Query\Builder->runSelect()Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()Illuminate\Database\Query\Builder->onceWithColumns(array, object(Closure))Illuminate\Database\Query\Builder->get()Illuminate\Database\Query\Builder->runPaginationCountQuery(array)Illuminate\Database\Query\Builder->getCountForPagination()Illuminate\Database\Eloquent\Builder->paginate(integer)649 break;
650 }
651 }
652
653
654 $products = $query->paginate(12)->withQueryString();
655
656 $footerCategories = Category::where('status', 1)
657 ->whereNull('parent_id')
658 ->orderBy('sort_order')
659 ->take(10)
660 ->get();
661
662 $footerOccasions = GiftingOccasion::where('status', 1)
663 ->orderBy('title')
664 ->get();
665
666App\Http\Controllers\FrontController->products(object(Illuminate\Http\Request))Illuminate\Routing\Controller->callAction(string, array)Illuminate\Routing\ControllerDispatcher->dispatch(object(Illuminate\Routing\Route), object(App\Http\Controllers\FrontController), string)Illuminate\Routing\Route->runController()Illuminate\Routing\Route->run()Illuminate\Routing\Router->Illuminate\Routing\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Routing\Middleware\SubstituteBindings->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\View\Middleware\ShareErrorsFromSession->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Session\Middleware\StartSession->handleStatefulRequest(object(Illuminate\Http\Request), object(Illuminate\Session\Store), object(Closure))Illuminate\Session\Middleware\StartSession->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Cookie\Middleware\EncryptCookies->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->then(object(Closure))Illuminate\Routing\Router->runRouteWithinStack(object(Illuminate\Routing\Route), object(Illuminate\Http\Request))Illuminate\Routing\Router->runRoute(object(Illuminate\Http\Request), object(Illuminate\Routing\Route))Illuminate\Routing\Router->dispatchToRoute(object(Illuminate\Http\Request))Illuminate\Routing\Router->dispatch(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Foundation\Http\Middleware\TrimStrings->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\ValidatePostSize->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\HandleCors->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\TrustProxies->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\InvokeDeferredCallbacks->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\ValidatePathEncoding->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->then(object(Closure))Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Kernel->handle(object(Illuminate\Http\Request))Illuminate\Foundation\Application->handleRequest(object(Illuminate\Http\Request))1718// Bootstrap Laravel and handle the request...19/** @var Application $app */20$app = require_once __DIR__.'/../bootstrap/app.php';2122$app->handleRequest(Request::capture());23select * from `sessions` where `id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` descselect count(*) as aggregate from `wishlists` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO'select * from `carts` where `session_id` = 'RxVvIMKUTzS1KJ0dVpV10m4EyC3mwpzxEMrNFYZO' limit 1select * from `dynamic_pages` where `status` = 1select * from `announcements` where `status` = 1 order by `created_at` desc{
"budget": "1000-2000"
}