2
3.63 ms
SELECT c0_ . id AS id_0 , c0_ . contract_number AS contract_number_1 , c0_ . contract_date AS contract_date_2 , c0_ . contract_type AS contract_type_3 , c0_ . laycan_start AS laycan_start_4 , c0_ . laycan_end AS laycan_end_5 , c0_ . status AS status_6 , c0_ . freight_cost AS freight_cost_7 , c0_ . freight_cost_currency AS freight_cost_currency_8 , c0_ . freight_type AS freight_type_9 , c0_ . demurrage_per_day AS demurrage_per_day_10 , c0_ . demurrage_per_day_currency AS demurrage_per_day_currency_11 , c0_ . address_commission AS address_commission_12 , c0_ . brokerage_commission AS brokerage_commission_13 , c0_ . liftings_min AS liftings_min_14 , c0_ . liftings_max AS liftings_max_15 , c0_ . checklist_notes AS checklist_notes_16 , c0_ . demurrage_status AS demurrage_status_17 , c0_ . demurrage_time_bar AS demurrage_time_bar_18 , c0_ . demurrage_payment_date AS demurrage_payment_date_19 , c0_ . final_demurrage_cost AS final_demurrage_cost_20 , c0_ . final_demurrage_cost_currency AS final_demurrage_cost_currency_21 , c0_ . demurrage_paid_by_charterer AS demurrage_paid_by_charterer_22 , c0_ . demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_23 , c0_ . eta_arrival AS eta_arrival_24 , c0_ . delivered_arrival AS delivered_arrival_25 , c0_ . delivery_aprox_notice1 AS delivery_aprox_notice1_26 , c0_ . delivery_aprox_notice2 AS delivery_aprox_notice2_27 , c0_ . delivery_aprox_notice3 AS delivery_aprox_notice3_28 , c0_ . delivery_aprox_notice4 AS delivery_aprox_notice4_29 , c0_ . delivery_aprox_notice5 AS delivery_aprox_notice5_30 , c0_ . delivery_aprox_notice6 AS delivery_aprox_notice6_31 , c0_ . delivery_aprox_notice7 AS delivery_aprox_notice7_32 , c0_ . delivery_firm_notice1 AS delivery_firm_notice1_33 , c0_ . delivery_firm_notice2 AS delivery_firm_notice2_34 , c0_ . delivery_firm_notice3 AS delivery_firm_notice3_35 , c0_ . delivery_firm_notice4 AS delivery_firm_notice4_36 , c0_ . delivery_firm_notice5 AS delivery_firm_notice5_37 , c0_ . delivery_firm_notice6 AS delivery_firm_notice6_38 , c0_ . delivery_firm_notice7 AS delivery_firm_notice7_39 , c0_ . delivery_notices_not_aplicable AS delivery_notices_not_aplicable_40 , c0_ . ship_delivered AS ship_delivered_41 , c0_ . hire_per_day AS hire_per_day_42 , c0_ . hire_per_day_currency AS hire_per_day_currency_43 , c0_ . period AS period_44 , c0_ . report_description AS report_description_45 , c0_ . vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_46 , c0_ . vessel_was_substituted AS vessel_was_substituted_47 , c0_ . addendum_issued AS addendum_issued_48 , c0_ . addendum_description AS addendum_description_49 , c0_ . created_at AS created_at_50 , c0_ . updated_at AS updated_at_51 , v1_ . id AS id_52 , v1_ . vessel_name AS vessel_name_53 , v1_ . imo_number AS imo_number_54 , v1_ . vessel_type AS vessel_type_55 , v1_ . tanker_type AS tanker_type_56 , v1_ . bulker_type AS bulker_type_57 , v1_ . tank_coating AS tank_coating_58 , v1_ . dwt AS dwt_59 , v1_ . year_built AS year_built_60 , v1_ . observations AS observations_61 , v1_ . box_shape AS box_shape_62 , v1_ . open_hatch AS open_hatch_63 , v1_ . nitrogen_generator AS nitrogen_generator_64 , v1_ . imo_class AS imo_class_65 , v1_ . created_at AS created_at_66 , v1_ . updated_at AS updated_at_67 , o2_ . id AS id_68 , o2_ . company_name AS company_name_69 , o2_ . detailed_company_name AS detailed_company_name_70 , o2_ . address_line1 AS address_line1_71 , o2_ . address_line2 AS address_line2_72 , o2_ . address_line3 AS address_line3_73 , o2_ . chartering_email AS chartering_email_74 , o2_ . operations_email AS operations_email_75 , o2_ . accounting_email AS accounting_email_76 , o2_ . created_at AS created_at_77 , o2_ . updated_at AS updated_at_78 , c3_ . id AS id_79 , c3_ . company_name AS company_name_80 , c3_ . address_line1 AS address_line1_81 , c3_ . address_line2 AS address_line2_82 , c3_ . address_line3 AS address_line3_83 , c3_ . chartering_email AS chartering_email_84 , c3_ . operations_email AS operations_email_85 , c3_ . accounting_email AS accounting_email_86 , c3_ . observations AS observations_87 , c3_ . created_at AS created_at_88 , c3_ . updated_at AS updated_at_89 , u4_ . id AS id_90 , u4_ . name AS name_91 , u4_ . email AS email_92 , u4_ . roles AS roles_93 , u4_ . password AS password_94 , u4_ . confirmation_token AS confirmation_token_95 , u4_ . desk AS desk_96 , u4_ . created_at AS created_at_97 , u4_ . updated_at AS updated_at_98 , u5_ . id AS id_99 , u5_ . name AS name_100 , u5_ . email AS email_101 , u5_ . roles AS roles_102 , u5_ . password AS password_103 , u5_ . confirmation_token AS confirmation_token_104 , u5_ . desk AS desk_105 , u5_ . created_at AS created_at_106 , u5_ . updated_at AS updated_at_107 , a6_ . id AS id_108 , a6_ . additional_cost AS additional_cost_109 , a6_ . additional_cost_currency AS additional_cost_currency_110 , a6_ . additional_type AS additional_type_111 , a6_ . description AS description_112 , a6_ . created_at AS created_at_113 , a6_ . updated_at AS updated_at_114 , m7_ . id AS id_115 , m7_ . name AS name_116 , m7_ . content_size AS content_size_117 , m7_ . encoding_format AS encoding_format_118 , m7_ . upload_date AS upload_date_119 , m7_ . genre AS genre_120 , m7_ . file_path AS file_path_121 , m7_ . created_at AS created_at_122 , m7_ . updated_at AS updated_at_123 , p8_ . id AS id_124 , p8_ . port_call_type AS port_call_type_125 , p8_ . arrival AS arrival_126 , p8_ . berthing AS berthing_127 , p8_ . departure AS departure_128 , p8_ . created_at AS created_at_129 , p8_ . updated_at AS updated_at_130 , r9_ . id AS id_131 , r9_ . created_at AS created_at_132 , r9_ . updated_at AS updated_at_133 , r10_ . id AS id_134 , r10_ . category AS category_135 , r10_ . subcategory AS subcategory_136 , r10_ . created_at AS created_at_137 , r10_ . updated_at AS updated_at_138 , c11_ . id AS id_139 , c11_ . quantity_m3 AS quantity_m3_140 , c11_ . quantity_mt AS quantity_mt_141 , c11_ . created_at AS created_at_142 , c11_ . updated_at AS updated_at_143 , p12_ . id AS id_144 , p12_ . amount AS amount_145 , p12_ . amount_currency AS amount_currency_146 , p12_ . due_date AS due_date_147 , p12_ . description AS description_148 , p12_ . status AS status_149 , p12_ . created_at AS created_at_150 , p12_ . updated_at AS updated_at_151 , h13_ . id AS id_152 , h13_ . hire_begin AS hire_begin_153 , h13_ . hire_end AS hire_end_154 , h13_ . fuel_type AS fuel_type_155 , h13_ . fuel_type2 AS fuel_type2_156 , h13_ . fuel_type3 AS fuel_type3_157 , h13_ . price AS price_158 , h13_ . price2 AS price2_159 , h13_ . price3 AS price3_160 , h13_ . price_currency AS price_currency_161 , h13_ . price_currency2 AS price_currency2_162 , h13_ . price_currency3 AS price_currency3_163 , h13_ . multi_fuel AS multi_fuel_164 , h13_ . off_hire_begin AS off_hire_begin_165 , h13_ . off_hire_end AS off_hire_end_166 , h13_ . off_hire_cost AS off_hire_cost_167 , h13_ . off_hire_cost_currency AS off_hire_cost_currency_168 , h13_ . address_commission AS address_commission_169 , h13_ . extra_costs AS extra_costs_170 , h13_ . extra_costs_currency AS extra_costs_currency_171 , h13_ . extra_costs_description AS extra_costs_description_172 , h13_ . total_invoice AS total_invoice_173 , h13_ . total_invoice_currency AS total_invoice_currency_174 , h13_ . invoice_status AS invoice_status_175 , h13_ . bunker AS bunker_176 , h13_ . final_hire AS final_hire_177 , h13_ . created_at AS created_at_178 , h13_ . updated_at AS updated_at_179 , c14_ . id AS id_180 , c14_ . contract_number AS contract_number_181 , c14_ . contract_date AS contract_date_182 , c14_ . contract_type AS contract_type_183 , c14_ . laycan_start AS laycan_start_184 , c14_ . laycan_end AS laycan_end_185 , c14_ . status AS status_186 , c14_ . freight_cost AS freight_cost_187 , c14_ . freight_cost_currency AS freight_cost_currency_188 , c14_ . freight_type AS freight_type_189 , c14_ . demurrage_per_day AS demurrage_per_day_190 , c14_ . demurrage_per_day_currency AS demurrage_per_day_currency_191 , c14_ . address_commission AS address_commission_192 , c14_ . brokerage_commission AS brokerage_commission_193 , c14_ . liftings_min AS liftings_min_194 , c14_ . liftings_max AS liftings_max_195 , c14_ . checklist_notes AS checklist_notes_196 , c14_ . demurrage_status AS demurrage_status_197 , c14_ . demurrage_time_bar AS demurrage_time_bar_198 , c14_ . demurrage_payment_date AS demurrage_payment_date_199 , c14_ . final_demurrage_cost AS final_demurrage_cost_200 , c14_ . final_demurrage_cost_currency AS final_demurrage_cost_currency_201 , c14_ . demurrage_paid_by_charterer AS demurrage_paid_by_charterer_202 , c14_ . demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_203 , c14_ . eta_arrival AS eta_arrival_204 , c14_ . delivered_arrival AS delivered_arrival_205 , c14_ . delivery_aprox_notice1 AS delivery_aprox_notice1_206 , c14_ . delivery_aprox_notice2 AS delivery_aprox_notice2_207 , c14_ . delivery_aprox_notice3 AS delivery_aprox_notice3_208 , c14_ . delivery_aprox_notice4 AS delivery_aprox_notice4_209 , c14_ . delivery_aprox_notice5 AS delivery_aprox_notice5_210 , c14_ . delivery_aprox_notice6 AS delivery_aprox_notice6_211 , c14_ . delivery_aprox_notice7 AS delivery_aprox_notice7_212 , c14_ . delivery_firm_notice1 AS delivery_firm_notice1_213 , c14_ . delivery_firm_notice2 AS delivery_firm_notice2_214 , c14_ . delivery_firm_notice3 AS delivery_firm_notice3_215 , c14_ . delivery_firm_notice4 AS delivery_firm_notice4_216 , c14_ . delivery_firm_notice5 AS delivery_firm_notice5_217 , c14_ . delivery_firm_notice6 AS delivery_firm_notice6_218 , c14_ . delivery_firm_notice7 AS delivery_firm_notice7_219 , c14_ . delivery_notices_not_aplicable AS delivery_notices_not_aplicable_220 , c14_ . ship_delivered AS ship_delivered_221 , c14_ . hire_per_day AS hire_per_day_222 , c14_ . hire_per_day_currency AS hire_per_day_currency_223 , c14_ . period AS period_224 , c14_ . report_description AS report_description_225 , c14_ . vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_226 , c14_ . vessel_was_substituted AS vessel_was_substituted_227 , c14_ . addendum_issued AS addendum_issued_228 , c14_ . addendum_description AS addendum_description_229 , c14_ . created_at AS created_at_230 , c14_ . updated_at AS updated_at_231 , c15_ . id AS id_232 , c15_ . checklist_name AS checklist_name_233 , c15_ . notes AS notes_234 , c15_ . created_at AS created_at_235 , c15_ . updated_at AS updated_at_236 , t16_ . id AS id_237 , t16_ . task_name AS task_name_238 , t16_ . description AS description_239 , t16_ . task_index AS task_index_240 , t16_ . created_at AS created_at_241 , t16_ . updated_at AS updated_at_242 , p17_ . id AS id_243 , p17_ . port_name AS port_name_244 , p17_ . geographic_location AS geographic_location_245 , p17_ . cost_information_source AS cost_information_source_246 , p17_ . state AS state_247 , p17_ . country AS country_248 , p17_ . created_at AS created_at_249 , p17_ . updated_at AS updated_at_250 , p18_ . id AS id_251 , p18_ . port_name AS port_name_252 , p18_ . geographic_location AS geographic_location_253 , p18_ . cost_information_source AS cost_information_source_254 , p18_ . state AS state_255 , p18_ . country AS country_256 , p18_ . created_at AS created_at_257 , p18_ . updated_at AS updated_at_258 , d19_ . id AS id_259 , d19_ . notice_number AS notice_number_260 , d19_ . notice_type AS notice_type_261 , d19_ . notice_date AS notice_date_262 , d19_ . status AS status_263 , d19_ . created_at AS created_at_264 , d19_ . updated_at AS updated_at_265 , c20_ . id AS id_266 , c20_ . contract_number AS contract_number_267 , c20_ . contract_date AS contract_date_268 , c20_ . contract_type AS contract_type_269 , c20_ . laycan_start AS laycan_start_270 , c20_ . laycan_end AS laycan_end_271 , c20_ . status AS status_272 , c20_ . freight_cost AS freight_cost_273 , c20_ . freight_cost_currency AS freight_cost_currency_274 , c20_ . freight_type AS freight_type_275 , c20_ . demurrage_per_day AS demurrage_per_day_276 , c20_ . demurrage_per_day_currency AS demurrage_per_day_currency_277 , c20_ . address_commission AS address_commission_278 , c20_ . brokerage_commission AS brokerage_commission_279 , c20_ . liftings_min AS liftings_min_280 , c20_ . liftings_max AS liftings_max_281 , c20_ . checklist_notes AS checklist_notes_282 , c20_ . demurrage_status AS demurrage_status_283 , c20_ . demurrage_time_bar AS demurrage_time_bar_284 , c20_ . demurrage_payment_date AS demurrage_payment_date_285 , c20_ . final_demurrage_cost AS final_demurrage_cost_286 , c20_ . final_demurrage_cost_currency AS final_demurrage_cost_currency_287 , c20_ . demurrage_paid_by_charterer AS demurrage_paid_by_charterer_288 , c20_ . demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_289 , c20_ . eta_arrival AS eta_arrival_290 , c20_ . delivered_arrival AS delivered_arrival_291 , c20_ . delivery_aprox_notice1 AS delivery_aprox_notice1_292 , c20_ . delivery_aprox_notice2 AS delivery_aprox_notice2_293 , c20_ . delivery_aprox_notice3 AS delivery_aprox_notice3_294 , c20_ . delivery_aprox_notice4 AS delivery_aprox_notice4_295 , c20_ . delivery_aprox_notice5 AS delivery_aprox_notice5_296 , c20_ . delivery_aprox_notice6 AS delivery_aprox_notice6_297 , c20_ . delivery_aprox_notice7 AS delivery_aprox_notice7_298 , c20_ . delivery_firm_notice1 AS delivery_firm_notice1_299 , c20_ . delivery_firm_notice2 AS delivery_firm_notice2_300 , c20_ . delivery_firm_notice3 AS delivery_firm_notice3_301 , c20_ . delivery_firm_notice4 AS delivery_firm_notice4_302 , c20_ . delivery_firm_notice5 AS delivery_firm_notice5_303 , c20_ . delivery_firm_notice6 AS delivery_firm_notice6_304 , c20_ . delivery_firm_notice7 AS delivery_firm_notice7_305 , c20_ . delivery_notices_not_aplicable AS delivery_notices_not_aplicable_306 , c20_ . ship_delivered AS ship_delivered_307 , c20_ . hire_per_day AS hire_per_day_308 , c20_ . hire_per_day_currency AS hire_per_day_currency_309 , c20_ . period AS period_310 , c20_ . report_description AS report_description_311 , c20_ . vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_312 , c20_ . vessel_was_substituted AS vessel_was_substituted_313 , c20_ . addendum_issued AS addendum_issued_314 , c20_ . addendum_description AS addendum_description_315 , c20_ . created_at AS created_at_316 , c20_ . updated_at AS updated_at_317 , c0_ . vessel_id AS vessel_id_318 , c0_ . owner_id AS owner_id_319 , c0_ . charterer_id AS charterer_id_320 , c0_ . broker_id AS broker_id_321 , c0_ . operator_id AS operator_id_322 , c0_ . checklist_id AS checklist_id_323 , c0_ . delivery_port1_id AS delivery_port1_id_324 , c0_ . delivery_port2_id AS delivery_port2_id_325 , c0_ . contract_coa_id AS contract_coa_id_326 , v1_ . owner_id AS owner_id_327 , o2_ . primary_contact_id AS primary_contact_id_328 , u4_ . avatar_id AS avatar_id_329 , u5_ . avatar_id AS avatar_id_330 , a6_ . contract_id AS contract_id_331 , m7_ . contract_id AS contract_id_332 , p8_ . port_id AS port_id_333 , p8_ . contract_id AS contract_id_334 , r9_ . port_id AS port_id_335 , r9_ . contract_id AS contract_id_336 , r10_ . contract_id AS contract_id_337 , c11_ . cargo_id AS cargo_id_338 , c11_ . contract_id AS contract_id_339 , p12_ . contract_id AS contract_id_340 , h13_ . contract_id AS contract_id_341 , c14_ . vessel_id AS vessel_id_342 , c14_ . owner_id AS owner_id_343 , c14_ . charterer_id AS charterer_id_344 , c14_ . broker_id AS broker_id_345 , c14_ . operator_id AS operator_id_346 , c14_ . checklist_id AS checklist_id_347 , c14_ . delivery_port1_id AS delivery_port1_id_348 , c14_ . delivery_port2_id AS delivery_port2_id_349 , c14_ . contract_coa_id AS contract_coa_id_350 , t16_ . checklist_id AS checklist_id_351 , d19_ . contract_id AS contract_id_352 , c20_ . vessel_id AS vessel_id_353 , c20_ . owner_id AS owner_id_354 , c20_ . charterer_id AS charterer_id_355 , c20_ . broker_id AS broker_id_356 , c20_ . operator_id AS operator_id_357 , c20_ . checklist_id AS checklist_id_358 , c20_ . delivery_port1_id AS delivery_port1_id_359 , c20_ . delivery_port2_id AS delivery_port2_id_360 , c20_ . contract_coa_id AS contract_coa_id_361 FROM contract c0_ LEFT JOIN vessel v1_ ON c0_ . vessel_id = v1_ . id LEFT JOIN owner o2_ ON c0_ . owner_id = o2_ . id LEFT JOIN charterer c3_ ON c0_ . charterer_id = c3_ . id LEFT JOIN user u4_ ON c0_ . broker_id = u4_ . id LEFT JOIN user u5_ ON c0_ . operator_id = u5_ . id LEFT JOIN additional_cost a6_ ON c0_ . id = a6_ . contract_id LEFT JOIN media m7_ ON c0_ . id = m7_ . contract_id LEFT JOIN port_call p8_ ON c0_ . id = p8_ . contract_id LEFT JOIN reported_port r9_ ON c0_ . id = r9_ . contract_id LEFT JOIN reported_incident r10_ ON c0_ . id = r10_ . contract_id LEFT JOIN contract_cargo c11_ ON c0_ . id = c11_ . contract_id LEFT JOIN payment p12_ ON c0_ . id = p12_ . contract_id LEFT JOIN hire h13_ ON c0_ . id = h13_ . contract_id LEFT JOIN contract c14_ ON c0_ . id = c14_ . contract_coa_id LEFT JOIN checklist c15_ ON c0_ . checklist_id = c15_ . id LEFT JOIN contract_task c21_ ON c0_ . id = c21_ . contract_id LEFT JOIN task t16_ ON t16_ . id = c21_ . task_id LEFT JOIN port p17_ ON c0_ . delivery_port1_id = p17_ . id LEFT JOIN port p18_ ON c0_ . delivery_port2_id = p18_ . id LEFT JOIN delivery_notice d19_ ON c0_ . id = d19_ . contract_id LEFT JOIN contract c20_ ON c0_ . contract_coa_id = c20_ . id WHERE c0_ . id = ?
Parameters :
[
"0764fa06-767c-45a1-8474-e54bc661528f "
]
SELECT
c0_ . id AS id_0 ,
c0_ . contract_number AS contract_number_1 ,
c0_ . contract_date AS contract_date_2 ,
c0_ . contract_type AS contract_type_3 ,
c0_ . laycan_start AS laycan_start_4 ,
c0_ . laycan_end AS laycan_end_5 ,
c0_ . status AS status_6 ,
c0_ . freight_cost AS freight_cost_7 ,
c0_ . freight_cost_currency AS freight_cost_currency_8 ,
c0_ . freight_type AS freight_type_9 ,
c0_ . demurrage_per_day AS demurrage_per_day_10 ,
c0_ . demurrage_per_day_currency AS demurrage_per_day_currency_11 ,
c0_ . address_commission AS address_commission_12 ,
c0_ . brokerage_commission AS brokerage_commission_13 ,
c0_ . liftings_min AS liftings_min_14 ,
c0_ . liftings_max AS liftings_max_15 ,
c0_ . checklist_notes AS checklist_notes_16 ,
c0_ . demurrage_status AS demurrage_status_17 ,
c0_ . demurrage_time_bar AS demurrage_time_bar_18 ,
c0_ . demurrage_payment_date AS demurrage_payment_date_19 ,
c0_ . final_demurrage_cost AS final_demurrage_cost_20 ,
c0_ . final_demurrage_cost_currency AS final_demurrage_cost_currency_21 ,
c0_ . demurrage_paid_by_charterer AS demurrage_paid_by_charterer_22 ,
c0_ . demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_23 ,
c0_ . eta_arrival AS eta_arrival_24 ,
c0_ . delivered_arrival AS delivered_arrival_25 ,
c0_ . delivery_aprox_notice1 AS delivery_aprox_notice1_26 ,
c0_ . delivery_aprox_notice2 AS delivery_aprox_notice2_27 ,
c0_ . delivery_aprox_notice3 AS delivery_aprox_notice3_28 ,
c0_ . delivery_aprox_notice4 AS delivery_aprox_notice4_29 ,
c0_ . delivery_aprox_notice5 AS delivery_aprox_notice5_30 ,
c0_ . delivery_aprox_notice6 AS delivery_aprox_notice6_31 ,
c0_ . delivery_aprox_notice7 AS delivery_aprox_notice7_32 ,
c0_ . delivery_firm_notice1 AS delivery_firm_notice1_33 ,
c0_ . delivery_firm_notice2 AS delivery_firm_notice2_34 ,
c0_ . delivery_firm_notice3 AS delivery_firm_notice3_35 ,
c0_ . delivery_firm_notice4 AS delivery_firm_notice4_36 ,
c0_ . delivery_firm_notice5 AS delivery_firm_notice5_37 ,
c0_ . delivery_firm_notice6 AS delivery_firm_notice6_38 ,
c0_ . delivery_firm_notice7 AS delivery_firm_notice7_39 ,
c0_ . delivery_notices_not_aplicable AS delivery_notices_not_aplicable_40 ,
c0_ . ship_delivered AS ship_delivered_41 ,
c0_ . hire_per_day AS hire_per_day_42 ,
c0_ . hire_per_day_currency AS hire_per_day_currency_43 ,
c0_ . period AS period_44 ,
c0_ . report_description AS report_description_45 ,
c0_ . vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_46 ,
c0_ . vessel_was_substituted AS vessel_was_substituted_47 ,
c0_ . addendum_issued AS addendum_issued_48 ,
c0_ . addendum_description AS addendum_description_49 ,
c0_ . created_at AS created_at_50 ,
c0_ . updated_at AS updated_at_51 ,
v1_ . id AS id_52 ,
v1_ . vessel_name AS vessel_name_53 ,
v1_ . imo_number AS imo_number_54 ,
v1_ . vessel_type AS vessel_type_55 ,
v1_ . tanker_type AS tanker_type_56 ,
v1_ . bulker_type AS bulker_type_57 ,
v1_ . tank_coating AS tank_coating_58 ,
v1_ . dwt AS dwt_59 ,
v1_ . year_built AS year_built_60 ,
v1_ . observations AS observations_61 ,
v1_ . box_shape AS box_shape_62 ,
v1_ . open_hatch AS open_hatch_63 ,
v1_ . nitrogen_generator AS nitrogen_generator_64 ,
v1_ . imo_class AS imo_class_65 ,
v1_ . created_at AS created_at_66 ,
v1_ . updated_at AS updated_at_67 ,
o2_ . id AS id_68 ,
o2_ . company_name AS company_name_69 ,
o2_ . detailed_company_name AS detailed_company_name_70 ,
o2_ . address_line1 AS address_line1_71 ,
o2_ . address_line2 AS address_line2_72 ,
o2_ . address_line3 AS address_line3_73 ,
o2_ . chartering_email AS chartering_email_74 ,
o2_ . operations_email AS operations_email_75 ,
o2_ . accounting_email AS accounting_email_76 ,
o2_ . created_at AS created_at_77 ,
o2_ . updated_at AS updated_at_78 ,
c3_ . id AS id_79 ,
c3_ . company_name AS company_name_80 ,
c3_ . address_line1 AS address_line1_81 ,
c3_ . address_line2 AS address_line2_82 ,
c3_ . address_line3 AS address_line3_83 ,
c3_ . chartering_email AS chartering_email_84 ,
c3_ . operations_email AS operations_email_85 ,
c3_ . accounting_email AS accounting_email_86 ,
c3_ . observations AS observations_87 ,
c3_ . created_at AS created_at_88 ,
c3_ . updated_at AS updated_at_89 ,
u4_ . id AS id_90 ,
u4_ . name AS name_91 ,
u4_ . email AS email_92 ,
u4_ . roles AS roles_93 ,
u4_ . password AS password_94 ,
u4_ . confirmation_token AS confirmation_token_95 ,
u4_ . desk AS desk_96 ,
u4_ . created_at AS created_at_97 ,
u4_ . updated_at AS updated_at_98 ,
u5_ . id AS id_99 ,
u5_ . name AS name_100 ,
u5_ . email AS email_101 ,
u5_ . roles AS roles_102 ,
u5_ . password AS password_103 ,
u5_ . confirmation_token AS confirmation_token_104 ,
u5_ . desk AS desk_105 ,
u5_ . created_at AS created_at_106 ,
u5_ . updated_at AS updated_at_107 ,
a6_ . id AS id_108 ,
a6_ . additional_cost AS additional_cost_109 ,
a6_ . additional_cost_currency AS additional_cost_currency_110 ,
a6_ . additional_type AS additional_type_111 ,
a6_ . description AS description_112 ,
a6_ . created_at AS created_at_113 ,
a6_ . updated_at AS updated_at_114 ,
m7_ . id AS id_115 ,
m7_ . name AS name_116 ,
m7_ . content_size AS content_size_117 ,
m7_ . encoding_format AS encoding_format_118 ,
m7_ . upload_date AS upload_date_119 ,
m7_ . genre AS genre_120 ,
m7_ . file_path AS file_path_121 ,
m7_ . created_at AS created_at_122 ,
m7_ . updated_at AS updated_at_123 ,
p8_ . id AS id_124 ,
p8_ . port_call_type AS port_call_type_125 ,
p8_ . arrival AS arrival_126 ,
p8_ . berthing AS berthing_127 ,
p8_ . departure AS departure_128 ,
p8_ . created_at AS created_at_129 ,
p8_ . updated_at AS updated_at_130 ,
r9_ . id AS id_131 ,
r9_ . created_at AS created_at_132 ,
r9_ . updated_at AS updated_at_133 ,
r10_ . id AS id_134 ,
r10_ . category AS category_135 ,
r10_ . subcategory AS subcategory_136 ,
r10_ . created_at AS created_at_137 ,
r10_ . updated_at AS updated_at_138 ,
c11_ . id AS id_139 ,
c11_ . quantity_m3 AS quantity_m3_140 ,
c11_ . quantity_mt AS quantity_mt_141 ,
c11_ . created_at AS created_at_142 ,
c11_ . updated_at AS updated_at_143 ,
p12_ . id AS id_144 ,
p12_ . amount AS amount_145 ,
p12_ . amount_currency AS amount_currency_146 ,
p12_ . due_date AS due_date_147 ,
p12_ . description AS description_148 ,
p12_ . status AS status_149 ,
p12_ . created_at AS created_at_150 ,
p12_ . updated_at AS updated_at_151 ,
h13_ . id AS id_152 ,
h13_ . hire_begin AS hire_begin_153 ,
h13_ . hire_end AS hire_end_154 ,
h13_ . fuel_type AS fuel_type_155 ,
h13_ . fuel_type2 AS fuel_type2_156 ,
h13_ . fuel_type3 AS fuel_type3_157 ,
h13_ . price AS price_158 ,
h13_ . price2 AS price2_159 ,
h13_ . price3 AS price3_160 ,
h13_ . price_currency AS price_currency_161 ,
h13_ . price_currency2 AS price_currency2_162 ,
h13_ . price_currency3 AS price_currency3_163 ,
h13_ . multi_fuel AS multi_fuel_164 ,
h13_ . off_hire_begin AS off_hire_begin_165 ,
h13_ . off_hire_end AS off_hire_end_166 ,
h13_ . off_hire_cost AS off_hire_cost_167 ,
h13_ . off_hire_cost_currency AS off_hire_cost_currency_168 ,
h13_ . address_commission AS address_commission_169 ,
h13_ . extra_costs AS extra_costs_170 ,
h13_ . extra_costs_currency AS extra_costs_currency_171 ,
h13_ . extra_costs_description AS extra_costs_description_172 ,
h13_ . total_invoice AS total_invoice_173 ,
h13_ . total_invoice_currency AS total_invoice_currency_174 ,
h13_ . invoice_status AS invoice_status_175 ,
h13_ . bunker AS bunker_176 ,
h13_ . final_hire AS final_hire_177 ,
h13_ . created_at AS created_at_178 ,
h13_ . updated_at AS updated_at_179 ,
c14_ . id AS id_180 ,
c14_ . contract_number AS contract_number_181 ,
c14_ . contract_date AS contract_date_182 ,
c14_ . contract_type AS contract_type_183 ,
c14_ . laycan_start AS laycan_start_184 ,
c14_ . laycan_end AS laycan_end_185 ,
c14_ . status AS status_186 ,
c14_ . freight_cost AS freight_cost_187 ,
c14_ . freight_cost_currency AS freight_cost_currency_188 ,
c14_ . freight_type AS freight_type_189 ,
c14_ . demurrage_per_day AS demurrage_per_day_190 ,
c14_ . demurrage_per_day_currency AS demurrage_per_day_currency_191 ,
c14_ . address_commission AS address_commission_192 ,
c14_ . brokerage_commission AS brokerage_commission_193 ,
c14_ . liftings_min AS liftings_min_194 ,
c14_ . liftings_max AS liftings_max_195 ,
c14_ . checklist_notes AS checklist_notes_196 ,
c14_ . demurrage_status AS demurrage_status_197 ,
c14_ . demurrage_time_bar AS demurrage_time_bar_198 ,
c14_ . demurrage_payment_date AS demurrage_payment_date_199 ,
c14_ . final_demurrage_cost AS final_demurrage_cost_200 ,
c14_ . final_demurrage_cost_currency AS final_demurrage_cost_currency_201 ,
c14_ . demurrage_paid_by_charterer AS demurrage_paid_by_charterer_202 ,
c14_ . demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_203 ,
c14_ . eta_arrival AS eta_arrival_204 ,
c14_ . delivered_arrival AS delivered_arrival_205 ,
c14_ . delivery_aprox_notice1 AS delivery_aprox_notice1_206 ,
c14_ . delivery_aprox_notice2 AS delivery_aprox_notice2_207 ,
c14_ . delivery_aprox_notice3 AS delivery_aprox_notice3_208 ,
c14_ . delivery_aprox_notice4 AS delivery_aprox_notice4_209 ,
c14_ . delivery_aprox_notice5 AS delivery_aprox_notice5_210 ,
c14_ . delivery_aprox_notice6 AS delivery_aprox_notice6_211 ,
c14_ . delivery_aprox_notice7 AS delivery_aprox_notice7_212 ,
c14_ . delivery_firm_notice1 AS delivery_firm_notice1_213 ,
c14_ . delivery_firm_notice2 AS delivery_firm_notice2_214 ,
c14_ . delivery_firm_notice3 AS delivery_firm_notice3_215 ,
c14_ . delivery_firm_notice4 AS delivery_firm_notice4_216 ,
c14_ . delivery_firm_notice5 AS delivery_firm_notice5_217 ,
c14_ . delivery_firm_notice6 AS delivery_firm_notice6_218 ,
c14_ . delivery_firm_notice7 AS delivery_firm_notice7_219 ,
c14_ . delivery_notices_not_aplicable AS delivery_notices_not_aplicable_220 ,
c14_ . ship_delivered AS ship_delivered_221 ,
c14_ . hire_per_day AS hire_per_day_222 ,
c14_ . hire_per_day_currency AS hire_per_day_currency_223 ,
c14_ . period AS period_224 ,
c14_ . report_description AS report_description_225 ,
c14_ . vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_226 ,
c14_ . vessel_was_substituted AS vessel_was_substituted_227 ,
c14_ . addendum_issued AS addendum_issued_228 ,
c14_ . addendum_description AS addendum_description_229 ,
c14_ . created_at AS created_at_230 ,
c14_ . updated_at AS updated_at_231 ,
c15_ . id AS id_232 ,
c15_ . checklist_name AS checklist_name_233 ,
c15_ . notes AS notes_234 ,
c15_ . created_at AS created_at_235 ,
c15_ . updated_at AS updated_at_236 ,
t16_ . id AS id_237 ,
t16_ . task_name AS task_name_238 ,
t16_ . description AS description_239 ,
t16_ . task_index AS task_index_240 ,
t16_ . created_at AS created_at_241 ,
t16_ . updated_at AS updated_at_242 ,
p17_ . id AS id_243 ,
p17_ . port_name AS port_name_244 ,
p17_ . geographic_location AS geographic_location_245 ,
p17_ . cost_information_source AS cost_information_source_246 ,
p17_ . state AS state_247 ,
p17_ . country AS country_248 ,
p17_ . created_at AS created_at_249 ,
p17_ . updated_at AS updated_at_250 ,
p18_ . id AS id_251 ,
p18_ . port_name AS port_name_252 ,
p18_ . geographic_location AS geographic_location_253 ,
p18_ . cost_information_source AS cost_information_source_254 ,
p18_ . state AS state_255 ,
p18_ . country AS country_256 ,
p18_ . created_at AS created_at_257 ,
p18_ . updated_at AS updated_at_258 ,
d19_ . id AS id_259 ,
d19_ . notice_number AS notice_number_260 ,
d19_ . notice_type AS notice_type_261 ,
d19_ . notice_date AS notice_date_262 ,
d19_ . status AS status_263 ,
d19_ . created_at AS created_at_264 ,
d19_ . updated_at AS updated_at_265 ,
c20_ . id AS id_266 ,
c20_ . contract_number AS contract_number_267 ,
c20_ . contract_date AS contract_date_268 ,
c20_ . contract_type AS contract_type_269 ,
c20_ . laycan_start AS laycan_start_270 ,
c20_ . laycan_end AS laycan_end_271 ,
c20_ . status AS status_272 ,
c20_ . freight_cost AS freight_cost_273 ,
c20_ . freight_cost_currency AS freight_cost_currency_274 ,
c20_ . freight_type AS freight_type_275 ,
c20_ . demurrage_per_day AS demurrage_per_day_276 ,
c20_ . demurrage_per_day_currency AS demurrage_per_day_currency_277 ,
c20_ . address_commission AS address_commission_278 ,
c20_ . brokerage_commission AS brokerage_commission_279 ,
c20_ . liftings_min AS liftings_min_280 ,
c20_ . liftings_max AS liftings_max_281 ,
c20_ . checklist_notes AS checklist_notes_282 ,
c20_ . demurrage_status AS demurrage_status_283 ,
c20_ . demurrage_time_bar AS demurrage_time_bar_284 ,
c20_ . demurrage_payment_date AS demurrage_payment_date_285 ,
c20_ . final_demurrage_cost AS final_demurrage_cost_286 ,
c20_ . final_demurrage_cost_currency AS final_demurrage_cost_currency_287 ,
c20_ . demurrage_paid_by_charterer AS demurrage_paid_by_charterer_288 ,
c20_ . demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_289 ,
c20_ . eta_arrival AS eta_arrival_290 ,
c20_ . delivered_arrival AS delivered_arrival_291 ,
c20_ . delivery_aprox_notice1 AS delivery_aprox_notice1_292 ,
c20_ . delivery_aprox_notice2 AS delivery_aprox_notice2_293 ,
c20_ . delivery_aprox_notice3 AS delivery_aprox_notice3_294 ,
c20_ . delivery_aprox_notice4 AS delivery_aprox_notice4_295 ,
c20_ . delivery_aprox_notice5 AS delivery_aprox_notice5_296 ,
c20_ . delivery_aprox_notice6 AS delivery_aprox_notice6_297 ,
c20_ . delivery_aprox_notice7 AS delivery_aprox_notice7_298 ,
c20_ . delivery_firm_notice1 AS delivery_firm_notice1_299 ,
c20_ . delivery_firm_notice2 AS delivery_firm_notice2_300 ,
c20_ . delivery_firm_notice3 AS delivery_firm_notice3_301 ,
c20_ . delivery_firm_notice4 AS delivery_firm_notice4_302 ,
c20_ . delivery_firm_notice5 AS delivery_firm_notice5_303 ,
c20_ . delivery_firm_notice6 AS delivery_firm_notice6_304 ,
c20_ . delivery_firm_notice7 AS delivery_firm_notice7_305 ,
c20_ . delivery_notices_not_aplicable AS delivery_notices_not_aplicable_306 ,
c20_ . ship_delivered AS ship_delivered_307 ,
c20_ . hire_per_day AS hire_per_day_308 ,
c20_ . hire_per_day_currency AS hire_per_day_currency_309 ,
c20_ . period AS period_310 ,
c20_ . report_description AS report_description_311 ,
c20_ . vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_312 ,
c20_ . vessel_was_substituted AS vessel_was_substituted_313 ,
c20_ . addendum_issued AS addendum_issued_314 ,
c20_ . addendum_description AS addendum_description_315 ,
c20_ . created_at AS created_at_316 ,
c20_ . updated_at AS updated_at_317 ,
c0_ . vessel_id AS vessel_id_318 ,
c0_ . owner_id AS owner_id_319 ,
c0_ . charterer_id AS charterer_id_320 ,
c0_ . broker_id AS broker_id_321 ,
c0_ . operator_id AS operator_id_322 ,
c0_ . checklist_id AS checklist_id_323 ,
c0_ . delivery_port1_id AS delivery_port1_id_324 ,
c0_ . delivery_port2_id AS delivery_port2_id_325 ,
c0_ . contract_coa_id AS contract_coa_id_326 ,
v1_ . owner_id AS owner_id_327 ,
o2_ . primary_contact_id AS primary_contact_id_328 ,
u4_ . avatar_id AS avatar_id_329 ,
u5_ . avatar_id AS avatar_id_330 ,
a6_ . contract_id AS contract_id_331 ,
m7_ . contract_id AS contract_id_332 ,
p8_ . port_id AS port_id_333 ,
p8_ . contract_id AS contract_id_334 ,
r9_ . port_id AS port_id_335 ,
r9_ . contract_id AS contract_id_336 ,
r10_ . contract_id AS contract_id_337 ,
c11_ . cargo_id AS cargo_id_338 ,
c11_ . contract_id AS contract_id_339 ,
p12_ . contract_id AS contract_id_340 ,
h13_ . contract_id AS contract_id_341 ,
c14_ . vessel_id AS vessel_id_342 ,
c14_ . owner_id AS owner_id_343 ,
c14_ . charterer_id AS charterer_id_344 ,
c14_ . broker_id AS broker_id_345 ,
c14_ . operator_id AS operator_id_346 ,
c14_ . checklist_id AS checklist_id_347 ,
c14_ . delivery_port1_id AS delivery_port1_id_348 ,
c14_ . delivery_port2_id AS delivery_port2_id_349 ,
c14_ . contract_coa_id AS contract_coa_id_350 ,
t16_ . checklist_id AS checklist_id_351 ,
d19_ . contract_id AS contract_id_352 ,
c20_ . vessel_id AS vessel_id_353 ,
c20_ . owner_id AS owner_id_354 ,
c20_ . charterer_id AS charterer_id_355 ,
c20_ . broker_id AS broker_id_356 ,
c20_ . operator_id AS operator_id_357 ,
c20_ . checklist_id AS checklist_id_358 ,
c20_ . delivery_port1_id AS delivery_port1_id_359 ,
c20_ . delivery_port2_id AS delivery_port2_id_360 ,
c20_ . contract_coa_id AS contract_coa_id_361
FROM
contract c0_
LEFT JOIN vessel v1_ ON c0_ . vessel_id = v1_ . id
LEFT JOIN owner o2_ ON c0_ . owner_id = o2_ . id
LEFT JOIN charterer c3_ ON c0_ . charterer_id = c3_ . id
LEFT JOIN user u4_ ON c0_ . broker_id = u4_ . id
LEFT JOIN user u5_ ON c0_ . operator_id = u5_ . id
LEFT JOIN additional_cost a6_ ON c0_ . id = a6_ . contract_id
LEFT JOIN media m7_ ON c0_ . id = m7_ . contract_id
LEFT JOIN port_call p8_ ON c0_ . id = p8_ . contract_id
LEFT JOIN reported_port r9_ ON c0_ . id = r9_ . contract_id
LEFT JOIN reported_incident r10_ ON c0_ . id = r10_ . contract_id
LEFT JOIN contract_cargo c11_ ON c0_ . id = c11_ . contract_id
LEFT JOIN payment p12_ ON c0_ . id = p12_ . contract_id
LEFT JOIN hire h13_ ON c0_ . id = h13_ . contract_id
LEFT JOIN contract c14_ ON c0_ . id = c14_ . contract_coa_id
LEFT JOIN checklist c15_ ON c0_ . checklist_id = c15_ . id
LEFT JOIN contract_task c21_ ON c0_ . id = c21_ . contract_id
LEFT JOIN task t16_ ON t16_ . id = c21_ . task_id
LEFT JOIN port p17_ ON c0_ . delivery_port1_id = p17_ . id
LEFT JOIN port p18_ ON c0_ . delivery_port2_id = p18_ . id
LEFT JOIN delivery_notice d19_ ON c0_ . id = d19_ . contract_id
LEFT JOIN contract c20_ ON c0_ . contract_coa_id = c20_ . id
WHERE
c0_ . id = ?
Copy
SELECT c0_ . id AS id_0 , c0_ . contract_number AS contract_number_1 , c0_ . contract_date AS contract_date_2 , c0_ . contract_type AS contract_type_3 , c0_ . laycan_start AS laycan_start_4 , c0_ . laycan_end AS laycan_end_5 , c0_ . status AS status_6 , c0_ . freight_cost AS freight_cost_7 , c0_ . freight_cost_currency AS freight_cost_currency_8 , c0_ . freight_type AS freight_type_9 , c0_ . demurrage_per_day AS demurrage_per_day_10 , c0_ . demurrage_per_day_currency AS demurrage_per_day_currency_11 , c0_ . address_commission AS address_commission_12 , c0_ . brokerage_commission AS brokerage_commission_13 , c0_ . liftings_min AS liftings_min_14 , c0_ . liftings_max AS liftings_max_15 , c0_ . checklist_notes AS checklist_notes_16 , c0_ . demurrage_status AS demurrage_status_17 , c0_ . demurrage_time_bar AS demurrage_time_bar_18 , c0_ . demurrage_payment_date AS demurrage_payment_date_19 , c0_ . final_demurrage_cost AS final_demurrage_cost_20 , c0_ . final_demurrage_cost_currency AS final_demurrage_cost_currency_21 , c0_ . demurrage_paid_by_charterer AS demurrage_paid_by_charterer_22 , c0_ . demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_23 , c0_ . eta_arrival AS eta_arrival_24 , c0_ . delivered_arrival AS delivered_arrival_25 , c0_ . delivery_aprox_notice1 AS delivery_aprox_notice1_26 , c0_ . delivery_aprox_notice2 AS delivery_aprox_notice2_27 , c0_ . delivery_aprox_notice3 AS delivery_aprox_notice3_28 , c0_ . delivery_aprox_notice4 AS delivery_aprox_notice4_29 , c0_ . delivery_aprox_notice5 AS delivery_aprox_notice5_30 , c0_ . delivery_aprox_notice6 AS delivery_aprox_notice6_31 , c0_ . delivery_aprox_notice7 AS delivery_aprox_notice7_32 , c0_ . delivery_firm_notice1 AS delivery_firm_notice1_33 , c0_ . delivery_firm_notice2 AS delivery_firm_notice2_34 , c0_ . delivery_firm_notice3 AS delivery_firm_notice3_35 , c0_ . delivery_firm_notice4 AS delivery_firm_notice4_36 , c0_ . delivery_firm_notice5 AS delivery_firm_notice5_37 , c0_ . delivery_firm_notice6 AS delivery_firm_notice6_38 , c0_ . delivery_firm_notice7 AS delivery_firm_notice7_39 , c0_ . delivery_notices_not_aplicable AS delivery_notices_not_aplicable_40 , c0_ . ship_delivered AS ship_delivered_41 , c0_ . hire_per_day AS hire_per_day_42 , c0_ . hire_per_day_currency AS hire_per_day_currency_43 , c0_ . period AS period_44 , c0_ . report_description AS report_description_45 , c0_ . vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_46 , c0_ . vessel_was_substituted AS vessel_was_substituted_47 , c0_ . addendum_issued AS addendum_issued_48 , c0_ . addendum_description AS addendum_description_49 , c0_ . created_at AS created_at_50 , c0_ . updated_at AS updated_at_51 , v1_ . id AS id_52 , v1_ . vessel_name AS vessel_name_53 , v1_ . imo_number AS imo_number_54 , v1_ . vessel_type AS vessel_type_55 , v1_ . tanker_type AS tanker_type_56 , v1_ . bulker_type AS bulker_type_57 , v1_ . tank_coating AS tank_coating_58 , v1_ . dwt AS dwt_59 , v1_ . year_built AS year_built_60 , v1_ . observations AS observations_61 , v1_ . box_shape AS box_shape_62 , v1_ . open_hatch AS open_hatch_63 , v1_ . nitrogen_generator AS nitrogen_generator_64 , v1_ . imo_class AS imo_class_65 , v1_ . created_at AS created_at_66 , v1_ . updated_at AS updated_at_67 , o2_ . id AS id_68 , o2_ . company_name AS company_name_69 , o2_ . detailed_company_name AS detailed_company_name_70 , o2_ . address_line1 AS address_line1_71 , o2_ . address_line2 AS address_line2_72 , o2_ . address_line3 AS address_line3_73 , o2_ . chartering_email AS chartering_email_74 , o2_ . operations_email AS operations_email_75 , o2_ . accounting_email AS accounting_email_76 , o2_ . created_at AS created_at_77 , o2_ . updated_at AS updated_at_78 , c3_ . id AS id_79 , c3_ . company_name AS company_name_80 , c3_ . address_line1 AS address_line1_81 , c3_ . address_line2 AS address_line2_82 , c3_ . address_line3 AS address_line3_83 , c3_ . chartering_email AS chartering_email_84 , c3_ . operations_email AS operations_email_85 , c3_ . accounting_email AS accounting_email_86 , c3_ . observations AS observations_87 , c3_ . created_at AS created_at_88 , c3_ . updated_at AS updated_at_89 , u4_ . id AS id_90 , u4_ . name AS name_91 , u4_ . email AS email_92 , u4_ . roles AS roles_93 , u4_ . password AS password_94 , u4_ . confirmation_token AS confirmation_token_95 , u4_ . desk AS desk_96 , u4_ . created_at AS created_at_97 , u4_ . updated_at AS updated_at_98 , u5_ . id AS id_99 , u5_ . name AS name_100 , u5_ . email AS email_101 , u5_ . roles AS roles_102 , u5_ . password AS password_103 , u5_ . confirmation_token AS confirmation_token_104 , u5_ . desk AS desk_105 , u5_ . created_at AS created_at_106 , u5_ . updated_at AS updated_at_107 , a6_ . id AS id_108 , a6_ . additional_cost AS additional_cost_109 , a6_ . additional_cost_currency AS additional_cost_currency_110 , a6_ . additional_type AS additional_type_111 , a6_ . description AS description_112 , a6_ . created_at AS created_at_113 , a6_ . updated_at AS updated_at_114 , m7_ . id AS id_115 , m7_ . name AS name_116 , m7_ . content_size AS content_size_117 , m7_ . encoding_format AS encoding_format_118 , m7_ . upload_date AS upload_date_119 , m7_ . genre AS genre_120 , m7_ . file_path AS file_path_121 , m7_ . created_at AS created_at_122 , m7_ . updated_at AS updated_at_123 , p8_ . id AS id_124 , p8_ . port_call_type AS port_call_type_125 , p8_ . arrival AS arrival_126 , p8_ . berthing AS berthing_127 , p8_ . departure AS departure_128 , p8_ . created_at AS created_at_129 , p8_ . updated_at AS updated_at_130 , r9_ . id AS id_131 , r9_ . created_at AS created_at_132 , r9_ . updated_at AS updated_at_133 , r10_ . id AS id_134 , r10_ . category AS category_135 , r10_ . subcategory AS subcategory_136 , r10_ . created_at AS created_at_137 , r10_ . updated_at AS updated_at_138 , c11_ . id AS id_139 , c11_ . quantity_m3 AS quantity_m3_140 , c11_ . quantity_mt AS quantity_mt_141 , c11_ . created_at AS created_at_142 , c11_ . updated_at AS updated_at_143 , p12_ . id AS id_144 , p12_ . amount AS amount_145 , p12_ . amount_currency AS amount_currency_146 , p12_ . due_date AS due_date_147 , p12_ . description AS description_148 , p12_ . status AS status_149 , p12_ . created_at AS created_at_150 , p12_ . updated_at AS updated_at_151 , h13_ . id AS id_152 , h13_ . hire_begin AS hire_begin_153 , h13_ . hire_end AS hire_end_154 , h13_ . fuel_type AS fuel_type_155 , h13_ . fuel_type2 AS fuel_type2_156 , h13_ . fuel_type3 AS fuel_type3_157 , h13_ . price AS price_158 , h13_ . price2 AS price2_159 , h13_ . price3 AS price3_160 , h13_ . price_currency AS price_currency_161 , h13_ . price_currency2 AS price_currency2_162 , h13_ . price_currency3 AS price_currency3_163 , h13_ . multi_fuel AS multi_fuel_164 , h13_ . off_hire_begin AS off_hire_begin_165 , h13_ . off_hire_end AS off_hire_end_166 , h13_ . off_hire_cost AS off_hire_cost_167 , h13_ . off_hire_cost_currency AS off_hire_cost_currency_168 , h13_ . address_commission AS address_commission_169 , h13_ . extra_costs AS extra_costs_170 , h13_ . extra_costs_currency AS extra_costs_currency_171 , h13_ . extra_costs_description AS extra_costs_description_172 , h13_ . total_invoice AS total_invoice_173 , h13_ . total_invoice_currency AS total_invoice_currency_174 , h13_ . invoice_status AS invoice_status_175 , h13_ . bunker AS bunker_176 , h13_ . final_hire AS final_hire_177 , h13_ . created_at AS created_at_178 , h13_ . updated_at AS updated_at_179 , c14_ . id AS id_180 , c14_ . contract_number AS contract_number_181 , c14_ . contract_date AS contract_date_182 , c14_ . contract_type AS contract_type_183 , c14_ . laycan_start AS laycan_start_184 , c14_ . laycan_end AS laycan_end_185 , c14_ . status AS status_186 , c14_ . freight_cost AS freight_cost_187 , c14_ . freight_cost_currency AS freight_cost_currency_188 , c14_ . freight_type AS freight_type_189 , c14_ . demurrage_per_day AS demurrage_per_day_190 , c14_ . demurrage_per_day_currency AS demurrage_per_day_currency_191 , c14_ . address_commission AS address_commission_192 , c14_ . brokerage_commission AS brokerage_commission_193 , c14_ . liftings_min AS liftings_min_194 , c14_ . liftings_max AS liftings_max_195 , c14_ . checklist_notes AS checklist_notes_196 , c14_ . demurrage_status AS demurrage_status_197 , c14_ . demurrage_time_bar AS demurrage_time_bar_198 , c14_ . demurrage_payment_date AS demurrage_payment_date_199 , c14_ . final_demurrage_cost AS final_demurrage_cost_200 , c14_ . final_demurrage_cost_currency AS final_demurrage_cost_currency_201 , c14_ . demurrage_paid_by_charterer AS demurrage_paid_by_charterer_202 , c14_ . demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_203 , c14_ . eta_arrival AS eta_arrival_204 , c14_ . delivered_arrival AS delivered_arrival_205 , c14_ . delivery_aprox_notice1 AS delivery_aprox_notice1_206 , c14_ . delivery_aprox_notice2 AS delivery_aprox_notice2_207 , c14_ . delivery_aprox_notice3 AS delivery_aprox_notice3_208 , c14_ . delivery_aprox_notice4 AS delivery_aprox_notice4_209 , c14_ . delivery_aprox_notice5 AS delivery_aprox_notice5_210 , c14_ . delivery_aprox_notice6 AS delivery_aprox_notice6_211 , c14_ . delivery_aprox_notice7 AS delivery_aprox_notice7_212 , c14_ . delivery_firm_notice1 AS delivery_firm_notice1_213 , c14_ . delivery_firm_notice2 AS delivery_firm_notice2_214 , c14_ . delivery_firm_notice3 AS delivery_firm_notice3_215 , c14_ . delivery_firm_notice4 AS delivery_firm_notice4_216 , c14_ . delivery_firm_notice5 AS delivery_firm_notice5_217 , c14_ . delivery_firm_notice6 AS delivery_firm_notice6_218 , c14_ . delivery_firm_notice7 AS delivery_firm_notice7_219 , c14_ . delivery_notices_not_aplicable AS delivery_notices_not_aplicable_220 , c14_ . ship_delivered AS ship_delivered_221 , c14_ . hire_per_day AS hire_per_day_222 , c14_ . hire_per_day_currency AS hire_per_day_currency_223 , c14_ . period AS period_224 , c14_ . report_description AS report_description_225 , c14_ . vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_226 , c14_ . vessel_was_substituted AS vessel_was_substituted_227 , c14_ . addendum_issued AS addendum_issued_228 , c14_ . addendum_description AS addendum_description_229 , c14_ . created_at AS created_at_230 , c14_ . updated_at AS updated_at_231 , c15_ . id AS id_232 , c15_ . checklist_name AS checklist_name_233 , c15_ . notes AS notes_234 , c15_ . created_at AS created_at_235 , c15_ . updated_at AS updated_at_236 , t16_ . id AS id_237 , t16_ . task_name AS task_name_238 , t16_ . description AS description_239 , t16_ . task_index AS task_index_240 , t16_ . created_at AS created_at_241 , t16_ . updated_at AS updated_at_242 , p17_ . id AS id_243 , p17_ . port_name AS port_name_244 , p17_ . geographic_location AS geographic_location_245 , p17_ . cost_information_source AS cost_information_source_246 , p17_ . state AS state_247 , p17_ . country AS country_248 , p17_ . created_at AS created_at_249 , p17_ . updated_at AS updated_at_250 , p18_ . id AS id_251 , p18_ . port_name AS port_name_252 , p18_ . geographic_location AS geographic_location_253 , p18_ . cost_information_source AS cost_information_source_254 , p18_ . state AS state_255 , p18_ . country AS country_256 , p18_ . created_at AS created_at_257 , p18_ . updated_at AS updated_at_258 , d19_ . id AS id_259 , d19_ . notice_number AS notice_number_260 , d19_ . notice_type AS notice_type_261 , d19_ . notice_date AS notice_date_262 , d19_ . status AS status_263 , d19_ . created_at AS created_at_264 , d19_ . updated_at AS updated_at_265 , c20_ . id AS id_266 , c20_ . contract_number AS contract_number_267 , c20_ . contract_date AS contract_date_268 , c20_ . contract_type AS contract_type_269 , c20_ . laycan_start AS laycan_start_270 , c20_ . laycan_end AS laycan_end_271 , c20_ . status AS status_272 , c20_ . freight_cost AS freight_cost_273 , c20_ . freight_cost_currency AS freight_cost_currency_274 , c20_ . freight_type AS freight_type_275 , c20_ . demurrage_per_day AS demurrage_per_day_276 , c20_ . demurrage_per_day_currency AS demurrage_per_day_currency_277 , c20_ . address_commission AS address_commission_278 , c20_ . brokerage_commission AS brokerage_commission_279 , c20_ . liftings_min AS liftings_min_280 , c20_ . liftings_max AS liftings_max_281 , c20_ . checklist_notes AS checklist_notes_282 , c20_ . demurrage_status AS demurrage_status_283 , c20_ . demurrage_time_bar AS demurrage_time_bar_284 , c20_ . demurrage_payment_date AS demurrage_payment_date_285 , c20_ . final_demurrage_cost AS final_demurrage_cost_286 , c20_ . final_demurrage_cost_currency AS final_demurrage_cost_currency_287 , c20_ . demurrage_paid_by_charterer AS demurrage_paid_by_charterer_288 , c20_ . demurrage_paid_by_charterer_currency AS demurrage_paid_by_charterer_currency_289 , c20_ . eta_arrival AS eta_arrival_290 , c20_ . delivered_arrival AS delivered_arrival_291 , c20_ . delivery_aprox_notice1 AS delivery_aprox_notice1_292 , c20_ . delivery_aprox_notice2 AS delivery_aprox_notice2_293 , c20_ . delivery_aprox_notice3 AS delivery_aprox_notice3_294 , c20_ . delivery_aprox_notice4 AS delivery_aprox_notice4_295 , c20_ . delivery_aprox_notice5 AS delivery_aprox_notice5_296 , c20_ . delivery_aprox_notice6 AS delivery_aprox_notice6_297 , c20_ . delivery_aprox_notice7 AS delivery_aprox_notice7_298 , c20_ . delivery_firm_notice1 AS delivery_firm_notice1_299 , c20_ . delivery_firm_notice2 AS delivery_firm_notice2_300 , c20_ . delivery_firm_notice3 AS delivery_firm_notice3_301 , c20_ . delivery_firm_notice4 AS delivery_firm_notice4_302 , c20_ . delivery_firm_notice5 AS delivery_firm_notice5_303 , c20_ . delivery_firm_notice6 AS delivery_firm_notice6_304 , c20_ . delivery_firm_notice7 AS delivery_firm_notice7_305 , c20_ . delivery_notices_not_aplicable AS delivery_notices_not_aplicable_306 , c20_ . ship_delivered AS ship_delivered_307 , c20_ . hire_per_day AS hire_per_day_308 , c20_ . hire_per_day_currency AS hire_per_day_currency_309 , c20_ . period AS period_310 , c20_ . report_description AS report_description_311 , c20_ . vessel_arrived_within_the_laycan AS vessel_arrived_within_the_laycan_312 , c20_ . vessel_was_substituted AS vessel_was_substituted_313 , c20_ . addendum_issued AS addendum_issued_314 , c20_ . addendum_description AS addendum_description_315 , c20_ . created_at AS created_at_316 , c20_ . updated_at AS updated_at_317 , c0_ . vessel_id AS vessel_id_318 , c0_ . owner_id AS owner_id_319 , c0_ . charterer_id AS charterer_id_320 , c0_ . broker_id AS broker_id_321 , c0_ . operator_id AS operator_id_322 , c0_ . checklist_id AS checklist_id_323 , c0_ . delivery_port1_id AS delivery_port1_id_324 , c0_ . delivery_port2_id AS delivery_port2_id_325 , c0_ . contract_coa_id AS contract_coa_id_326 , v1_ . owner_id AS owner_id_327 , o2_ . primary_contact_id AS primary_contact_id_328 , u4_ . avatar_id AS avatar_id_329 , u5_ . avatar_id AS avatar_id_330 , a6_ . contract_id AS contract_id_331 , m7_ . contract_id AS contract_id_332 , p8_ . port_id AS port_id_333 , p8_ . contract_id AS contract_id_334 , r9_ . port_id AS port_id_335 , r9_ . contract_id AS contract_id_336 , r10_ . contract_id AS contract_id_337 , c11_ . cargo_id AS cargo_id_338 , c11_ . contract_id AS contract_id_339 , p12_ . contract_id AS contract_id_340 , h13_ . contract_id AS contract_id_341 , c14_ . vessel_id AS vessel_id_342 , c14_ . owner_id AS owner_id_343 , c14_ . charterer_id AS charterer_id_344 , c14_ . broker_id AS broker_id_345 , c14_ . operator_id AS operator_id_346 , c14_ . checklist_id AS checklist_id_347 , c14_ . delivery_port1_id AS delivery_port1_id_348 , c14_ . delivery_port2_id AS delivery_port2_id_349 , c14_ . contract_coa_id AS contract_coa_id_350 , t16_ . checklist_id AS checklist_id_351 , d19_ . contract_id AS contract_id_352 , c20_ . vessel_id AS vessel_id_353 , c20_ . owner_id AS owner_id_354 , c20_ . charterer_id AS charterer_id_355 , c20_ . broker_id AS broker_id_356 , c20_ . operator_id AS operator_id_357 , c20_ . checklist_id AS checklist_id_358 , c20_ . delivery_port1_id AS delivery_port1_id_359 , c20_ . delivery_port2_id AS delivery_port2_id_360 , c20_ . contract_coa_id AS contract_coa_id_361 FROM contract c0_ LEFT JOIN vessel v1_ ON c0_ . vessel_id = v1_ . id LEFT JOIN owner o2_ ON c0_ . owner_id = o2_ . id LEFT JOIN charterer c3_ ON c0_ . charterer_id = c3_ . id LEFT JOIN user u4_ ON c0_ . broker_id = u4_ . id LEFT JOIN user u5_ ON c0_ . operator_id = u5_ . id LEFT JOIN additional_cost a6_ ON c0_ . id = a6_ . contract_id LEFT JOIN media m7_ ON c0_ . id = m7_ . contract_id LEFT JOIN port_call p8_ ON c0_ . id = p8_ . contract_id LEFT JOIN reported_port r9_ ON c0_ . id = r9_ . contract_id LEFT JOIN reported_incident r10_ ON c0_ . id = r10_ . contract_id LEFT JOIN contract_cargo c11_ ON c0_ . id = c11_ . contract_id LEFT JOIN payment p12_ ON c0_ . id = p12_ . contract_id LEFT JOIN hire h13_ ON c0_ . id = h13_ . contract_id LEFT JOIN contract c14_ ON c0_ . id = c14_ . contract_coa_id LEFT JOIN checklist c15_ ON c0_ . checklist_id = c15_ . id LEFT JOIN contract_task c21_ ON c0_ . id = c21_ . contract_id LEFT JOIN task t16_ ON t16_ . id = c21_ . task_id LEFT JOIN port p17_ ON c0_ . delivery_port1_id = p17_ . id LEFT JOIN port p18_ ON c0_ . delivery_port2_id = p18_ . id LEFT JOIN delivery_notice d19_ ON c0_ . id = d19_ . contract_id LEFT JOIN contract c20_ ON c0_ . contract_coa_id = c20_ . id WHERE c0_ . id = '0764fa06-767c-45a1-8474-e54bc661528f' ;
Copy