ERROR
500
It's not you, it's me.
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lower_price%2Casc' in 'order clause' (SQL: select `cde_products`.*, (CASE WHEN cde_products.use_price_per_branch = 0 THEN cde_products.price ELSE (SELECT min(cde_warehouse_products.price) FROM cde_warehouse_products WHERE cde_warehouse_products.product_id = cde_products.id) END) as lower_price, (CASE WHEN (visible_from IS NULL AND visible_to IS NULL) THEN 1 WHEN (visible_from IS NOT NULL AND visible_to IS NULL) AND (visible_from <= CURDATE()) THEN 1 WHEN (visible_to IS NOT NULL AND visible_from IS NULL) AND (visible_to >= CURDATE()) THEN 1 WHEN (visible_from IS NOT NULL AND visible_to IS NOT NULL) AND (visible_from <= CURDATE() AND CURDATE() <= visible_to) THEN 1 ELSE 0 END) AS should_show from `cde_products` left join `cde_warehouse_products` on `cde_products`.`id` = `cde_warehouse_products`.`product_id` where `is_active` = 1 and `visible` = 1 and exists (select * from `cde_product_types` where `cde_products`.`product_type_id` = `cde_product_types`.`id` and (`slug` = AUTOMOVIL or `slug` = CAMIONES) and `cde_product_types`.`deleted_at` is null) and (exists (select * from `cde_product_attributes` where `cde_products`.`id` = `cde_product_attributes`.`product_id` and (((`attribute_id` = 9 and `value` = Camionetas)))) or exists (select * from `cde_product_variations` where `cde_products`.`id` = `cde_product_variations`.`product_id` and exists (select * from `cde_attributes` inner join `cde_product_attributes` on `cde_attributes`.`id` = `cde_product_attributes`.`attribute_id` where `cde_product_variations`.`id` = `cde_product_attributes`.`product_variation_id` and (((`attribute_id` = 9 and `value` = Camionetas))) and `cde_attributes`.`deleted_at` is null) and `cde_product_variations`.`deleted_at` is null and exists (select * from `tenants` inner join `tenantables` on `tenants`.`id` = `tenantables`.`tenant_id` where `cde_product_variations`.`id` = `tenantables`.`tenantable_id` and `tenantables`.`tenantable_type` = App\Models\CarDealer\CdeProductVariation and `id` = 4 and `is_active` = 1 and `tenants`.`deleted_at` is null))) and `cde_products`.`deleted_at` is null and exists (select * from `tenants` inner join `tenantables` on `tenants`.`id` = `tenantables`.`tenant_id` where `cde_products`.`id` = `tenantables`.`tenantable_id` and `tenantables`.`tenantable_type` = App\Models\CarDealer\CdeProduct and `id` = 4 and `is_active` = 1 and `tenants`.`deleted_at` is null) having `should_show` >= 1 order by `lower_price%2Casc` asc) (View: /home/754526.cloudwaysapps.com/dppgagkahj/public_html/resources/views/cardealer/partial_grid.blade.php)