Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'main_rating' in 'order clause'
The SQL being executed was: SELECT `oceancompanyinformation`.*, `oceanactivitydetail`.`oceancompanyinformation_id` AS `activity_company_id`, `oceanactivitydetail`.`oceanactivities_id`, `oceanactivitydetail`.`id` AS `detail_id`, `oceanactivitydetail`.`what_island`, `oceanactivities`.`name` AS `name_of_activity`, `oceanactivitydetail`.`minimum_age`, `oceanactivitydetail`.`duration`, `oceanactivitydetail`.`adult`, `oceanactivitydetail`.`child`, `oceanactivitydetail`.`seniors`, `oceanactivitydetail`.`trip_summary`, `oceanactivitydetail`.`max_infant_age`, `oceanactivitydetail`.`infant`, `oceanactivitydetail`.`min_child_age`, `oceanactivitydetail`.`max_child_age`, `oceanactivitydetail`.`child` AS `child_rate`, `oceanactivitydetail`.`adult` AS `adult_rate`, `oceanactivitydetail`.`offer_private_charter`, `oceanactivitydetail`.`one_half_price`, `oceanactivitydetail`.`three_four_price`, `oceanactivitydetail`.`full_day_price`, `oceanactivitydetail`.`cancellation_policy`, `oceanactivitydetail`.`discount_available`, `oceanactivitydetail`.`include_in_trip`, `oceanactivitydetail`.`purchase_in_trip`, `oceanactivitydetail`.`name_of_trip`, `oceanactivitydetail`.`adult_retail_discount`, `oceanactivitydetail`.`is_top_rated`, `oceanactivitydetail`.`ride_along_rates`, `oceanactivitydetail`.`infant_retail_discount`, `oceanactivitydetail`.`ride_along_retail_discount`, `oceanactivitydetail`.`child_retail_discount`, `oceanactivitydetail`.`seniors_retail_discount`, `oceanactivitydetail`.`one_half_retail_discount`, `oceanactivitydetail`.`three_four_retail_discount`, `oceanactivitydetail`.`full_day_retail_discount`, `oceanactivitydetail`.`infant_commission_type`, `oceanactivitydetail`.`child_commission_type`, `oceanactivitydetail`.`adult_commission_type`, `oceanactivitydetail`.`seniors_commission_type`, `oceanactivitydetail`.`ride_along_commission_type`, `oceanactivitydetail`.`one_half_total_time`, `oceanactivitydetail`.`three_four_total_time`, `oceanactivitydetail`.`full_day_total_time`, `oceanactivitydetail`.`one_half_commission_type`, `oceanactivitydetail`.`three_four_commission_type`, `oceanactivitydetail`.`full_day_commission_type`, `oceanactivitydetail`.`free_cancellation`, `oceanactivitydetail`.`is_snorkeling_offered`, `oceanactivitydetail`.`scuba_options`, `oceanactivitydetail`.`adult_discount_type`, `oceanactivitydetail`.`infant_discount_type`, `oceanactivitydetail`.`child_discount_type`, `oceanactivitydetail`.`seniors_discount_type`, `oceanactivitydetail`.`ride_along_discount_type`, `oceanactivitydetail`.`one_half_discount_type`, `oceanactivitydetail`.`three_four_discount_type`, `oceanactivitydetail`.`full_day_discount_type`, `oceanactivitydetail`.`service_provider` FROM `oceanactivitydetail` JOIN `oceancompanyinformation` ON oceancompanyinformation.id = oceanactivitydetail.oceancompanyinformation_id JOIN `oceanactivities` ON oceanactivities.id = oceanactivitydetail.oceanactivities_id WHERE (`oceancompanyinformation`.`is_publish`=1) AND (`oceanactivitydetail`.`what_island`='kauai') ORDER BY `main_rating` DESC LIMIT 20

Error Info: Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'main_rating' in 'order clause'
)
$_GET = [
    'island' => 'kauai',
    'orderby' => 'review',
];