INSERT INTO report_data (date, value, raw_row_number, kpi_report_id)
SELECT relevant_data.date, relevant_data.value, relevant_data.raw_row_number, kr.id
FROM
(SELECT date, value, raw_row_number, report_id
FROM report_data
JOIN
(SELECT *
FROM kpi_reports
WHERE kpi_id = 10250) AS kr
ON report_data.kpi_report_id = kr.id) AS relevant_data
JOIN (
SELECT *
FROM kpi_reports
WHERE kpi_id = 21268) AS kr
ON kr.report_id = relevant_data.report_id