on server 137
delimiter $$

CREATE TABLE `ft_stats_fed_101` (
  `ft_stats_date` date NOT NULL,
  `idtime_period` tinyint(3) unsigned NOT NULL DEFAULT '4',
  `imp_count` int(10) unsigned DEFAULT NULL,
  `clk_count` int(10) unsigned DEFAULT NULL,
  `spot_count` int(10) unsigned DEFAULT NULL,
  `srch_count` int(10) unsigned NOT NULL DEFAULT '0',
  `info_count` int(11) NOT NULL DEFAULT '0',
  `seg_count` int(10) unsigned NOT NULL DEFAULT '0',
  `info_errors` int(10) unsigned NOT NULL DEFAULT '0',
  `logsplit_bucket` tinyint(3) unsigned NOT NULL DEFAULT '255' COMMENT 'source log file bucket, 255 total',
  PRIMARY KEY (`ft_stats_date`,`idtime_period`,`logsplit_bucket`)
) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='mysql://XXXXXXXX:XXXXXXXA@XXX.XXX.XXX.101:3306/xre_release3/ft_stats_fed_101'

$$


on server 101
delimiter $$

CREATE TABLE `ft_stats_fed_101` (
  `ft_stats_date` date NOT NULL,
  `idtime_period` tinyint(3) unsigned NOT NULL DEFAULT '4',
  `imp_count` int(10) unsigned DEFAULT NULL,
  `clk_count` int(10) unsigned DEFAULT NULL,
  `spot_count` int(10) unsigned DEFAULT NULL,
  `srch_count` int(10) unsigned NOT NULL DEFAULT '0',
  `info_count` int(11) NOT NULL DEFAULT '0',
  `seg_count` int(10) unsigned NOT NULL DEFAULT '0',
  `info_errors` int(10) unsigned NOT NULL DEFAULT '0',
  `logsplit_bucket` tinyint(3) unsigned NOT NULL DEFAULT '255' COMMENT 'source log file bucket, 255 total',
  PRIMARY KEY (`ft_stats_date`,`idtime_period`,`logsplit_bucket`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

$$


query to run
SELECT imp_count,spot_count,clk_count,seg_count,info_errors,ft_stats_date,monthname(ft_stats_date) as mname FROM ft_stats_fed_101 where idtime_period = 4 and logsplit_bucket = 255 and ft_stats_date between '2011-01-20' and '2011-01-22'  order by ft_stats_date


GENERAL LOG OUTPUT
Run Through Fed

SELECT 
`ft_stats_date`, 
`idtime_period`, 
`imp_count`, 
`clk_count`, 
`spot_count`, 
`srch_count`, 
`info_count`, 
`seg_count`, 
`info_errors`, 
`logsplit_bucket` 
FROM `ft_stats_fed_101` 
WHERE  ( (`ft_stats_date` >= '2011-01-20')  AND  (`idtime_period` >= 4)  AND  (`logsplit_bucket` >= 255) )  AND ( (`ft_stats_date` >= '2011-01-22')  AND  (`idtime_period` >= 4)  AND  (`logsplit_bucket` <= 255) )

Run Direct

SELECT imp_count,
spot_count,
clk_count,
seg_count,
info_errors,
ft_stats_date,
monthname(ft_stats_date) as mname 
FROM ft_stats_fed_101 
where idtime_period = 4 
and logsplit_bucket = 255 
and ft_stats_date between '2011-01-20' and '2011-01-22'  
order by ft_stats_date