WordPress database error: [Table 'demo1.mm_transaction_log' doesn't exist]
SELECT
o.id as orderId,
o.order_number as orderNumber,
t.id as mmTransId,
t.is_test,
o.user_id,
t.order_item_id,
t.transaction_date as date,
ifnull(oi.description,'multiple products') as productName,
oi.item_id as productId,
oi.recurring_discount as recurringDiscount,
t.amount,
t.currency,
t.transaction_type as transType,
ps.name as pymtServiceName,
ps.token as pymtServiceToken,
o.affiliate_id as affiliateId,
o.sub_affiliate_id as subAffiliateId,
if(((t.refund_id IS NOT NULL)
AND (t.transaction_type != 5)),true,false) as isRefunded
FROM
mm_transaction_log t
LEFT JOIN mm_payment_services ps on (t.payment_service_id = ps.id)
LEFT JOIN mm_orders o on (t.order_id = o.id)
LEFT JOIN mm_order_items oi on (t.order_item_id = oi.id)
WHERE
(t.transaction_type IN (2,4,5))
AND (o.user_id = '0')
ORDER BY
date desc
You currently have no transaction history to display.