SELECT billing personal_account conn client_id conn conn_id to_char co

1
2
3
SELECT billing.personal_account(conn.client_id, conn.conn_id), to_char(conn.stage_date, 'DD.MM.YYYY'), ct.conn_values AS connection_date
FROM billing.connections AS conn, billing.conn_templ AS ct
WHERE conn.current_stage = 25 AND ct.conn_id = conn.conn_id AND ct.res_code = 'DATESTART';