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 'GROUP BY t.term_id ORDER BY tm.meta_value+0 ASC, t.name ASC' at line 1]
SELECT DISTINCT t.*, tt.term_taxonomy_id, tt.term_id, tt.taxonomy, tt.description, tt.parent, COUNT(t.term_id) AS count, tm.meta_value FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS r ON r.term_taxonomy_id = tt.term_taxonomy_id INNER JOIN wp_posts AS p ON p.ID = r.object_id LEFT JOIN wp_termmeta AS tm ON (t.term_id = tm.term_id AND tm.meta_key = 'order') WHERE tt.taxonomy IN ('product_cat') AND p.post_type IN ('post','page','product','events') GROUP BY t.term_id GROUP BY t.term_id ORDER BY tm.meta_value+0 ASC, t.name ASC
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 'GROUP BY t.term_id ORDER BY tm.meta_value+0 ASC, t.name ASC' at line 1]SELECT DISTINCT t.*, tt.term_taxonomy_id, tt.term_id, tt.taxonomy, tt.description, tt.parent, COUNT(t.term_id) AS count, tm.meta_value FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS r ON r.term_taxonomy_id = tt.term_taxonomy_id INNER JOIN wp_posts AS p ON p.ID = r.object_id LEFT JOIN wp_termmeta AS tm ON (t.term_id = tm.term_id AND tm.meta_key = 'order') WHERE tt.taxonomy IN ('product_cat') AND p.post_type IN ('post','page','product','events') GROUP BY t.term_id GROUP BY t.term_id ORDER BY tm.meta_value+0 ASC, t.name ASC