(ado_mssql): SELECT
g2_CheckoutTransaction.g_date,
g2_CheckoutTransaction.g_id,
g2_User.g_fullName,
g2_User.g_userName,
g2_CheckoutTransaction.g_recipientName,
g2_CheckoutTransaction.g_host,
g2_CheckoutTransaction.g_paymentPlugin,
g2_CheckoutTransaction.g_amount
FROM g2_CheckoutTransaction
INNER JOIN g2_User
ON g2_User.g_id = g2_CheckoutTransaction.g_buyerId
AND
g2_CheckoutTransaction.g_paymentPlugin IS NOT NULL
ORDER BY g2_CheckoutTransaction.g_date DESC