Reconciliation Task SQL Query for Reconciliation and Check File Date Comparison

SELECT\n reconciliation_task.*\nFROM\n reconciliation_task\nWHERE\n (status <> '1') AND\n (\n (\n reconciliation_status IN ('20', '27') AND\n reconciliation_date < check_file_date\n )\n OR\n (\n appointed_date <> '' AND\n appointed_date_reconciliation_status = '20' AND\n appointed_date_check_file_status = '13'\n )\n )