Whoops, looks like something went wrong.

(2/2) QueryException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'orders_count' in 'order clause' (SQL: select `offer_languages`.*, `offer_languages`.`id` as `offer_language_id`, `offers`.*, `companies`.`id` as `company_id`, `companies`.`slug` as `company_slug`, `companies`.`logo` as `company_logo`, `companies`.`district` as `district`, `companies`.`ident_code`, `company_languages`.`title` as `company_title`, `company_languages`.`legal_name` as `company_legal_name`, (select `voucher_price` from `offer_vouchers` where `offers`.`id` = `offer_vouchers`.`offer_id` order by `voucher_price` asc limit 1) as `voucher_price`, (select round(old_price - (offers.price + if(is_voucher, ifnull(voucher_price, 0), 0)), 2) + '0') as `savings_price`, (select round((old_price - offers.price) / old_price * 100)) as `savings_perc` from `offers` left join `offer_languages` on `offers`.`id` = `offer_languages`.`offer_id` and `offer_languages`.`language` = ka left join `companies` on `offers`.`company_id` = `companies`.`id` left join `company_languages` on (`companies`.`id` = `company_languages`.`company_id` and `company_languages`.`language` = ka) where `offers`.`visible` = 1 and `offers`.`is_corporate` = 0 and (`coming_soon` = 1 or publish_date > str_to_date(now(), '%Y-%m-%d %H:%i:%s')) and `companies`.`visible` = 1 order by `orders_count` desc limit 30 offset 0)

