my $sth = $dbh->prepare(q~
    select
        smt.uniqueid, smt.creationtime, att.name, att.val, gsm.msisdn
    from
        dagenericsmt smt, dagenericsmtattribute att, dagsmproduct gsm
    where smt.uniqueid = att.genericsmt_uniqueid
        and smt.product_uniqueid = gsm.uniqueid
        and smt.smtstatus=2
        and smt.smtcommand=3
        and att.name in ('GSM/Cur/IMSI','GSM/Rpl/IMSI')
        and smt.acktime is null order by smt.uniqueid
~)