my $terms = $dbh->prepare(" SELECT date, term, appId, sum(impressions), sum(clicks) FROM ? WHERE appId = ? GROUP BY HOUR(date), term, appId; "); my $result = $terms->execute("`2010-07-22`", 3);