in Connection.php line 647
at Connection->runQueryCallback('select `offer_languages`.*, `offer_languages`.`id` as `offer_language_id`, `offers`.*, `companies`.`id` as `company_id`, `companies`.`slug` as `company_slug`, `companies`.`logo` as `company_logo`, `companies`.`district` as `district`, `companies`.`ident_code`, `company_languages`.`title` as `company_title`, `company_languages`.`legal_name` as `company_legal_name`, (select `voucher_price` from `offer_vouchers` where `offers`.`id` = `offer_vouchers`.`offer_id` order by `voucher_price` asc limit 1) as `voucher_price`, (select round(old_price - (offers.price + if(is_voucher, ifnull(voucher_price, 0), 0)), 2) + \'0\') as `savings_price`, (select round((old_price - offers.price) / old_price * 100)) as `savings_perc` from `offers` left join `offer_languages` on `offers`.`id` = `offer_languages`.`offer_id` and `offer_languages`.`language` = ? left join `companies` on `offers`.`company_id` = `companies`.`id` left join `company_languages` on (`companies`.`id` = `company_languages`.`company_id` and `company_languages`.`language` = ?) where `offers`.`visible` = ? and `offers`.`is_corporate` = ? and (`coming_soon` = ? or publish_date > str_to_date(now(), \'%Y-%m-%d %H:%i:%s\')) and `companies`.`visible` = ? order by `orders_count` desc limit 30 offset 0', array('ka', 'ka', 1, 0, 1, 1), object(Closure))in Connection.php line 607
at Connection->run('select `offer_languages`.*, `offer_languages`.`id` as `offer_language_id`, `offers`.*, `companies`.`id` as `company_id`, `companies`.`slug` as `company_slug`, `companies`.`logo` as `company_logo`, `companies`.`district` as `district`, `companies`.`ident_code`, `company_languages`.`title` as `company_title`, `company_languages`.`legal_name` as `company_legal_name`, (select `voucher_price` from `offer_vouchers` where `offers`.`id` = `offer_vouchers`.`offer_id` order by `voucher_price` asc limit 1) as `voucher_price`, (select round(old_price - (offers.price + if(is_voucher, ifnull(voucher_price, 0), 0)), 2) + \'0\') as `savings_price`, (select round((old_price - offers.price) / old_price * 100)) as `savings_perc` from `offers` left join `offer_languages` on `offers`.`id` = `offer_languages`.`offer_id` and `offer_languages`.`language` = ? left join `companies` on `offers`.`company_id` = `companies`.`id` left join `company_languages` on (`companies`.`id` = `company_languages`.`company_id` and `company_languages`.`language` = ?) where `offers`.`visible` = ? and `offers`.`is_corporate` = ? and (`coming_soon` = ? or publish_date > str_to_date(now(), \'%Y-%m-%d %H:%i:%s\')) and `companies`.`visible` = ? order by `orders_count` desc limit 30 offset 0', array('ka', 'ka', 1, 0, 1, 1), object(Closure))in Connection.php line 326
at Connection->select('select `offer_languages`.*, `offer_languages`.`id` as `offer_language_id`, `offers`.*, `companies`.`id` as `company_id`, `companies`.`slug` as `company_slug`, `companies`.`logo` as `company_logo`, `companies`.`district` as `district`, `companies`.`ident_code`, `company_languages`.`title` as `company_title`, `company_languages`.`legal_name` as `company_legal_name`, (select `voucher_price` from `offer_vouchers` where `offers`.`id` = `offer_vouchers`.`offer_id` order by `voucher_price` asc limit 1) as `voucher_price`, (select round(old_price - (offers.price + if(is_voucher, ifnull(voucher_price, 0), 0)), 2) + \'0\') as `savings_price`, (select round((old_price - offers.price) / old_price * 100)) as `savings_perc` from `offers` left join `offer_languages` on `offers`.`id` = `offer_languages`.`offer_id` and `offer_languages`.`language` = ? left join `companies` on `offers`.`company_id` = `companies`.`id` left join `company_languages` on (`companies`.`id` = `company_languages`.`company_id` and `company_languages`.`language` = ?) where `offers`.`visible` = ? and `offers`.`is_corporate` = ? and (`coming_soon` = ? or publish_date > str_to_date(now(), \'%Y-%m-%d %H:%i:%s\')) and `companies`.`visible` = ? order by `orders_count` desc limit 30 offset 0', array('ka', 'ka', 1, 0, 1, 1), true)in Builder.php line 1705
at Builder->runSelect()in Builder.php line 1690
at Builder->get(array('*'))in Builder.php line 462
at Builder->getModels(array('*'))in Builder.php line 446
at Builder->get(array('*'))in Builder.php line 183
at Builder->get(array('*'))in Builder.php line 690
at Builder->paginate(30, array('*'), 'page', 1)in Builder.php line 125
at Builder->paginate(30)in WebCategoriesController.php line 574
at WebCategoriesController->coming(object(Page), object(Request))
at call_user_func_array(array(object(WebCategoriesController), 'coming'), array('bind0' => object(Page), object(Request)))in Controller.php line 55
at Controller->callAction('coming', array('bind0' => object(Page), object(Request)))in ControllerDispatcher.php line 44
at ControllerDispatcher->dispatch(object(Route), object(WebCategoriesController), 'coming')in Route.php line 203
at Route->runController()in Route.php line 160
at Route->run()in Router.php line 572
at Router->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in WebMainData.php line 63
at WebMainData->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in SubstituteBindings.php line 41
at SubstituteBindings->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in VerifyCsrfToken.php line 65
at VerifyCsrfToken->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in StartSession.php line 64
at StartSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in EncryptCookies.php line 59
at EncryptCookies->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Router.php line 574
at Router->runRouteWithinStack(object(Route), object(Request))in Router.php line 533
at Router->dispatchToRoute(object(Request))in Router.php line 511
at Router->dispatch(object(Request))in Kernel.php line 176
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ValidatePostSize.php line 27
at ValidatePostSize->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in CheckForMaintenanceMode.php line 46
at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Kernel.php line 151
at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116
at Kernel->handle(object(Request))in index.php line 58

(1/2) PDOException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'orders_count' in 'order clause'

