select
pats_sites.site_name,
count(pats_stats.id) as raw_hits,
count(distinct pats_stats.ip_ad) as unique_hits,
sum(pats_sales.total_sales) as total_sales
from pats_sites
left join pats_stats on pats_stats.siteid = pats_sites.id 
left join pats_sales on pats_sales.siteid = pats_sites.id
where pats_stats.date_added >= 1172736000 and pats_stats.date_added <= 1173942000
group by pats_sites.id