Шедевр мысли

$request="select f.date, f.circuit_n, f.route_n, f.q_index, "
." y.order_id, y.repeat, f.deleted, f.ready"
." from files f left outer join "
." (select o.order_id, r.repeat, o.circuit_no from orders o, records r"
." where o.order_id = r.order_id)"
." as y on f.circuit_n = y.circuit_no";