diff options
| author | Harald Eilertsen <haraldei@anduin.net> | 2021-09-04 21:00:28 +0200 |
|---|---|---|
| committer | Harald Eilertsen <haraldei@anduin.net> | 2021-09-04 21:00:28 +0200 |
| commit | 20a05190275d3dce43061fad1d30f3d4847c8f1f (patch) | |
| tree | 00eb5d471ac0260d1b0bb69607e07ea3e84ef2e3 | |
| parent | 15bf6674a36582d2ae736bfec651239884b9cab5 (diff) | |
| download | gigologadmin-20a05190275d3dce43061fad1d30f3d4847c8f1f.tar.gz gigologadmin-20a05190275d3dce43061fad1d30f3d4847c8f1f.tar.bz2 gigologadmin-20a05190275d3dce43061fad1d30f3d4847c8f1f.zip | |
Drop extra query for venue_id in concert queries.
It's not required since the id is in the concerts table too. That's what
links them together.
| -rw-r--r-- | includes/concert.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/includes/concert.php b/includes/concert.php index a533679..29de015 100644 --- a/includes/concert.php +++ b/includes/concert.php @@ -31,7 +31,7 @@ if ( !class_exists('GiglogAdmin_Concert') ) { public const STATUS_REJECTED = 5; private const BASE_QUERY = - 'SELECT wpg_concerts.*, wpg_venues.id as venue_id, wpg_venues.wpgvenue_name wpg_venues_wpgvenue_city ' + 'SELECT wpg_concerts.*, wpg_venues.wpgvenue_name wpg_venues_wpgvenue_city ' . 'FROM wpg_concerts ' . 'LEFT JOIN wpg_venues ON wpg_concerts.venue = wpg_venues.id '; |