SELECT
 h.hexID AS hexID,
 h.position AS position,
 COALESCE(hexesOfInterest.name, NULL) AS name,
  
 COALESCE(hexesOfInterest.fillColour, "") AS fillColour,
 COALESCE(hexesOfInterest.gradientColour, NULL) AS gradientColour,
 COALESCE(hexesOfInterest.fillTransparancy, 0) AS fillTransparancy,
 COALESCE(hexesOfInterest.borderTransparancy, 0.1) AS borderTransparancy,
 COALESCE(hexesOfInterest.borderThickness, 1) AS borderThickness,
 COALESCE(hexesOfInterest.severity, 0) AS severity,
  
 COALESCE(hexesOfInterest.metric1name, "") AS metric1name,
 COALESCE(hexesOfInterest.metric2name, "") AS metric2name,
 COALESCE(hexesOfInterest.metric1value, "") AS metric1value,
 COALESCE(hexesOfInterest.metric2value, "") AS metric2value,
  
 COALESCE(hexesOfInterest.flow1, 0) AS flow1,
 COALESCE(hexesOfInterest.flow1Highlight, 0) AS flow1Highlight,
 COALESCE(hexesOfInterest.flow1HighlightColour, "255,255,255") AS flow1HighlightColour,
 COALESCE(hexesOfInterest.flow2, 0) AS flow2,
 COALESCE(hexesOfInterest.flow2Highlight, 0) AS flow2Highlight,
 COALESCE(hexesOfInterest.flow2HighlightColour, "255,255,255") AS flow2HighlightColour,
 COALESCE(hexesOfInterest.flow3, 0) AS flow3,
 COALESCE(hexesOfInterest.flow3Highlight, 0) AS flow3Highlight,
 COALESCE(hexesOfInterest.flow3HighlightColour, "255,255,255") AS flow3HighlightColour,
 COALESCE(hexesOfInterest.flow4, 0) AS flow4,
 COALESCE(hexesOfInterest.flow4Highlight, 0) AS flow4Highlight,
 COALESCE(hexesOfInterest.flow4HighlightColour, "255,255,255") AS flow4HighlightColour,
 COALESCE(hexesOfInterest.flow5, 0) AS flow5,
 COALESCE(hexesOfInterest.flow5Highlight, 0) AS flow5Highlight,
 COALESCE(hexesOfInterest.flow5HighlightColour, "255,255,255") AS flow5HighlightColour,
 COALESCE(hexesOfInterest.flow6, 0) AS flow6,
 COALESCE(hexesOfInterest.flow6Highlight, 0) AS flow6Highlight,
 COALESCE(hexesOfInterest.flow6HighlightColour, "255,255,255") AS flow6HighlightColour,
  
 COALESCE(hexesOfInterest.error1Severity, 0) AS error1Severity,
 COALESCE(hexesOfInterest.error1, "") AS error1,
 COALESCE(hexesOfInterest.error2Severity, 0) AS error2Severity,
 COALESCE(hexesOfInterest.error2, "") AS error2,
 COALESCE(hexesOfInterest.error3Severity, 0) AS error3Severity,
 COALESCE(hexesOfInterest.error3, "") AS error3,
 COALESCE(hexesOfInterest.error4Severity, 0) AS error4Severity,
 COALESCE(hexesOfInterest.error4, "") AS error4
  
