INSERT INTO `k9ti_affiliate_reports_archive` (`id`, `utc_date`, `aff_id`, `tid1`, `tid2`, `tid3`, `tid4`, `total_clicks`, `total_leads`, `total_sales`, `total_commissions`) SELECT `id`, `utc_date`, `aff_id`, `tid1`, `tid2`, `tid3`, `tid4`, `total_clicks`, `total_leads`, `total_sales`, `total_commissions` FROM `k9ti_affiliate_reports` WHERE `utc_date` <= '2024-03-19'