| 2 | SELECT "Event"."id" AS "Event__id", "Event"."mbp_item_id" AS "Event__mbp_item_id", "Event"."car_type_id" AS "Event__car_type_id", "Event"."dealer_id" AS "Event__dealer_id", "Event"."datefrom" AS "Event__datefrom", "Event"."dateto" AS "Event__dateto", "Event"."location" AS "Event__location", "Event"."note" AS "Event__note", "Event"."is_done" AS "Event__is_done", "Event"."created" AS "Event__created", "Event"."modified" AS "Event__modified", "Event"."revised" AS "Event__revised", "MbpItem"."id" AS "MbpItem__id", "MbpItem"."year" AS "MbpItem__year", "MbpItem"."dealer_id" AS "MbpItem__dealer_id", "MbpItem"."goal_q1" AS "MbpItem__goal_q1", "MbpItem"."goal_q2" AS "MbpItem__goal_q2", "MbpItem"."goal_q3" AS "MbpItem__goal_q3", "MbpItem"."goal_q4" AS "MbpItem__goal_q4", "MbpItem"."approved_q1" AS "MbpItem__approved_q1", "MbpItem"."approved_q2" AS "MbpItem__approved_q2", "MbpItem"."approved_q3" AS "MbpItem__approved_q3", "MbpItem"."approved_q4" AS "MbpItem__approved_q4", "MbpItem"."created" AS "MbpItem__created", "MbpItem"."modified" AS "MbpItem__modified", "MbpItem"."turnover_q1" AS "MbpItem__turnover_q1", "MbpItem"."turnover_q2" AS "MbpItem__turnover_q2", "MbpItem"."turnover_q3" AS "MbpItem__turnover_q3", "MbpItem"."turnover_q4" AS "MbpItem__turnover_q4", "MbpItem"."approved_support_q1" AS "MbpItem__approved_support_q1", "MbpItem"."approved_support_q2" AS "MbpItem__approved_support_q2", "MbpItem"."approved_support_q3" AS "MbpItem__approved_support_q3", "MbpItem"."approved_support_q4" AS "MbpItem__approved_support_q4", "MbpItem"."sold_q1" AS "MbpItem__sold_q1", "MbpItem"."sold_q2" AS "MbpItem__sold_q2", "MbpItem"."sold_q3" AS "MbpItem__sold_q3", "MbpItem"."sold_q4" AS "MbpItem__sold_q4", "MbpItem"."manual_rmr" AS "MbpItem__manual_rmr", "MbpItem"."manual_marketing_bonus" AS "MbpItem__manual_marketing_bonus", "MbpItem"."year_goal" AS "MbpItem__year_goal", "MbpItem"."budget" AS "MbpItem__budget", "MbpItem"."year_note" AS "MbpItem__year_note", "MbpItem"."hew_value_q1" AS "MbpItem__hew_value_q1", "MbpItem"."hew_value_q2" AS "MbpItem__hew_value_q2", "MbpItem"."hew_value_q3" AS "MbpItem__hew_value_q3", "MbpItem"."hew_value_q4" AS "MbpItem__hew_value_q4", "MbpItem"."dealer_type" AS "MbpItem__dealer_type", "MbpItem"."email_q1" AS "MbpItem__email_q1", "MbpItem"."email_q2" AS "MbpItem__email_q2", "MbpItem"."email_q3" AS "MbpItem__email_q3", "MbpItem"."email_q4" AS "MbpItem__email_q4", "MbpItem"."manual_rmp" AS "MbpItem__manual_rmp", "MbpItem"."marketing_plan_approved" AS "MbpItem__marketing_plan_approved", "MbpItem"."q1_approved" AS "MbpItem__q1_approved", "MbpItem"."q2_approved" AS "MbpItem__q2_approved", "MbpItem"."q3_approved" AS "MbpItem__q3_approved", "MbpItem"."q4_approved" AS "MbpItem__q4_approved", "MbpItem"."comment_approved" AS "MbpItem__comment_approved", "Dealer"."id" AS "Dealer__id", "Dealer"."name" AS "Dealer__name", "Dealer"."first_name" AS "Dealer__first_name", "Dealer"."surname" AS "Dealer__surname", "Dealer"."street" AS "Dealer__street", "Dealer"."city" AS "Dealer__city", "Dealer"."gps_lat" AS "Dealer__gps_lat", "Dealer"."gps_lon" AS "Dealer__gps_lon", "Dealer"."email" AS "Dealer__email", "Dealer"."login" AS "Dealer__login", "Dealer"."password" AS "Dealer__password", "Dealer"."is_active" AS "Dealer__is_active", "Dealer"."created" AS "Dealer__created", "Dealer"."modified" AS "Dealer__modified", "Dealer"."phone" AS "Dealer__phone", "Dealer"."is_importer" AS "Dealer__is_importer", "Dealer"."order_login" AS "Dealer__order_login", "Dealer"."order_password" AS "Dealer__order_password", "Dealer"."order_is_active" AS "Dealer__order_is_active", "Dealer"."accepted_disclaimer" AS "Dealer__accepted_disclaimer", "Dealer"."is_deleted" AS "Dealer__is_deleted", "Dealer"."salutation" AS "Dealer__salutation", "CarType"."id" AS "CarType__id", "CarType"."name" AS "CarType__name", "CarType"."created" AS "CarType__created", "CarType"."modified" AS "CarType__modified" FROM "public"."events" AS "Event" LEFT JOIN "public"."mbp_items" AS "MbpItem" ON ("Event"."mbp_item_id" = "MbpItem"."id") LEFT JOIN "public"."dealers" AS "Dealer" ON ("Event"."dealer_id" = "Dealer"."id") LEFT JOIN "public"."car_types" AS "CarType" ON ("Event"."car_type_id" = "CarType"."id") WHERE 1 = 1 ORDER BY "CarType"."name" ASC, "Dealer"."name" ASC, "Event"."datefrom" ASC | | 0 | 0 | 3 |