Halloween problem

As we talked about it, it came to be known as the #Halloween problem. Patricia Selinger in McJones 1997:22

→ author: Francis Hunger, published on: 2016-Oct-31

SELECT

FROM

WHERE

LIMIT

SELECT

FROM

WHERE

IN

SELECT

FROM

WHERE

LIMIT

SELECT

VERSION

SELECT

FROM

WHERE

IN

SELECT

FROM

WHERE

LIMIT

SELECT

FROM

WHERE

IN

INSERT

INTO

VALUES

ON

DUPLICATE

KEY

UPDATE

VALUES

VALUES

VALUES

SELECT

ID

FROM

WHERE

IN

AND

IN

SELECT

FROM

WHERE

AND

AND

ORDER

BY

DESC

SELECT

DISTINCT

FROM

AS

INNER

JOIN

AS

ON

INNER

JOIN

AS

ON

WHERE

IN

AND

IN

ORDER

BY

ASC

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

IN

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

IN

AND

IN

LIMIT

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

IN

SELECT

ID

FROM

LEFT

JOIN

ON

ID

WHERE

AND

IN

AND

IN

AND

AND

GROUP

BY

ID

ORDER

BY

DESC

LIMIT

SELECT

ID

FROM

LEFT

JOIN

ON

ID

WHERE

AND

IN

AND

AND

GROUP

BY

ID

ORDER

BY

DESC

LIMIT

SELECT

FROM

WHERE

ID

IN

SELECT

FROM

WHERE

LIMIT

SELECT

FROM

AS

INNER

JOIN

AS

ON

WHERE

SELECT

FROM

LEFT

JOIN

ON

ID

WHERE

AND

IN

AND

AND

GROUP

BY

ID

ORDER

BY

ASC

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

FROM

WHERE

ID

IN

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

DISTINCT

FROM

AS

INNER

JOIN

AS

ON

INNER

JOIN

AS

ON

WHERE

IN

AND

IN

ORDER

BY

ASC

SELECT

FROM

WHERE

IN

ORDER

BY

ASC

SELECT

FROM

WHERE

ID

IN

SELECT

ID

FROM

AS

WHERE

AND

AND

ORDER

BY

DESC

LIMIT

SELECT

FROM

WHERE

ID

LIMIT

SELECT

ID

FROM

AS

WHERE

AND

AND

ORDER

BY

ASC

LIMIT

SELECT

FROM

WHERE

ID

LIMIT