select this_.order_id as order1_839_0_, this_1_.uuid as uuid839_0_, this_1_.instructions as instruct3_839_0_, this_1_.start_date as start4_839_0_, this_1_.auto_expire_date as auto5_839_0_, this_1_.discontinued as disconti6_839_0_, this_1_.discontinued_date as disconti7_839_0_, this_1_.accession_number as accession8_839_0_, this_1_.date_created as date9_839_0_, this_1_.voided as voided839_0_, this_1_.date_voided as date11_839_0_, this_1_.void_reason as void12_839_0_, this_1_.concept_id as concept13_839_0_, this_1_.encounter_id as encounter14_839_0_, this_1_.patient_id as patient15_839_0_, this_1_.discontinued_reason as discont16_839_0_, this_1_.orderer as orderer839_0_, this_1_.voided_by as voided18_839_0_, this_1_.discontinued_by as discont19_839_0_, this_1_.creator as creator839_0_, this_1_.order_type_id as order21_839_0_, this_.lab_order_id as lab2_868_0_, this_.urgent as urgent868_0_, this_.retest_of as retest4_868_0_, this_.physician_retest as physician5_868_0_, this_.retest_reason as retest6_868_0_ from jsslab_order this_ inner join orders this_1_ on this_.order_id=this_1_.order_id where this_1_.uuid=?