/* cleanup of credebtor_balances log */
DElETE FROM `credebtor_balances` WHERE is_last = 0;
OPTIMIZE TABLE `credebtor_balances`;

/* cleanup of sfws_api_log log */
DElETE FROM `sfws_api_log` WHERE request_date < "2022-01-01 00:00:00";
OPTIMIZE TABLE `sfws_api_log`;

/* cleanup of email_logs log */
DElETE FROM `email_logs` WHERE sent_date < "2022-01-01 00:00:00";
OPTIMIZE TABLE `email_logs`;

/* cleanup of activity_logs log */
DElETE FROM `activity_logs` WHERE created_at < "2022-01-01 00:00:00";
OPTIMIZE TABLE `activity_logs`;