SELECT
arx_stat_reprint.*
FROM
arx_stat_reprint,
arx_points,
(SELECT
part_key,
move_id
FROM
move_arx_ext
WHERE
part_key >= $5 AND part_key <= ($4 + date_range * INTERVAL '1 day')
) arx_ext
WHERE
arx_stat_reprint.point_id = arx_points.point_id AND
arx_points.pr_del >= 0 AND
arx_points.airp = $1 AND
arx_points.flt_no = $2 AND
arx_points.part_key = arx_stat_reprint.part_key AND
arx_points.part_key = arx_ext.part_key AND
arx_points.move_id = arx_ext.move_id AND
arx_stat_reprint.scd_out >= $3 AND arx_stat_reprint.scd_out < $4;