With more than one CROSS JOIN columns of tables mentioned earlier in the FROM clause cannot be referenced in SELECT or WHERE clause (Error message: "Unknown column 'table.column' in 'where clause'")

MariaDB [mariab_test]> CREATE TABLE `a` (`id` int(11) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Query OK, 0 rows affected (0.01 sec)

MariaDB [mariab_test]> INSERT INTO a VALUES (1);

Query OK, 1 row affected (0.01 sec)

MariaDB [mariab_test]> SELECT a.id FROM a AS a1 CROSS JOIN a AS a2 CROSS JOIN a AS a3, a;

+------+

| id   |

+------+

|    1 |

+------+

1 row in set (0.00 sec)

MariaDB [mariab_test]> SELECT a.* FROM a, a AS a1 CROSS JOIN a AS a2 CROSS JOIN a AS a3;

+------+

| id   |

+------+

|    1 |

+------+

1 row in set (0.00 sec)

MariaDB [mariab_test]> SELECT a.id FROM a, a AS a1 CROSS JOIN a AS a2 CROSS JOIN a AS a3;

ERROR 1054 (42S22): Unknown column 'a.id' in 'field list'

MariaDB [mariab_test]> SELECT * FROM a, a AS a1 CROSS JOIN a AS a2 CROSS JOIN a AS a3 WHERE a.id=1;

ERROR 1054 (42S22): Unknown column 'a.id' in 'where clause'

MariaDB [mariab_test]>