WordPress-Datenbank-Fehler: [Unknown column 'town' in 'field list']
SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_em_events.post_id
FROM (
SELECT wp_em_events.*,
@cur := IF(town = @id, @cur+1, 1) AS RowNumber,
@id := town AS IdCache
FROM wp_em_events
INNER JOIN (
SELECT @id:=0, @cur:=0
) AS lookup
WHERE (`event_status`=1) AND (`recurrence`!=1 OR `recurrence` IS NULL) AND ( event_start >= '2024-11-23 21:17:12' OR (event_end >= '2024-11-23 21:17:12')) AND (`event_private`=0)
ORDER BY town , town ASC
) wp_em_events
WHERE RowNumber = 1
ORDER BY event_start_date DESC, event_start_time DESC, event_name DESC
LIMIT 10 OFFSET 0