SELECT evt.event_date AS "Event Date", 
 evt.description AS "Description",    (
      SELECT event_type_attribute_value
      FROM event_details
      WHERE event_id = evt.id
         AND event_type_attribute_id = 1
   ) AS "Home Team",
   (
      SELECT event_type_attribute_value
      FROM event_details
      WHERE event_id = evt.id
         AND event_type_attribute_id = 2
   ) AS "Visiting Team",
   (
      SELECT event_type_attribute_value
      FROM event_details
      WHERE event_id = evt.id
         AND event_type_attribute_id = 3
   ) AS "Line"
FROM events evt
WHERE event_type_id = 1