diff options
Diffstat (limited to 'includes/concert.php')
| -rw-r--r-- | includes/concert.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/includes/concert.php b/includes/concert.php index d749e67..996d79e 100644 --- a/includes/concert.php +++ b/includes/concert.php @@ -189,7 +189,7 @@ if ( !class_exists('GiglogAdmin_Concert') ) { $query = "SELECT {$ct}.*, {$vt}.wpgvenue_name, {$vt}.wpgvenue_city "; } - $query .= "FROM {$ct} LEFT JOIN {$vt} ON {$ct}.venue = {$vt}.id "; + $query .= "FROM {$ct} LEFT JOIN {$vt} ON {$ct}.venue = {$vt}.id WHERE wpgconcert_date >= CURRENT_TIMESTAMP"; $keymap = [ 'id' => $wpdb->prefix . 'giglogadmin_concerts.id', @@ -234,7 +234,7 @@ if ( !class_exists('GiglogAdmin_Concert') ) { } if ( ! empty( $where ) ) { - $query .= 'WHERE ' . implode(' and ', $where); + $query .= 'AND ' . implode(' and ', $where); } $query .= ' ORDER BY wpgconcert_date'; |