EDIT

BEGIN {

    REJECTED_STATUS_ID=6

    CLOSED_STATUS_ID=5

}

NR>1{ 

 print "UPDATE issues SET status_id="REJECTED_STATUS_ID" WHERE ID="$0";" > "fix-tickets-status.sql" 

 print "SET @ID = (select jd.id FROM journal_details jd join  journals j on j.id=jd.journal_id where j.journalized_id = "$0" AND prop_key = 'status_id' AND property='attr' AND value="CLOSED_STATUS_ID" order by j.created_on DESC LIMIT 1); UPDATE journal_details SET value="REJECTED_STATUS_ID" WHERE id = @ID;" > "fix-tickets-status.sql" 

}