From 20a05190275d3dce43061fad1d30f3d4847c8f1f Mon Sep 17 00:00:00 2001 From: Harald Eilertsen Date: Sat, 4 Sep 2021 21:00:28 +0200 Subject: 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. --- includes/concert.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 '; -- cgit v1.2.3