Error: SELECT DATE(e.data) as e_data, YEAR(e.data) as e_year, MONTH(e.data) as e_month, DAY(e.data) as e_day, e.id_event as e_id_event, e.genre as e_genre, e.theme_genre as e_theme_genre, e.show_in_home as e_show_in_home, e.publish as e_publish, g.title as g_title, g.longtitle as g_longtitle, g.description as g_description, g.photo as g_photo, g.fk_event, g.genre as pub_genre FROM SBSX_events AS e JOIN SBSX_pubblications AS g ON e.id_event = g.fk_event WHERE genre="genre_news" ORDER BY data DESC LIMIT 0,10

Column 'genre' in where clause is ambiguous