SELECT *
FROM payment_log
WHERE Pay_PaymentMethodID IN (2,16,17,27,31,32,33,34)
AND (PERIOD_DIFF(DATE_FORMAT(NOW(), '%Y%m'), DATE_FORMAT(Pay_AuthDate, '%Y%m')) = 1)