sql query

gistfile1.sql

SQL (0.5ms)   SET SQL_AUTO_IS_NULL=0
  ReservationPricing Load Including Associations (3.6ms)   SELECT `reservation_pricings`.`id` AS t0_r0, `reservation_pricings`.`version` AS t0_r1, `reservation_pricings`.`reservation_pricing_stage` AS t0_r2, `reservation_pricings`.`pricing_type` AS t0_r3, `reservation_pricings`.`reservation_request_id` AS t0_r4, `reservation_pricings`.`min_hours` AS t0_r5, `reservation_pricings`.`rate_hours` AS t0_r6, `reservation_pricings`.`priced_base_hours` AS t0_r7, `reservation_pricings`.`priced_base_expanded` AS t0_r8, `reservation_pricings`.`priced_base_drive_time` AS t0_r9, `reservation_pricings`.`priced_extra_hours` AS t0_r10, `reservation_pricings`.`priced_extra_expanded` AS t0_r11, `reservation_pricings`.`priced_extra_drive_time` AS t0_r12, `reservation_pricings`.`base_rate` AS t0_r13, `reservation_pricings`.`extra_rate` AS t0_r14, `reservation_pricings`.`gratuity_pct` AS t0_r15, `reservation_pricings`.`service_fee_pct` AS t0_r16, `reservation_pricings`.`surcharge_pct` AS t0_r17, `reservation_pricings`.`tax_pct` AS t0_r18, `reservation_pricings`.`additional_hourly_fee` AS t0_r19, `reservation_pricings`.`additional_stops_fee` AS t0_r20, `reservation_pricings`.`number_of_stops` AS t0_r21, `reservation_pricings`.`wait_fee_per_hour` AS t0_r22, `reservation_pricings`.`wait_time_hours` AS t0_r23, `reservation_pricings`.`meet_inside_fee` AS t0_r24, `reservation_pricings`.`has_meet_inside` AS t0_r25, `reservation_pricings`.`base_amt` AS t0_r26, `reservation_pricings`.`extra_amt` AS t0_r27, `reservation_pricings`.`gratuity_amt` AS t0_r28, `reservation_pricings`.`service_fee_amt` AS t0_r29, `reservation_pricings`.`surcharge_amt` AS t0_r30, `reservation_pricings`.`additional_stops_amt` AS t0_r31, `reservation_pricings`.`meet_inside_amt` AS t0_r32, `reservation_pricings`.`wait_time_amt` AS t0_r33, `reservation_pricings`.`tax_amt` AS t0_r34, `reservation_pricings`.`additional_hourly_amt` AS t0_r35, `reservation_pricings`.`tolls_parking` AS t0_r36, `reservation_pricings`.`grand_total` AS t0_r37, `reservation_pricings`.`flat_fee` AS t0_r38, `reservation_pricings`.`commission_amt` AS t0_r39, `reservation_pricings`.`commission_pct` AS t0_r40, `reservation_pricings`.`tolls_amt` AS t0_r41, `reservation_pricings`.`parking_amt` AS t0_r42, `reservation_pricings`.`miscellaneous_amt` AS t0_r43, `reservation_pricings`.`service_discount_amt` AS t0_r44, `reservation_pricings`.`keepback_amt` AS t0_r45, `reservation_pricings`.`preauth_amt` AS t0_r46, `reservation_pricings`.`wait_authorized` AS t0_r47, `reservation_pricings`.`is_overridden` AS t0_r48, `reservation_pricings`.`original_penalty_amt` AS t0_r49, `reservation_pricings`.`overridden_grand_total` AS t0_r50, `reservation_pricings`.`overridden_commission_amt` AS t0_r51, `reservation_pricings`.`overridden_service_fee_amt` AS t0_r52, `reservation_pricings`.`overridden_keepback_amt` AS t0_r53, `reservation_pricings`.`debug_rate_id` AS t0_r54, `reservation_pricings`.`created_at` AS t0_r55, `reservation_pricings`.`reservation_closing_id` AS t0_r56, `reservation_pricings`.`private_service_fee_amt` AS t0_r57, `reservation_pricings`.`overridden_private_service_fee_amt` AS t0_r58, `reservation_pricings`.`private_cc_fee_pct` AS t0_r59, `reservation_pricings`.`private_cc_fee_amt` AS t0_r60, `reservation_pricings`.`overridden_private_cc_fee_amt` AS t0_r61, `reservation_pricings`.`promo_discount_flat_amt` AS t0_r62, `reservation_pricings`.`promo_discount_amt` AS t0_r63, `reservation_pricings`.`promo_discount_pct` AS t0_r64, `reservation_pricings`.`promo_code_id` AS t0_r65, `reservation_pricings`.`total_charges_amt` AS t0_r66, `reservation_pricings`.`total_discounts_amt` AS t0_r67, `reservation_requests`.`id` AS t1_r0, `reservation_requests`.`pickup_address_id` AS t1_r1, `reservation_requests`.`dropoff_address_id` AS t1_r2, `reservation_requests`.`package_vehicle_id` AS t1_r3, `reservation_requests`.`pickup_place_id` AS t1_r4, `reservation_requests`.`dropoff_place_id` AS t1_r5, `reservation_requests`.`user_id` AS t1_r6, `reservation_requests`.`dropoff_same_as_pickup` AS t1_r7, `reservation_requests`.`send_customer_copy` AS t1_r8, `reservation_requests`.`special_requests` AS t1_r9, `reservation_requests`.`destination_stops` AS t1_r10, `reservation_requests`.`flight_airline` AS t1_r11, `reservation_requests`.`flight_number` AS t1_r12, `reservation_requests`.`flight_terminal` AS t1_r13, `reservation_requests`.`cruise_carrier` AS t1_r14, `reservation_requests`.`cruise_ship` AS t1_r15, `reservation_requests`.`cruise_terminal` AS t1_r16, `reservation_requests`.`created_at` AS t1_r17, `reservation_requests`.`updated_at` AS t1_r18, `reservation_requests`.`uuid` AS t1_r19, `reservation_requests`.`search_result_id` AS t1_r20, `reservation_requests`.`reserved` AS t1_r21, `reservation_requests`.`operator_id` AS t1_r22, `reservation_requests`.`search_id` AS t1_r23, `reservation_requests`.`state` AS t1_r24, `reservation_requests`.`reservation_type` AS t1_r25, `reservation_requests`.`operator_confirmation_num` AS t1_r26, `reservation_requests`.`cancel_before_dt` AS t1_r27, `reservation_requests`.`cancel_fee_type` AS t1_r28, `reservation_requests`.`reminder_sent_at` AS t1_r29, `reservation_requests`.`ride_date` AS t1_r30, `reservation_requests`.`pickup_time` AS t1_r31, `reservation_requests`.`drop_off_time` AS t1_r32, `reservation_requests`.`pickup_place` AS t1_r33, `reservation_requests`.`drop_off_place` AS t1_r34, `reservation_requests`.`service_type` AS t1_r35, `reservation_requests`.`pax` AS t1_r36, `reservation_requests`.`vehicle_id` AS t1_r37, `reservation_requests`.`driver_id` AS t1_r38, `reservation_requests`.`accounting_id` AS t1_r39, `reservation_requests`.`ta_user_id` AS t1_r40, `reservation_requests`.`company_policy_exception_id` AS t1_r41, `reservation_requests`.`company_id` AS t1_r42, `reservation_requests`.`admin_user_id` AS t1_r43, `reservation_requests`.`pickup_date_time` AS t1_r44, `reservation_requests`.`know_before_you_go_sent_at` AS t1_r45, `reservation_requests`.`return_trip_id` AS t1_r46, `reservation_requests`.`parent_trip_id` AS t1_r47, `reservation_requests`.`tc_state` AS t1_r48, `reservation_requests`.`meet_inside` AS t1_r49, `reservation_requests`.`wait_authorized` AS t1_r50, `reservation_requests`.`replaced_by_id` AS t1_r51, `reservation_requests`.`replaces_id` AS t1_r52, `reservation_requests`.`current_reservation_pricing_id` AS t1_r53, `reservation_requests`.`close_expires_at` AS t1_r54, `reservation_requests`.`business_status` AS t1_r55, `reservation_requests`.`tp_locator` AS t1_r56, `reservation_requests`.`operator_cancellation_num` AS t1_r57, `reservation_requests`.`visit_id` AS t1_r58, `reservation_requests`.`booked_at` AS t1_r59, `reservation_requests`.`parent_id` AS t1_r60, `reservation_requests`.`honor_original_price` AS t1_r61, `reservation_requests`.`sms_status_bit` AS t1_r62, `reservation_requests`.`customer_driver_info_email_sent_at` AS t1_r63 FROM `reservation_pricings` LEFT OUTER JOIN `reservation_requests` ON `reservation_requests`.id = `reservation_pricings`.reservation_request_id WHERE (reservation_pricings.reservation_pricing_stage = 30 AND reservation_pricings.promo_code_id = 2 AND reservation_requests.parent_id IS NULL)