my $sth = $dbh->prepare( <<'__END_SQL__' );
SELECT smt.uniqueid
      ,smt.creationtime
      ,att.name
      ,att.val
      ,gsm.msisdn
  FROM dagenericsmt smt
  JOIN dagenericsmtattribute att ON smt.uniqueid = att.genericsmt_uniqueid
  JOIN dagsmproduct gsm ON smt.product_uniqueid = gsm.uniqueid
 WHERE smt.smtstatus  = ?
   AND smt.smtcommand = ?
   AND smt.acktime   IS NULL
   AND att.name      IN (?,?)
 ORDER BY smt.uniqueid
__END_SQL__

$sth->execute( 2, 3, 'GSM/Cur/IMSI', 'GSM/Rpl/IMSI' );