*************************** 14. row ***************************
     Id: 2148906
   User: spstats_write
   Host: munch3.ds.internal:50231
     db: dsstats_sp
Command: 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_sp
Command: 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_sp
Command: 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