mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-01' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-02' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-03' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-04' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-05' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-06' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-07' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-08' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-09' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-10' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-11' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-12' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-13' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-14' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-15' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-16' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-17' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-18' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-19' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-20' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-21' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-22' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-23' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-24' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-25' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-26' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-27' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-28' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-29' GROUP BY _subnet, user_id " >/dev/null 
mysql --database=contention1821 -e "SELECT _subnet, user_id, sum(stat_a), sum(stat_b) FROM stats INNER JOIN domain ON domain_id = domain.id INNER JOIN creative ON creative_id = creative.id WHERE date = '2023-01-30' GROUP BY _subnet, user_id " >/dev/null