summaryrefslogtreecommitdiffstats
path: root/includes
diff options
context:
space:
mode:
authorHarald Eilertsen <haraldei@anduin.net>2021-09-04 21:00:28 +0200
committerHarald Eilertsen <haraldei@anduin.net>2021-09-04 21:00:28 +0200
commit20a05190275d3dce43061fad1d30f3d4847c8f1f (patch)
tree00eb5d471ac0260d1b0bb69607e07ea3e84ef2e3 /includes
parent15bf6674a36582d2ae736bfec651239884b9cab5 (diff)
downloadgigologadmin-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.
Diffstat (limited to 'includes')
-rw-r--r--includes/concert.php2
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 ';