CREATE TABLE t0 (v1 BIGINT, v2 DOUBLE, v3 DOUBLE, v4 SET('a', 'b', 'c'), v5 BOOLEAN, v6 TIMESTAMP);
CREATE TABLE t1 (v1 GEOMETRY, v2 BLOB, v3 MEDIUMINT);
CREATE TABLE t2 (v1 DECIMAL(19,18), v2 TIMESTAMP, v3 LONGTEXT, v4 DOUBLE, v5 BOOLEAN, v6 BLOB);
SELECT t0.v1, t0.v2, t1.v1, t2.v3, t0.v6 FROM t0 INNER JOIN t1 ON t0.v1 = ST_GeomFromText('POINT(1 1)') AND t0.v2 = t1.v2 INNER JOIN t2 ON t0.v1 = t2.v1 WHERE t0.v5 IS TRUE AND t2.v1 BETWEEN 0.000000000000000001 AND 0.999999999999999999 ORDER BY t0.v6 DESC LIMIT 10 OFFSET 0;