WordPress database error

WordPress database error:

[You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘rows, ref AS reference, SUM(creds) AS total, MAX(time) AS last_entry FROM wp_myC’ at line 1]

SELECT COUNT(*) AS rows, ref AS reference, SUM(creds) AS total, MAX(time) AS last_entry FROM wp_myCRED_log WHERE user_id = 9 AND ctype = ‘mycred_default’ GROUP BY ref ORDER BY rows DESC;

While creating a woocommerce order as a guest with create account checkbox enabled.

The page I need help with: [log in to see the link]