Looks like Skeeve beat me to it:

my $big_sql = $dbh->prepare("SELECT sec.KEY, sec.TEST, sec.INSTANCE, s
+ec.ID, bt.key, bt.name, bt.state, stats.CCS, stats.kbps, stats.MBytes
+ from sec, bt, stats where sec.id = stats.id and stats.id = bt.id and
+ bt.id = ? and bt.hid = ?");
[download]

Which is untested but I guess is right for MySql. Also, you might want to make sure you have the ID field indexed on all of those tables as well as that HID.