Start by linking the nmsaddress to the nmsdelivery tables and differentiate which templates are used by MC through on deliveryId foreign keys, you can also group which addresses fell in the blacklist from all the different transactional templates/deliveries.
The following should get you started, start learning how the SQL tables are joined.
SELECT top 201 A0.iAddressId, A0.sAddress, A0.iType, A0.iStatus, A0.iQuarantineReason, A0.tsLastModified, A0.tsCreated, $(pfx)GetEmailDomain(A0.sAddress), A0.mQuarantineText, A0.iDeliveryId, A0.tsLastError, A0.iConsecutiveError, D1.sInternalName
FROM NmsAddress A0 LEFT JOIN NmsDelivery D1 ON (D1.iDeliveryId = A0.iDeliveryId)
ORDER BY A0.tsLastModified DESC, A0.iAddressId