The table `tbl_capture_efficiencey` has 1777 records but the view `viw_capture_efficiency_full` has 1778. Likely an issue with one of the joins.
The table
tbl_capture_efficienceyhas 1777 records but the viewviw_capture_efficiency_fullhas 1778. Likely an issue with one of the joins.