Unescaped parameter $list_table used in $wpdb->query($wpdb->prepare(\n "\n DELETE FROM $list_table\n WHERE warmed_at NOT IN (%s, '0000-00-00 00:00:00', '2000-01-01')\n ",\n $warm_up_start_date\n ))\n$list_table assigned unsafely at line 806:\n $list_table = DB::get_tables_prefix() . 'warm_ups_list'
Unescaped parameter $list_table used in $wpdb->query($wpdb->prepare(\n "\n DELETE FROM $list_table\n WHERE warmed_at < %s\n AND warmed_at NOT IN ('0000-00-00 00:00:00', '2000-01-01')\n ",\n $date_threshold\n ))\n$list_table assigned unsafely at line 806:\n $list_table = DB::get_tables_prefix() . 'warm_ups_list'
Unescaped parameter $list_table used in $wpdb->query($wpdb->prepare(\n "\n DELETE $list_table\n FROM $list_table\n INNER JOIN $logs_table ON $list_table.id = $logs_table.list_id\n WHERE $logs_table.log_date < %s\n AND $list_table.warmed_at = '0000-00-00 00:00:00'\n ",\n $date_threshold\n ))\n$list_table assigned unsafely at line 806:\n $list_table = DB::get_tables_prefix() . 'warm_ups_list'
Affected Plugins
Plugins that have instances of this rule violation
Unescaped parameter $list_table used in $wpdb->query($wpdb->prepare(\n "\n DELETE $list_table\n FROM $list_table\n INNER JOIN $logs_table ON $list_table.id = $logs_table.list_id\n WHERE $logs_table.log_date < %s\n AND $list_table.warmed_at = '2000-01-01 00:00:00'\n ",\n $date_threshold\n ))\n$list_table assigned unsafely at line 806:\n $list_table = DB::get_tables_prefix() . 'warm_ups_list'
Unescaped parameter $list_table used in $wpdb->get_results($wpdb->prepare(\n "\n SELECT \n t1.`date`,\n t1.`time`,\n t2.`time_after`\n FROM\n (\n SELECT\n $list_table.warmed_at as `date`,\n ROUND(AVG($logs_table.log_time_spent), 2) as `time`\n FROM\n $logs_table\n INNER JOIN\n $list_table ON $logs_table.list_id=$list_table.id\n WHERE\n $list_table.warmed_at > %s AND\n $logs_table.log_visit_type != 'after' AND\n $logs_table.log_time_spent IS NOT NULL\n GROUP BY\n $list_table.warmed_at\n ) as t1\n LEFT JOIN\n (\n SELECT\n `date`,\n ROUND(AVG(avg_log_time), 2) as `time_after`\n FROM (\n SELECT\n $list_table.warmed_at as `date`,\n $logs_table.log_time_afterwards as avg_log_time\n FROM\n $logs_table\n INNER JOIN\n $list_table ON $logs_table.list_id=$list_table.id\n WHERE\n $list_table.warmed_at > %s AND\n $logs_table.log_visit_type != 'after' AND\n $logs_table.log_time_spent IS NOT NULL AND\n $logs_table.log_time_afterwards IS NOT NULL\n \n UNION ALL\n \n SELECT\n $list_table.warmed_at as `date`,\n $logs_table.log_time_spent as avg_log_time\n FROM\n $logs_table\n INNER JOIN\n $list_table ON $logs_table.list_id=$list_table.id\n WHERE\n $list_table.warmed_at > %s AND\n $logs_table.log_visit_type = 'after' AND\n $logs_table.log_time_spent IS NOT NULL\n ) as t\n GROUP BY `date`\n ) as t2\n ON t1.`date` = t2.`date`\n WHERE\n t2.`time_after` IS NOT NULL\n ",\n $min_date,\n $min_date,\n $min_date\n ))\n$list_table assigned unsafely at line 63:\n $list_table = DB::get_tables_prefix() . 'warm_ups_list'