*************************** 14. row *************************** Id: 2148906 User: spstats_write Host: munch3.ds.internal:50231 db: dsstats_spCommand: Query Time: 3762 State: Sending data Info: REPLACE INTO precalc_domain_month_200606 SELECT date_format(day, '%Y-%m') as month, a_id,o_id,domainname, sum(ulload) as visits, sum(if(c_code='US',1,0)*ulload) as us_visits, sum(uclick) as clicks, sum(usearch) as searches, sum(popcommission) as popunder_revenue, sum(commission) as search_revenue FROM domain_master FORCE INDEX (day) WHERE day >= date_format('2006-06-30', '%Y-%m-01') AND day <= last_day('2006-06-30') GROUP BY month,a_id,o_id,domainname*************************** 17. row *************************** Id: 2149059 User: spstats_write Host: munch3.ds.internal:50412 db: dsstats_spCommand: Query Time: 1957 State: Waiting for table Info: REPLACE INTO precalc_domain_200606 SELECT day,a_id,o_id,domainname, sum(ulload) as visits, sum(if(c_code='US',1,0)*ulload) as us_visits, sum(uclick) as clicks, sum(usearch) as searches, sum(popcommission) as popunder_revenue, sum(commission) as search_revenue FROM domain_master WHERE day='2006-06-24' GROUP BY day,a_id,o_id,domainname*************************** 24. row *************************** Id: 2150798 User: spstats_write Host: munch3.ds.internal:51704 db: dsstats_spCommand: Query Time: 159 State: Waiting for table Info: REPLACE INTO precalc_domain_200606 SELECT day,a_id,o_id,domainname, sum(ulload) as visits, sum(if(c_code='US',1,0)*ulload) as us_visits, sum(uclick) as clicks, sum(usearch) as searches, sum(popcommission) as popunder_revenue, sum(commission) as search_revenue FROM domain_master WHERE day='2006-06-30' GROUP BY day,a_id,o_id,domainname