in Connection.php line 319
at PDO->prepare('select `offer_languages`.*, `offer_languages`.`id` as `offer_language_id`, `offers`.*, `companies`.`id` as `company_id`, `companies`.`slug` as `company_slug`, `companies`.`logo` as `company_logo`, `companies`.`district` as `district`, `companies`.`ident_code`, `company_languages`.`title` as `company_title`, `company_languages`.`legal_name` as `company_legal_name`, (select `voucher_price` from `offer_vouchers` where `offers`.`id` = `offer_vouchers`.`offer_id` order by `voucher_price` asc limit 1) as `voucher_price`, (select round(old_price - (offers.price + if(is_voucher, ifnull(voucher_price, 0), 0)), 2) + \'0\') as `savings_price`, (select round((old_price - offers.price) / old_price * 100)) as `savings_perc` from `offers` left join `offer_languages` on `offers`.`id` = `offer_languages`.`offer_id` and `offer_languages`.`language` = ? left join `companies` on `offers`.`company_id` = `companies`.`id` left join `company_languages` on (`companies`.`id` = `company_languages`.`company_id` and `company_languages`.`language` = ?) where `offers`.`visible` = ? and `offers`.`is_corporate` = ? and (`coming_soon` = ? or publish_date > str_to_date(now(), \'%Y-%m-%d %H:%i:%s\')) and `companies`.`visible` = ? order by `orders_count` desc limit 30 offset 0')in Connection.php line 319
at Connection->Illuminate\Database\{closure}('select `offer_languages`.*, `offer_languages`.`id` as `offer_language_id`, `offers`.*, `companies`.`id` as `company_id`, `companies`.`slug` as `company_slug`, `companies`.`logo` as `company_logo`, `companies`.`district` as `district`, `companies`.`ident_code`, `company_languages`.`title` as `company_title`, `company_languages`.`legal_name` as `company_legal_name`, (select `voucher_price` from `offer_vouchers` where `offers`.`id` = `offer_vouchers`.`offer_id` order by `voucher_price` asc limit 1) as `voucher_price`, (select round(old_price - (offers.price + if(is_voucher, ifnull(voucher_price, 0), 0)), 2) + \'0\') as `savings_price`, (select round((old_price - offers.price) / old_price * 100)) as `savings_perc` from `offers` left join `offer_languages` on `offers`.`id` = `offer_languages`.`offer_id` and `offer_languages`.`language` = ? left join `companies` on `offers`.`company_id` = `companies`.`id` left join `company_languages` on (`companies`.`id` = `company_languages`.`company_id` and `company_languages`.`language` = ?) where `offers`.`visible` = ? and `offers`.`is_corporate` = ? and (`coming_soon` = ? or publish_date > str_to_date(now(), \'%Y-%m-%d %H:%i:%s\')) and `companies`.`visible` = ? order by `orders_count` desc limit 30 offset 0', array('ka', 'ka', 1, 0, 1, 1))in Connection.php line 640
at Connection->runQueryCallback('select `offer_languages`.*, `offer_languages`.`id` as `offer_language_id`, `offers`.*, `companies`.`id` as `company_id`, `companies`.`slug` as `company_slug`, `companies`.`logo` as `company_logo`, `companies`.`district` as `district`, `companies`.`ident_code`, `company_languages`.`title` as `company_title`, `company_languages`.`legal_name` as `company_legal_name`, (select `voucher_price` from `offer_vouchers` where `offers`.`id` = `offer_vouchers`.`offer_id` order by `voucher_price` asc limit 1) as `voucher_price`, (select round(old_price - (offers.price + if(is_voucher, ifnull(voucher_price, 0), 0)), 2) + \'0\') as `savings_price`, (select round((old_price - offers.price) / old_price * 100)) as `savings_perc` from `offers` left join `offer_languages` on `offers`.`id` = `offer_languages`.`offer_id` and `offer_languages`.`language` = ? left join `companies` on `offers`.`company_id` = `companies`.`id` left join `company_languages` on (`companies`.`id` = `company_languages`.`company_id` and `company_languages`.`language` = ?) where `offers`.`visible` = ? and `offers`.`is_corporate` = ? and (`coming_soon` = ? or publish_date > str_to_date(now(), \'%Y-%m-%d %H:%i:%s\')) and `companies`.`visible` = ? order by `orders_count` desc limit 30 offset 0', array('ka', 'ka', 1, 0, 1, 1), object(Closure))in Connection.php line 607
at Connection->run('select `offer_languages`.*, `offer_languages`.`id` as `offer_language_id`, `offers`.*, `companies`.`id` as `company_id`, `companies`.`slug` as `company_slug`, `companies`.`logo` as `company_logo`, `companies`.`district` as `district`, `companies`.`ident_code`, `company_languages`.`title` as `company_title`, `company_languages`.`legal_name` as `company_legal_name`, (select `voucher_price` from `offer_vouchers` where `offers`.`id` = `offer_vouchers`.`offer_id` order by `voucher_price` asc limit 1) as `voucher_price`, (select round(old_price - (offers.price + if(is_voucher, ifnull(voucher_price, 0), 0)), 2) + \'0\') as `savings_price`, (select round((old_price - offers.price) / old_price * 100)) as `savings_perc` from `offers` left join `offer_languages` on `offers`.`id` = `offer_languages`.`offer_id` and `offer_languages`.`language` = ? left join `companies` on `offers`.`company_id` = `companies`.`id` left join `company_languages` on (`companies`.`id` = `company_languages`.`company_id` and `company_languages`.`language` = ?) where `offers`.`visible` = ? and `offers`.`is_corporate` = ? and (`coming_soon` = ? or publish_date > str_to_date(now(), \'%Y-%m-%d %H:%i:%s\')) and `companies`.`visible` = ? order by `orders_count` desc limit 30 offset 0', array('ka', 'ka', 1, 0, 1, 1), object(Closure))in Connection.php line 326
at Connection->select('select `offer_languages`.*, `offer_languages`.`id` as `offer_language_id`, `offers`.*, `companies`.`id` as `company_id`, `companies`.`slug` as `company_slug`, `companies`.`logo` as `company_logo`, `companies`.`district` as `district`, `companies`.`ident_code`, `company_languages`.`title` as `company_title`, `company_languages`.`legal_name` as `company_legal_name`, (select `voucher_price` from `offer_vouchers` where `offers`.`id` = `offer_vouchers`.`offer_id` order by `voucher_price` asc limit 1) as `voucher_price`, (select round(old_price - (offers.price + if(is_voucher, ifnull(voucher_price, 0), 0)), 2) + \'0\') as `savings_price`, (select round((old_price - offers.price) / old_price * 100)) as `savings_perc` from `offers` left join `offer_languages` on `offers`.`id` = `offer_languages`.`offer_id` and `offer_languages`.`language` = ? left join `companies` on `offers`.`company_id` = `companies`.`id` left join `company_languages` on (`companies`.`id` = `company_languages`.`company_id` and `company_languages`.`language` = ?) where `offers`.`visible` = ? and `offers`.`is_corporate` = ? and (`coming_soon` = ? or publish_date > str_to_date(now(), \'%Y-%m-%d %H:%i:%s\')) and `companies`.`visible` = ? order by `orders_count` desc limit 30 offset 0', array('ka', 'ka', 1, 0, 1, 1), true)in Builder.php line 1705
at Builder->runSelect()in Builder.php line 1690
at Builder->get(array('*'))in Builder.php line 462
at Builder->getModels(array('*'))in Builder.php line 446
at Builder->get(array('*'))in Builder.php line 183
at Builder->get(array('*'))in Builder.php line 690
at Builder->paginate(30, array('*'), 'page', 1)in Builder.php line 125
at Builder->paginate(30)in WebCategoriesController.php line 574
at WebCategoriesController->coming(object(Page), object(Request))
at call_user_func_array(array(object(WebCategoriesController), 'coming'), array('bind0' => object(Page), object(Request)))in Controller.php line 55
at Controller->callAction('coming', array('bind0' => object(Page), object(Request)))in ControllerDispatcher.php line 44
at ControllerDispatcher->dispatch(object(Route), object(WebCategoriesController), 'coming')in Route.php line 203
at Route->runController()in Route.php line 160
at Route->run()in Router.php line 572
at Router->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in WebMainData.php line 63
at WebMainData->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in SubstituteBindings.php line 41
at SubstituteBindings->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in VerifyCsrfToken.php line 65
at VerifyCsrfToken->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in StartSession.php line 64
at StartSession->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in EncryptCookies.php line 59
at EncryptCookies->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Router.php line 574
at Router->runRouteWithinStack(object(Route), object(Request))in Router.php line 533
at Router->dispatchToRoute(object(Request))in Router.php line 511
at Router->dispatch(object(Request))in Kernel.php line 176
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))in Pipeline.php line 30
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in TransformsRequest.php line 30
at TransformsRequest->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in ValidatePostSize.php line 27
at ValidatePostSize->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in CheckForMaintenanceMode.php line 46
at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 148
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request))in Pipeline.php line 102
at Pipeline->then(object(Closure))in Kernel.php line 151
at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116
at Kernel->handle(object(Request))in index.php line 58