my $sth = $dbh->prepare( qq|SELECT requests.id, requests.name, requests.requestor, 
        requestors.name, requestors.email FROM requests LEFT JOIN 
        requestors ON requests.requestor = requestor.id| );
my $list = $sth->fetchall_arrayref({});