This bug report requires the removal of all SQL queries from smart-rules.pl to perl modules in C4 and Koha directories. All of the subroutines created for the SQL queries in the C4 and Koha directories must have POD and unit tests.
I will try to get this in the future if I get more available time.