FROM
(
 SELECT * FROM
 (
  
 SELECT 1 AS hexID, "1A" AS position, "1A" AS name
 UNION SELECT 2 AS hexID, "2A" AS position, "2A" AS name
 UNION SELECT 3 AS hexID, "3A" AS position, "3A" AS name
 UNION SELECT 4 AS hexID, "4A" AS position, "4A" AS name
 UNION SELECT 5 AS hexID, "5A" AS position, "5A" AS name
 UNION SELECT 6 AS hexID, "6A" AS position, "6A" AS name
 UNION SELECT 7 AS hexID, "7A" AS position, "7A" AS name
 UNION SELECT 8 AS hexID, "8A" AS position, "8A" AS name
 UNION SELECT 9 AS hexID, "9A" AS position, "9A" AS name
 UNION SELECT 10 AS hexID, "10A" AS position, "10A" AS name
 UNION SELECT 11 AS hexID, "11A" AS position, "11A" AS name
 UNION SELECT 12 AS hexID, "12A" AS position, "12A" AS name
 UNION SELECT 13 AS hexID, "13A" AS position, "13A" AS name
 UNION SELECT 14 AS hexID, "14A" AS position, "14A" AS name
 UNION SELECT 15 AS hexID, "1B" AS position, "1B" AS name
 UNION SELECT 16 AS hexID, "2B" AS position, "2B" AS name
 UNION SELECT 17 AS hexID, "3B" AS position, "3B" AS name
 UNION SELECT 18 AS hexID, "4B" AS position, "4B" AS name
 UNION SELECT 19 AS hexID, "5B" AS position, "5B" AS name
 UNION SELECT 20 AS hexID, "6B" AS position, "6B" AS name
 UNION SELECT 21 AS hexID, "7B" AS position, "7B" AS name
 UNION SELECT 22 AS hexID, "8B" AS position, "8B" AS name
 UNION SELECT 23 AS hexID, "9B" AS position, "9B" AS name
 UNION SELECT 24 AS hexID, "10B" AS position, "10B" AS name
 UNION SELECT 25 AS hexID, "11B" AS position, "11B" AS name
 UNION SELECT 26 AS hexID, "12B" AS position, "12B" AS name
 UNION SELECT 27 AS hexID, "13B" AS position, "13B" AS name
 UNION SELECT 28 AS hexID, "14B" AS position, "14B" AS name
 UNION SELECT 29 AS hexID, "1C" AS position, "1C" AS name
 UNION SELECT 30 AS hexID, "2C" AS position, "2C" AS name
 UNION SELECT 31 AS hexID, "3C" AS position, "3C" AS name
 UNION SELECT 32 AS hexID, "4C" AS position, "4C" AS name
 UNION SELECT 33 AS hexID, "5C" AS position, "5C" AS name
 UNION SELECT 34 AS hexID, "6C" AS position, "6C" AS name
 UNION SELECT 35 AS hexID, "7C" AS position, "7C" AS name
 UNION SELECT 36 AS hexID, "8C" AS position, "8C" AS name
 UNION SELECT 37 AS hexID, "9C" AS position, "9C" AS name
 UNION SELECT 38 AS hexID, "10C" AS position, "10C" AS name
 UNION SELECT 39 AS hexID, "11C" AS position, "11C" AS name
 UNION SELECT 40 AS hexID, "12C" AS position, "12C" AS name
 UNION SELECT 41 AS hexID, "13C" AS position, "13C" AS name
 UNION SELECT 42 AS hexID, "14C" AS position, "14C" AS name
 UNION SELECT 43 AS hexID, "1D" AS position, "1D" AS name
 UNION SELECT 44 AS hexID, "2D" AS position, "2D" AS name
 UNION SELECT 45 AS hexID, "3D" AS position, "3D" AS name
 UNION SELECT 46 AS hexID, "4D" AS position, "4D" AS name
 UNION SELECT 47 AS hexID, "5D" AS position, "5D" AS name
 UNION SELECT 48 AS hexID, "6D" AS position, "6D" AS name
 UNION SELECT 49 AS hexID, "7D" AS position, "7D" AS name
 UNION SELECT 50 AS hexID, "8D" AS position, "8D" AS name
 UNION SELECT 51 AS hexID, "9D" AS position, "9D" AS name
 UNION SELECT 52 AS hexID, "10D" AS position, "10D" AS name
 UNION SELECT 53 AS hexID, "11D" AS position, "11D" AS name
 UNION SELECT 54 AS hexID, "12D" AS position, "12D" AS name
 UNION SELECT 55 AS hexID, "13D" AS position, "13D" AS name
 UNION SELECT 56 AS hexID, "14D" AS position, "14D" AS name
 UNION SELECT 57 AS hexID, "1E" AS position, "1E" AS name
 UNION SELECT 58 AS hexID, "2E" AS position, "2E" AS name
 UNION SELECT 59 AS hexID, "3E" AS position, "3E" AS name
 UNION SELECT 60 AS hexID, "4E" AS position, "4E" AS name
 UNION SELECT 61 AS hexID, "5E" AS position, "5E" AS name
 UNION SELECT 62 AS hexID, "6E" AS position, "6E" AS name
 UNION SELECT 63 AS hexID, "7E" AS position, "7E" AS name
 UNION SELECT 64 AS hexID, "8E" AS position, "8E" AS name
 UNION SELECT 65 AS hexID, "9E" AS position, "9E" AS name
 UNION SELECT 66 AS hexID, "10E" AS position, "10E" AS name
 UNION SELECT 67 AS hexID, "11E" AS position, "11E" AS name
 UNION SELECT 68 AS hexID, "12E" AS position, "12E" AS name
 UNION SELECT 69 AS hexID, "13E" AS position, "13E" AS name
 UNION SELECT 70 AS hexID, "14E" AS position, "14E" AS name
  
 ) listhexes
 ORDER BY hexID
) h
LEFT OUTER JOIN
(
 SELECT
  "2A" AS ofintrest,
  "Name" AS name,
  1 AS severity,
   
  "63,104,232" AS fillColour, "33,81,97" AS gradientColour, 0.3 AS fillTransparancy,
  0 AS borderTransparancy, 1 AS borderThickness,
   
  "" AS metric1name, "" AS metric1value,
  "" AS metric2name, "" AS metric2value,
   
  0 AS flow1, 0 AS flow1Highlight, "255,255,255" AS flow1HighlightColour,
  0 AS flow2, 0 AS flow2Highlight, "255,255,255" AS flow2HighlightColour,
  0 AS flow3, 0 AS flow3Highlight, "255,255,255" AS flow3HighlightColour,
  0 AS flow4, 0 AS flow4Highlight, "255,255,255" AS flow4HighlightColour,
  0 AS flow5, 0 AS flow5Highlight, "255,255,255" AS flow5HighlightColour,
  0 AS flow6, 0 AS flow6Highlight, "255,255,255" AS flow6HighlightColour,
   
  2 AS error1Severity, "" AS error1,
  2 AS error2Severity, "" AS error2,
  2 AS error3Severity, "" AS error3,
  2 AS error4Severity, "" AS error4
   
) hexesOfInterest ON h.position = hexesOfInterest.ofintrest