WITH max_value AS (SELECT max(value)
FROM kpi_value_definitions
WHERE kpi_id = 20270)
SELECT report_data.id, report_data.date, report_data.raw_row_number, kpi_reports.report_id, kpi_reports.kpi_id, report_data.value, 'Mobile usage value out of range' AS error_message
FROM report_data
JOIN kpi_reports ON report_data.kpi_report_id = kpi_reports.id AND kpi_reports.kpi_id = 20270 AND report_data.value < 1 OR report_data.value > max_value