Errore sul database di WordPress: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND u2.meta_key = 'wp_capabilities' AND u2.meta_value = 'a:1:{s:7:\"um_tata\";' at line 39]
SELECT u7.display_name, u11.meta_value AS richiesta_disponibilita, u7.ID AS user_id, u8.meta_value AS first_name, u10.meta_value AS descrizione, TIMESTAMPDIFF(YEAR, DATE(u4.meta_value), CURDATE()) AS data_nascita, IFNULL(eventi_avg.prezzo_medio, 0) AS prezzo_medio, IFNULL( CONCAT(' basato su ', rating_summary.total_rating, CASE WHEN rating_summary.total_rating = 1 THEN ' recensione' ELSE ' recensioni' END ), 'Nessuna recensione' ) AS avg_rating, u1.meta_value AS comune, IFNULL(u12.meta_value, '') AS profile_photo, u9.denominazione_ita FROM wp_usermeta u1 JOIN wp_usermeta u2 ON u1.user_id = u2.user_id JOIN wp_users u7 ON u1.user_id = u7.ID LEFT JOIN wp_glsr_assigned_users u5 ON u1.user_id = u5.user_id JOIN wp_usermeta u8 ON u1.user_id = u8.user_id AND u8.meta_key = 'first_name' LEFT JOIN wp_usermeta u11 ON u1.user_id = u11.user_id AND u11.meta_key = 'richiesta_disponibilita' JOIN gi_comuni u9 ON u1.meta_value = u9.codice_istat JOIN wp_usermeta u4 ON u1.user_id = u4.user_id AND u4.meta_key = 'birth_date' JOIN wp_usermeta u10 ON u1.user_id = u10.user_id AND u10.meta_key = 'description' LEFT JOIN wp_usermeta u12 ON u1.user_id = u12.user_id AND u12.meta_key = 'profile_photo' LEFT JOIN ( SELECT user_id, ROUND(AVG(prezzo), 1) AS prezzo_medio FROM wp_eventi WHERE data_inizio > NOW() AND prenotato = 0 GROUP BY user_id ) eventi_avg ON eventi_avg.user_id = u1.user_id LEFT JOIN ( SELECT au.user_id, COUNT(r.rating) AS total_rating FROM wp_glsr_assigned_users au JOIN wp_glsr_ratings r ON au.rating_id = r.ID GROUP BY au.user_id ) rating_summary ON rating_summary.user_id = u1.user_id WHERE u1.meta_key = 'comune' AND u1.meta_value IN () AND u2.meta_key = 'wp_capabilities' AND u2.meta_value = 'a:1:{s:7:\"um_tata\";b:1;}' GROUP BY u7.display_name, u11.meta_value, u7.ID, u8.meta_value, u10.meta_value, u4.meta_value, u1.meta_value, u9.denominazione_ita, u12.meta_value, eventi_avg.prezzo_medio, rating_summary.total_rating