Morosi

Debug Query SQL:

SELECT
                tm.transaction_id,
                tm.meta_value as year_conf_data,
                t.user_id,
                u.user_email,
                (SELECT meta_value FROM wp_usermeta WHERE user_id = t.user_id AND meta_key = 'first_name' LIMIT 1) as first_name,
                (SELECT meta_value FROM wp_usermeta WHERE user_id = t.user_id AND meta_key = 'last_name' LIMIT 1) as last_name
            FROM wp_mepr_transaction_meta tm
            INNER JOIN wp_mepr_transactions t ON tm.transaction_id = t.id
            INNER JOIN wp_users u ON t.user_id = u.ID
            WHERE tm.meta_key = 'year_conf_data'
            AND tm.meta_value LIKE '%\"year\":\"26-27\"%'
            ORDER BY tm.id DESC