Changes between Version 30 and Version 31 of QueryOptimization

Timestamp:

05/09/26 16:54:21 (2 weeks ago)

Author:

231027

Comment:

--

QueryOptimization

@@ -78 +78 @@
        u.username,
        t.ticket_id,
+       e.event_id,
+       e.name AS event_name,
        tp.purchase_id,
        tp.qr_code,
@@ -85 +87 @@
 JOIN "Ticket_Purchase" tp ON u.user_id = tp.user_id
 JOIN "Ticket" t ON tp.ticket_id = t.ticket_id
+JOIN "Event_Happening" eh ON t.event_happening_id = eh.event_happening_id
+JOIN "Event" e ON eh.event_id = e.event_id
 LEFT JOIN "Ticket_Refund" tr ON tp.purchase_id = tr.purchase_id;