Erro no banco de dados do WordPress: [Unknown column 'rand' in 'order clause']
SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_em_events.post_id FROM wp_em_events LEFT JOIN wp_em_locations ON wp_em_locations.location_id=wp_em_events.location_id WHERE (`event_status`=1) AND (`recurrence`!=1 OR `recurrence` IS NULL) AND (`event_private`=0) AND ( event_start_date <= CAST('2024-10-17' AS DATE) AND event_end_date >= CAST('2024-10-17' AS DATE) AND event_end_time > CAST('22:45:30' AS TIME) OR event_start_date = CAST('2024-10-17' AS DATE)) ORDER BY rand ASC LIMIT 30 OFFSET 0