SELECT
from_unixtime(qrpls.start_dt) AS Head_start, from_unixtime(qrpls.end_dt) AS Head_end,
qrplsl.exec_order, from_unixtime(qrplsl.from_dt) AS Lines_From, from_unixtime(qrplsl.to_dt) AS Lines_To,
qrpls.*, qrplsl.*, trn.*
FROM portaldb.qrpatrol_live_schedule qrpls
INNER JOIN portaldb.qrpatrol_live_schedule_lines qrplsl ON qrplsl.live_schedule_id = qrpls.id
LEFT OUTER JOIN portaldb.qrpartol_transactions trn ON trn.trn_id = qrplsl.tschres_ref_id
WHERE qrpls.cust_id = 2439 AND create_time BETWEEN '2015-05-01 16:30:01' AND '2015-05-10 16:30:01';