I can't think of any reasons for missing rows offhand.

Try fetching all of the data and dumping it, to confirm that DBI is really not providing it:

my $data = $dbh->selectall_arrayref($sql);
use Data::Dumper;
print STDERR Dumper($data);
[download]

If that still fails it is possible that some of the characters being copied + pasted from the debug output to your other interface are not being included (or included correctly).. but the query you reported wouldn't make that my first guess.