Multiple Column Min Date Aggregation, MySQL

Language: Layout:

DROP TABLE IF EXISTS myTable;
DROP TABLE IF EXISTS myLongTable;

CREATE TABLE myTable (
  ID INTEGER AUTO_INCREMENT PRIMARY KEY,
  organisation VARCHAR(20),
  A DATE,
  B DATE,
  C DATE,
  D DATE
);

INSERT INTO myTable(organisation, A, B, C, D)
VALUES ('Ikea', '2018-04-01', '2018-05-07', '2018-05-09', '2018-05-01'),
       ('Ikea', '2018-06-01', '2018-05-03', '2018-05-29', NULL),
       ('Orange', '2018-04-02', '2018-05-01', '2018-07-08', '2018-05-26'),
       ('Ikea', '2018-06-02', '2018-05-01', NULL, '2018-05-26'),
       ('Nestle', '2018-06-02', '2018-05-01', NULL, '2018-05-26'),
       ('Ikea', NULL, '2018-05-05', '2018-04-02', '2018-06-01');

CREATE TABLE myLongTable AS
SELECT t.* 
FROM 
  (SELECT ID, organisation, 'A' As 'Category', A As `DateValue` FROM myTable
   UNION ALL
   SELECT ID, organisation, 'B' As 'Category', B As `DateValue` FROM myTable
   UNION ALL
   SELECT ID, organisation, 'C' As 'Category', C As `DateValue` FROM myTable
   UNION ALL
   SELECT ID, organisation, 'D' As 'Category', D As `DateValue` FROM myTable) As t;

SELECT m.*
FROM myTable m
INNER JOIN 
   (SELECT t.ID, MIN(t.`DateValue`) As MinDate
    FROM myLongTable As t
    WHERE t.organisation = 'Ikea'
    GROUP BY t.ID
    HAVING MIN(t.`DateValue`) >= '2018-05-01' AND MIN(t.`DateValue`) < '2018-06-01') As agg
ON m.ID = agg.ID;

SELECT m.*
FROM myLongTable m
INNER JOIN
   (SELECT t.ID, MIN(t.`DateValue`) As MinDate
    FROM myLongTable As t
    WHERE t.organisation = 'Ikea'
    GROUP BY t.ID
    HAVING MIN(t.`DateValue`) >= '2018-05-01' AND MIN(t.`DateValue`) < '2018-06-01') As agg
ON m.ID = agg.ID
ORDER BY m.ID, m.Category;


absolute service time: 0,38 sec