select 
uri_id, uid_site, count(uri_id) as count
from stat_request where 
date >= '1087243200'  and uid_site in ( 910013 , 3735 , 13 ) 
group by uid_site, uri_id having count >  1 

table | type | possible_keys | key | rows | Extra
stat_request| ALL | date | |  75637  | Using where; Using temporary; Using filesort

# Query_time:  29   Lock_time:  0   Rows_sent:  5416   Rows_examined:  98472 
select 
uri_id, uid_site, count(uri_id) as count 
from stat_request where 
date >= '1087243200' and uid_site in ( 910013 , 3735 , 13 )
group by uid_site, uri_id having count >  1 ;

CREATE TABLE stat_request (
  session_id bigint( 16 ) NOT NULL default '0',
  uri_id char( 255 ) NOT NULL default '0',
  date int( 10 ) NOT NULL default '0',
  ip_id char( 15 ) NOT NULL default '0',
  uid_site int( 10 ) default NULL,
  KEY session_id (session_id),
  KEY uri_id (uri_id),
  KEY date (date),
  KEY ip_id (ip_id)
) TYPE=MyISAM;