File: giant_query.test_slow

package info (click to toggle)
duckdb 1.5.1-2
  • links: PTS, VCS
  • area: main
  • in suites:
  • size: 299,196 kB
  • sloc: cpp: 865,414; ansic: 57,292; python: 18,871; sql: 12,663; lisp: 11,751; yacc: 7,412; lex: 1,682; sh: 747; makefile: 558
file content (8 lines) | stat: -rw-r--r-- 57,654 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
# name: test/sql/parser/giant_query.test_slow
# description: Test running a giant query
# group: [parser]

statement error
SELECT x.x AS x, COALESCE(x.x, 0) AS x, CASE  WHEN NOT(((x.x != (149)::bigint) OR (NOT((CASE  WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x > (0)::integer)) THEN '+Inf'::double WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x < (0)::integer)) THEN '-Inf'::double WHEN ((x.x = x.x) OR (x.x IS NULL)) THEN "/"(x.x, MULTIPLY(x.x, 8.26E+02)) ELSE 1.23456E+05 END <= 0E+00)) AND ((CASE  WHEN ((COALESCE(x.x, x.x.x) IS NULL) AND ((348)::bigint IS NULL)) THEN NULL WHEN ((1)::integer = (1)::integer) THEN CONCAT(COALESCE(x.x, x.x.x), (348)::bigint) ELSE '123458' END ILIKE 'a') OR (CASE  WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x > (0)::integer)) THEN '+Inf'::double WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x < (0)::integer)) THEN '-Inf'::double WHEN ((x.x = x.x) OR (x.x IS NULL)) THEN "/"(x.x, MULTIPLY(x.x, 8.26E+02)) ELSE 1.23456E+05 END > 0E+00) OR NOT((CASE  WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x > (0)::integer)) THEN '+Inf'::double WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x < (0)::integer)) THEN '-Inf'::double WHEN ((x.x = x.x) OR (x.x IS NULL)) THEN "/"(x.x, MULTIPLY(x.x, 8.26E+02)) ELSE 1.23456E+05 END > 0E+00)) OR (CASE  WHEN (((221)::integer = (0)::integer) AND (x.x > (0)::integer)) THEN '+Inf'::double WHEN (((221)::integer = (0)::integer) AND (x.x < (0)::integer)) THEN '-Inf'::double WHEN ((x.x = x.x) OR (x.x IS NULL)) THEN "/"(x.x, (221)::integer) ELSE 1.23456E+05 END = 0E+00))))) THEN NULL WHEN (ADD(x.x, x.x) != (0)::bigint) THEN CASE  WHEN ((COALESCE(x.x, x.x.x) IS NULL) AND ((348)::bigint IS NULL)) THEN NULL WHEN ((1)::integer = (1)::integer) THEN CONCAT(COALESCE(x.x, x.x.x), (348)::bigint) ELSE '123458' END WHEN (((ADD(x.x, x.x) > (0)::bigint) OR (CASE  WHEN ((COALESCE(x.x, x.x.x) IS NULL) AND ((348)::bigint IS NULL)) THEN NULL WHEN ((1)::integer = (1)::integer) THEN CONCAT(COALESCE(x.x, x.x.x), (348)::bigint) ELSE '123458' END COLLATE NOCASE = 'a')) OR ((ADD(x.x, x.x) <= (0)::bigint) OR NOT((x.x != (2)::bigint)) OR ((x.x IN ((164)::integer, (175)::integer, (186)::integer, (197)::integer, (208)::integer, (219)::integer, (230)::integer, (241)::integer, (252)::integer, (263)::integer, (274)::integer)) AND (x.x > (273)::smallint)))) THEN CASE  WHEN ((COALESCE(x.x, x.x.x) IS NULL) AND ((348)::bigint IS NULL)) THEN NULL WHEN ((1)::integer = (1)::integer) THEN CONCAT(COALESCE(x.x, x.x.x), (348)::bigint) ELSE '123458' END WHEN ((CASE  WHEN ((COALESCE(x.x, x.x.x) IS NULL) AND ((348)::bigint IS NULL)) THEN NULL WHEN ((1)::integer = (1)::integer) THEN CONCAT(COALESCE(x.x, x.x.x), (348)::bigint) ELSE '123458' END COLLATE NOCASE = 'a') OR (ADD(x.x, x.x) >= (0)::bigint)) THEN CASE  WHEN ((COALESCE(x.x, x.x.x) IS NULL) AND ((348)::bigint IS NULL)) THEN NULL WHEN ((1)::integer = (1)::integer) THEN CONCAT(COALESCE(x.x, x.x.x), (348)::bigint) ELSE '123458' END WHEN ((x.x != (2)::bigint) OR ((x.x > (149)::bigint) AND (x.x IN ((2)::integer)))) THEN '162' WHEN ((CASE  WHEN (((221)::integer = (0)::integer) AND (x.x > (0)::integer)) THEN '+Inf'::double WHEN (((221)::integer = (0)::integer) AND (x.x < (0)::integer)) THEN '-Inf'::double WHEN ((x.x = x.x) OR (x.x IS NULL)) THEN "/"(x.x, (221)::integer) ELSE 1.23456E+05 END = 0E+00) OR (CASE  WHEN (((221)::integer = (0)::integer) AND (x.x > (0)::integer)) THEN '+Inf'::double WHEN (((221)::integer = (0)::integer) AND (x.x < (0)::integer)) THEN '-Inf'::double WHEN ((x.x = x.x) OR (x.x IS NULL)) THEN "/"(x.x, (221)::integer) ELSE 1.23456E+05 END < 0E+00)) THEN CASE  WHEN ((COALESCE(x.x, x.x.x) IS NULL) AND ((348)::bigint IS NULL)) THEN NULL WHEN ((1)::integer = (1)::integer) THEN CONCAT(COALESCE(x.x, x.x.x), (348)::bigint) ELSE '123458' END WHEN ((NOT((CASE  WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x > (0)::integer)) THEN '+Inf'::double WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x < (0)::integer)) THEN '-Inf'::double WHEN ((x.x = x.x) OR (x.x IS NULL)) THEN "/"(x.x, MULTIPLY(x.x, 8.26E+02)) ELSE 1.23456E+05 END >= 0E+00)) OR (CASE  WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x > (0)::integer)) THEN '+Inf'::double WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x < (0)::integer)) THEN '-Inf'::double WHEN ((x.x = x.x) OR (x.x IS NULL)) THEN "/"(x.x, MULTIPLY(x.x, 8.26E+02)) ELSE 1.23456E+05 END != 0E+00)) OR (((x.x < (149)::bigint) OR (x.x >= (2)::bigint) OR (ADD(x.x, x.x) = (0)::bigint)) OR (CASE  WHEN ((COALESCE(x.x, x.x.x) IS NULL) AND ((348)::bigint IS NULL)) THEN NULL WHEN ((1)::integer = (1)::integer) THEN CONCAT(COALESCE(x.x, x.x.x), (348)::bigint) ELSE '123458' END != 'a'))) THEN '836' WHEN (NOT(((CASE  WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x > (0)::integer)) THEN '+Inf'::double WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x < (0)::integer)) THEN '-Inf'::double WHEN ((x.x = x.x) OR (x.x IS NULL)) THEN "/"(x.x, MULTIPLY(x.x, 8.26E+02)) ELSE 1.23456E+05 END > 0E+00) OR NOT((x.x > (2)::bigint)) OR (CASE  WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x > (0)::integer)) THEN '+Inf'::double WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x < (0)::integer)) THEN '-Inf'::double WHEN ((x.x = x.x) OR (x.x IS NULL)) THEN "/"(x.x, MULTIPLY(x.x, 8.26E+02)) ELSE 1.23456E+05 END >= 0E+00) OR (CASE  WHEN ((COALESCE(x.x, x.x.x) IS NULL) AND ((348)::bigint IS NULL)) THEN NULL WHEN ((1)::integer = (1)::integer) THEN CONCAT(COALESCE(x.x, x.x.x), (348)::bigint) ELSE '123458' END LIKE 'a'))) OR ((CASE  WHEN ((COALESCE(x.x, x.x.x) IS NULL) AND ((348)::bigint IS NULL)) THEN NULL WHEN ((1)::integer = (1)::integer) THEN CONCAT(COALESCE(x.x, x.x.x), (348)::bigint) ELSE '123458' END COLLATE NOCASE = 'a') OR (x.x IN ((3)::integer)))) THEN CASE  WHEN ((COALESCE(x.x, x.x.x) IS NULL) AND ((348)::bigint IS NULL)) THEN NULL WHEN ((1)::integer = (1)::integer) THEN CONCAT(COALESCE(x.x, x.x.x), (348)::bigint) ELSE '123458' END WHEN ((NOT((CASE  WHEN (((221)::integer = (0)::integer) AND (x.x > (0)::integer)) THEN '+Inf'::double WHEN (((221)::integer = (0)::integer) AND (x.x < (0)::integer)) THEN '-Inf'::double WHEN ((x.x = x.x) OR (x.x IS NULL)) THEN "/"(x.x, (221)::integer) ELSE 1.23456E+05 END > 0E+00)) AND ((CASE  WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x > (0)::integer)) THEN '+Inf'::double WHEN ((MULTIPLY(x.x, 8.26E+02) = (0)::integer) AND (x.x < (0)::integer)) THEN '-Inf'::double WHEN ((x.x = x.x) OR (x.x IS NULL)) THEN "/"(x.x, MULTIPLY(x.x, 8.26E+02)) ELSE 1.23456E+05 END >= 0E+00) OR (x.x != (149)::bigint) OR (x.x <= (273)::smallint) OR (x.x <= (149)::bigint))) OR ((ADD(x.x, x.x) = (0)::bigint) OR (x.x IN ((285)::integer)))) THEN '704' ELSE CASE  WHEN ((COALESCE(x.x, x.x.x) IS NULL) AND ((348)::bigint IS NULL)) THEN NULL WHEN ((1)::integer = (1)::integer) THEN CONCAT(COALESCE(x.x, x.x.x), (348)::bigint) ELSE '123458' END END AS x, x.x AS x, CASE  WHEN (NOT(((x.x.x = (571)::smallint) AND (CASE  WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) > (0)::integer)) THEN '+Inf'::double WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) < (0)::integer)) THEN '-Inf'::double WHEN ((ADD(CAST(x.x AS bigint), x.x) = ADD(CAST(x.x AS bigint), x.x)) OR (ADD(CAST(x.x AS bigint), x.x) IS NULL)) THEN "/"(ADD(CAST(x.x AS bigint), x.x), x.x) ELSE 1.23456E+05 END <= 0E+00) AND NOT((COALESCE(x.x, x.x) <= (0)::integer)))) AND (CASE  WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) > (0)::integer)) THEN '+Inf'::double WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) < (0)::integer)) THEN '-Inf'::double WHEN ((ADD(CAST(x.x AS bigint), x.x) = ADD(CAST(x.x AS bigint), x.x)) OR (ADD(CAST(x.x AS bigint), x.x) IS NULL)) THEN "/"(ADD(CAST(x.x AS bigint), x.x), x.x) ELSE 1.23456E+05 END >= 0E+00)) THEN (797)::smallint WHEN ((x.x >= (209)::integer) AND NOT((COALESCE(x.x, x.x) != (0)::integer))) THEN (535)::smallint WHEN NOT(((x.x ILIKE 'ele%') AND NOT(((x.x ILIKE 'p%') AND ((CASE  WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) > (0)::integer)) THEN '+Inf'::double WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) < (0)::integer)) THEN '-Inf'::double WHEN ((ADD(CAST(x.x AS bigint), x.x) = ADD(CAST(x.x AS bigint), x.x)) OR (ADD(CAST(x.x AS bigint), x.x) IS NULL)) THEN "/"(ADD(CAST(x.x AS bigint), x.x), x.x) ELSE 1.23456E+05 END <= 0E+00) AND (NOT((x.x.x != (571)::smallint)) OR (ADD(x.x, x.x) != 0E+00) OR (x.x ILIKE 'cl%'))))))) THEN (499)::smallint WHEN ((x.x != 'Food') OR (CASE  WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) > (0)::integer)) THEN '+Inf'::double WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) < (0)::integer)) THEN '-Inf'::double WHEN ((ADD(CAST(x.x AS bigint), x.x) = ADD(CAST(x.x AS bigint), x.x)) OR (ADD(CAST(x.x AS bigint), x.x) IS NULL)) THEN "/"(ADD(CAST(x.x AS bigint), x.x), x.x) ELSE 1.23456E+05 END <= 0E+00)) THEN x.x.x WHEN ((NOT(NOT((ADD(x.x, x.x) <= 0E+00))) OR (CASE  WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) > (0)::integer)) THEN '+Inf'::double WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) < (0)::integer)) THEN '-Inf'::double WHEN ((ADD(CAST(x.x AS bigint), x.x) = ADD(CAST(x.x AS bigint), x.x)) OR (ADD(CAST(x.x AS bigint), x.x) IS NULL)) THEN "/"(ADD(CAST(x.x AS bigint), x.x), x.x) ELSE 1.23456E+05 END >= 0E+00)) AND ((COALESCE(x.x, x.x) > (0)::integer) OR ((ADD(x.x, x.x) = 0E+00) AND (x.x IN ('Electronics', 'Software', 'Pet')) AND (ADD(x.x, x.x) < 0E+00) AND (COALESCE(x.x, x.x) >= (0)::integer)))) THEN (68)::smallint WHEN NOT((((SUBTRACT(x.x, x.x) > (0)::bigint) OR (ADD(x.x, x.x) = 0E+00) OR (CASE  WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) > (0)::integer)) THEN '+Inf'::double WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) < (0)::integer)) THEN '-Inf'::double WHEN ((ADD(CAST(x.x AS bigint), x.x) = ADD(CAST(x.x AS bigint), x.x)) OR (ADD(CAST(x.x AS bigint), x.x) IS NULL)) THEN "/"(ADD(CAST(x.x AS bigint), x.x), x.x) ELSE 1.23456E+05 END <= 0E+00) OR (x.x.x <= (571)::smallint)) AND (x.x.x >= (571)::smallint))) THEN (836)::smallint WHEN ((ADD(x.x, x.x) = 0E+00) OR ((x.x COLLATE NOCASE != 'clothing') AND (SUBTRACT(x.x, x.x) >= (0)::bigint) AND (x.x.x < (571)::smallint))) THEN x.x.x WHEN ((COALESCE(x.x, x.x) <= (0)::integer) OR ((CASE  WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) > (0)::integer)) THEN '+Inf'::double WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) < (0)::integer)) THEN '-Inf'::double WHEN ((ADD(CAST(x.x AS bigint), x.x) = ADD(CAST(x.x AS bigint), x.x)) OR (ADD(CAST(x.x AS bigint), x.x) IS NULL)) THEN "/"(ADD(CAST(x.x AS bigint), x.x), x.x) ELSE 1.23456E+05 END <= 0E+00) AND (x.x > (209)::integer))) THEN (599)::smallint WHEN ((CASE  WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) > (0)::integer)) THEN '+Inf'::double WHEN ((x.x = (0)::integer) AND (ADD(CAST(x.x AS bigint), x.x) < (0)::integer)) THEN '-Inf'::double WHEN ((ADD(CAST(x.x AS bigint), x.x) = ADD(CAST(x.x AS bigint), x.x)) OR (ADD(CAST(x.x AS bigint), x.x) IS NULL)) THEN "/"(ADD(CAST(x.x AS bigint), x.x), x.x) ELSE 1.23456E+05 END <= 0E+00) OR ((x.x.x IN ((758)::integer, (432)::integer, (232)::integer, (109)::integer, (110)::integer, (111)::integer, (112)::integer, (257)::integer, (314)::integer)) OR (ADD(x.x, x.x) < 0E+00) OR (ADD(x.x, x.x) = 0E+00) OR (x.x != 'Pharmacy') OR (ADD(x.x, x.x) = 0E+00))) THEN (526)::smallint ELSE x.x.x END AS x FROM x.x AS x LEFT JOIN (SELECT x.x.x, x.x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) WHERE (x.x.x = '12:26:47')) AS x ON (x.x = x.x) LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, COUNT(DISTINCT(x.x)) AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x.x AS x FROM x.x WHERE (x.x.x LIKE 'F%')) AS x ON (x.x.x = x.x) WHERE (x.x.x > (149)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x != 4.375E+01)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN (5E-01, 7.5E-01))) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (32)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x != 3.02E+02)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((2)::integer, (1)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x ILIKE 'wil%')) AS x ON (x.x.x = x.x) WHERE (x.x.x = '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x >= '12:00:00')) AS x ON (x.x.x = x.x) WHERE (x.x.x = 7E+00)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('1994-05-01'))) AS x ON (x.x.x = x.x) WHERE (x.x.x != '-1 Nowhere Ave')) AS x ON (x.x.x = x.x) WHERE (x.x.x = '12:45:00')) AS x ON (x.x.x = x.x) WHERE (x.x.x >= '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (8)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x != (14)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN (5E-01, 7.5E-01))) AS x ON (x.x.x = x.x) WHERE (x.x.x <= '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x LIKE 'Ra%')) AS x ON (x.x.x = x.x) WHERE (x.x.x COLLATE NOCASE = 'nj')) AS x ON (x.x.x = x.x) WHERE (x.x.x IN (7.5E-01))) AS x ON (x.x.x = x.x) WHERE (x.x.x < 3.02E+02)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x != (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('FL'))) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x < '2012-08-12T02:09:40Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((100)::integer, (200)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x = '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x < '2022-12-01')) AS x ON (x.x.x = x.x) WHERE (x.x.x < '2017-07-26')) AS x ON (x.x.x = x.x) WHERE (x.x.x = (37)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('09:00:00', '10:00:00', '11:00:00', '10:30:00'))) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (37)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x > '12:26:47')) AS x ON (x.x.x = x.x) WHERE (x.x.x COLLATE NOCASE IN ('6011-1997-0245-5498', '6011-3594-6313-6253', '6011-8154-1250-5468', '6011-9129-7249-7150', '3725-497160-82165'))) AS x ON (x.x.x = x.x) WHERE (x.x.x >= '12:45:00')) AS x ON (x.x.x = x.x) WHERE (x.x.x = '2010-01-25')) AS x ON (x.x.x = x.x) WHERE (x.x.x <= '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x != (2)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x != '1994-05-16')) AS x ON (x.x.x = x.x) WHERE (x.x.x < 7E+00)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= 2.3E+02)) AS x ON (x.x.x = x.x) WHERE (x.x.x < (58)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((10)::integer, (20)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x <= '2017-07-26')) AS x ON (x.x.x = x.x) WHERE (x.x.x < 3.02E+02)) AS x ON (x.x.x = x.x) WHERE (x.x.x != 'Gary Nunlee')) AS x ON (x.x.x = x.x) WHERE (x.x.x < (300)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (58)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x < 7E+00)) AS x ON (x.x.x = x.x) WHERE (x.x.x > (584)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x = (2)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= 7E+00)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (4)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x LIKE '8 W%')) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('2014-01-01T10:10:10Z'))) AS x ON (x.x.x = x.x) WHERE (x.x.x != '2010-01-25')) AS x ON (x.x.x = x.x) WHERE (x.x.x = '12:00:00')) AS x ON (x.x.x = x.x) WHERE (x.x.x LIKE '63%')) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('1995-05-01', '1993-06-01', '1994-05-01'))) AS x ON (x.x.x = x.x) WHERE (x.x.x > (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (138)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x != (37)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x > '12:45:00')) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x > '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x != (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x = (18)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((103)::integer, (104)::integer, (105)::integer, (106)::integer, (107)::integer, (108)::integer, (109)::integer, (110)::integer, (111)::integer, (112)::integer, (113)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (32)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= 6.25E-01)) AS x ON (x.x.x = x.x) WHERE (x.x.x < (37)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x > (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x != '98 Connecticut Ave Nw')) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (138)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x > (570)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x != (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= '11:10:41')) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (3)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x < (8)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (273)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x ILIKE '34%')) AS x ON (x.x.x = x.x) WHERE (x.x.x > (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x < '12:00:00')) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (37)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (11)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x > '2010-01-25')) AS x ON (x.x.x = x.x) WHERE (x.x.x = (11)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x > (2)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x > (32)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((110)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x >= '2010-12-26')) AS x ON (x.x.x = x.x) WHERE (x.x.x > '2022-12-01')) AS x ON (x.x.x = x.x) WHERE (x.x.x < '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x COLLATE NOCASE != '34 center st')) AS x ON (x.x.x = x.x) WHERE (x.x.x != (138)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x != (55)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x = (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((3)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x = '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x LIKE 'Ar%')) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (8)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x = '11:10:41')) AS x ON (x.x.x = x.x) WHERE (x.x.x = (3)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x < (55)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x > (58)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('10:00:00'))) AS x ON (x.x.x = x.x) WHERE (x.x.x != '469 Outwater Ln')) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('1995-05-01', '1993-06-01'))) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('2019-12-25T08:16:37Z'))) AS x ON (x.x.x = x.x) WHERE (x.x.x < (3)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x > '12:26:47')) AS x ON (x.x.x = x.x) WHERE (x.x.x != (37)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x != (8)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= '11:10:41')) AS x ON (x.x.x = x.x) WHERE (x.x.x < (32)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x > '11:10:41')) AS x ON (x.x.x = x.x) WHERE (x.x.x COLLATE NOCASE IN ('va', 'fl', 'ma'))) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((10)::integer, (40)::integer, (50)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (58)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x > 7E+00)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((5)::integer, (6)::integer, (7)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x < (55)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x != 'Willard Kolmetz')) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (2)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((30)::integer, (40)::integer, (50)::integer, (60)::integer, (70)::integer, (80)::integer, (90)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x < (4)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x < (2)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((9)::integer, (10)::integer, (100)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x != (37)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (8)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((100)::integer, (200)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((3)::integer, (6)::integer, (9)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x != '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x < '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x != '14:00:00')) AS x ON (x.x.x = x.x) WHERE (x.x.x > (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x = 'Diane Devreese')) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x COLLATE NOCASE IN ('ky', 'ks', 'ma'))) AS x ON (x.x.x = x.x) WHERE (x.x.x > (58)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x < '2012-07-09T11:41:18Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x != (4)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (300)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x COLLATE NOCASE IN ('4841-0266-8252-1661', '5147-6772-1546-8552', '6011-1412-2828-5470', '3725-497160-82165', '4736-1546-1391-8448'))) AS x ON (x.x.x = x.x) WHERE (x.x.x = '2022-12-01')) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((11)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x = (571)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x ILIKE 'nv%')) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (570)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x = (3)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x = (58)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x < (80)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x = (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (571)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (4)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x < '2022-12-01')) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (3)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN (7.5E-01))) AS x ON (x.x.x = x.x) WHERE (x.x.x = '11:10:41')) AS x ON (x.x.x = x.x) WHERE (x.x.x = 2.3E+02)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x = (11)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= '14:00:00')) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (584)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x > '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x IN (false))) AS x ON (x.x.x = x.x) WHERE (x.x.x = (300)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x > (32)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((2)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x != '2010-12-26')) AS x ON (x.x.x = x.x) WHERE (x.x.x >= 7E+00)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('2011-12-01'))) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (570)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x = (11)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((5)::integer, (6)::integer, (7)::integer, (8)::integer, (9)::integer, (10)::integer, (11)::integer, (100)::integer, (101)::integer, (102)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x < (3)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('2015-02-01T11:10:10Z', '2014-02-01T11:10:10Z', '2014-03-01T10:10:10Z', '2015-02-01T10:10:10Z', '2014-01-01T11:10:10Z', '2015-01-01T11:10:10Z'))) AS x ON (x.x.x = x.x) WHERE (x.x.x = (3)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (570)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x = false)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= '14:00:00')) AS x ON (x.x.x = x.x) WHERE (x.x.x != (58)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x ILIKE 'fle%')) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('2014-02-01T11:10:10Z', '2014-03-01T10:10:10Z', '2015-02-01T10:10:10Z', '2014-01-01T11:10:10Z'))) AS x ON (x.x.x = x.x) WHERE (x.x.x < (4)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x > (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x COLLATE NOCASE = '3426-284893-47570')) AS x ON (x.x.x = x.x) WHERE (x.x.x >= '2012-07-09T11:41:18Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (149)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((123)::integer, (234)::integer, (345)::integer, (101)::integer, (102)::integer, (103)::integer, (108)::integer, (110)::integer, (116)::integer, (104)::integer, (111)::integer, (119)::integer, (105)::integer, (113)::integer, (112)::integer, (120)::integer, (126)::integer, (127)::integer, (121)::integer, (124)::integer, (125)::integer, (106)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('03:53:34', '18:27:48', '08:16:37', '18:00:00', '19:00:00', '20:00:00'))) AS x ON (x.x.x = x.x) WHERE (x.x.x > '2015-05-17')) AS x ON (x.x.x = x.x) WHERE (x.x.x != false)) AS x ON (x.x.x = x.x) WHERE (x.x.x != (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x < '12:26:47')) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('2002-11-01', '2019-02-19', '2001-01-01', '2001-02-01'))) AS x ON (x.x.x = x.x) WHERE (x.x.x <= '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x = 7E+00)) AS x ON (x.x.x = x.x) WHERE (x.x.x > '12:26:47')) AS x ON (x.x.x = x.x) WHERE (x.x.x = (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x < (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= 6E+00)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x != '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x <= '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x != 'OH')) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (584)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x > (2)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x < (80)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x = (8)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x != (273)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x > (209)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x = 'MI') GROUP BY x.x.x) AS x ON (x.x.x = x.x) WHERE (x.x.x < (19)::bigint)) AS x ON (x.x = x.x) LEFT JOIN (SELECT x.x.x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x FROM x.x WHERE (x.x.x = (149)::bigint)) AS x ON (x.x = x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x FROM x.x WHERE (x.x.x < '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x != '2016-12-31T14:18:59Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x > (58)::bigint)) AS x ON (x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) LEFT JOIN (SELECT x.x.x, SUM(DISTINCT(x.x.x)) AS x, SUM(DISTINCT(x.x.x)) AS x, SUM(DISTINCT(x.x.x)) AS x, SUM(DISTINCT(x.x.x)) AS x, SUM(DISTINCT(x.x.x)) AS x, SUM(DISTINCT(x.x.x)) AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) GROUP BY x.x.x) AS x ON (x.x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, MAX(x.x.x) AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) GROUP BY x.x.x) AS x ON (x.x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN (SELECT x.x.x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x, MIN(x.x.x) AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) GROUP BY x.x.x) AS x ON (x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN (SELECT x.x.x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x FROM x.x WHERE (x.x.x < '18:30:00')) AS x ON (x.x = x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, SUM(x.x) AS x, SUM(x.x) AS x, SUM(x.x) AS x, SUM(x.x) AS x, SUM(x.x) AS x, SUM(x.x) AS x, SUM(x.x) AS x, SUM(x.x) AS x, SUM(x.x) AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN x.x AS x ON (x.x = x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN x.x ON (x.x = x.x.x) LEFT JOIN x.x AS x ON (x.x.x = x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x, x.x AS x FROM x.x LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN x.x ON (x.x.x = x.x.x) LEFT JOIN (SELECT x.x.x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x, x.x.x AS x FROM x.x WHERE (x.x.x != (11)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN (false))) AS x ON (x.x.x = x.x) WHERE (x.x.x ILIKE 'f%')) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (14)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('16:00:00', '18:00:00'))) AS x ON (x.x.x = x.x) WHERE (x.x.x <= '2015-07-02T23:30:00Z')) AS x ON (x.x = x.x) WHERE (x.x.x != 'Pharmacy')) AS x ON (x.x.x = x.x) WHERE (x.x.x >= '18:30:00')) AS x ON (x.x = x.x) WHERE (x.x.x < (141)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('2016-02-15T12:00:00Z'))) AS x ON (x.x.x = x.x) WHERE (x.x.x >= 4.375E+01)) AS x ON (x.x.x = x.x) WHERE (x.x.x != (53)::bigint)) AS x ON (x.x = x.x) WHERE (x.x.x >= (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= '12:26:47')) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((241)::integer, (252)::integer, (263)::integer, (274)::integer, (285)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (149)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x COLLATE NOCASE = 'ph')) AS x ON (x.x.x = x.x) WHERE (x.x.x > (2)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x < '2009-02-19T17:15:00Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x = '2011-08-01')) AS x ON (x.x.x = x.x) WHERE (x.x.x != 'Con Artistry')) AS x ON (x.x.x = x.x) WHERE (x.x.x > 5.625E-01)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((99)::integer, (110)::integer, (121)::integer, (132)::integer, (143)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x > '2009-02-19T17:15:00Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x < 4.375E+01)) AS x ON (x.x = x.x) WHERE (x.x.x > '18:30:00')) AS x ON (x.x.x = x.x) WHERE (x.x.x < 5.625E-01)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= '2009-02-19T17:15:00Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x = '17:30:00')) AS x ON (x.x.x = x.x) WHERE (x.x.x LIKE 'De%')) AS x ON (x.x.x = x.x) WHERE (x.x.x = false)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN (5E-01))) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((112)::integer, (257)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x IN (5E-01, 7.5E-01))) AS x ON (x.x.x = x.x) WHERE (x.x.x > (300)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (4)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x > (32)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x > '2012-08-12T02:09:40Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x LIKE 'E%')) AS x ON (x.x.x = x.x) WHERE (x.x.x < (55)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((1)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((107)::integer, (108)::integer, (109)::integer, (110)::integer, (111)::integer, (112)::integer, (113)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (550)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= '2011-08-01')) AS x ON (x.x.x = x.x) WHERE (x.x.x <= (18)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x != '2009-02-19T17:15:00Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x != '2009-02-19T17:15:00Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x > (38)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((20)::integer, (21)::integer, (22)::integer, (23)::integer, (24)::integer, (25)::integer, (26)::integer, (27)::integer, (28)::integer, (29)::integer, (30)::integer, (31)::integer, (32)::integer, (33)::integer, (34)::integer, (35)::integer, (36)::integer, (37)::integer, (38)::integer, (39)::integer, (40)::integer, (41)::integer, (42)::integer, (43)::integer, (44)::integer, (45)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (38)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x = 'Food')) AS x ON (x.x = x.x) WHERE (x.x.x != '17:30:00')) AS x ON (x.x.x = x.x) WHERE (x.x.x < (19)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((2)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x >= '2015-07-02T23:30:00Z')) AS x ON (x.x.x = x.x) WHERE (x.x.x != (209)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (209)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x = false)) AS x ON (x.x.x = x.x) WHERE (x.x.x ILIKE 'e%')) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((12)::integer, (20)::integer, (26)::integer, (27)::integer, (21)::integer, (23)::integer, (24)::integer, (25)::integer, (6)::integer, (14)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x != (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x ILIKE 's%')) AS x ON (x.x.x = x.x) WHERE (x.x.x > '2015-05-17')) AS x ON (x.x.x = x.x) WHERE (x.x.x != (58)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x < '12:26:47')) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x > '2022-12-01')) AS x ON (x.x.x = x.x) WHERE (x.x.x < (4)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((40)::integer, (50)::integer, (60)::integer, (70)::integer, (80)::integer, (90)::integer))) AS x ON (x.x.x = x.x) WHERE (x.x.x > '11:10:41')) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ('2002-11-01', '2019-02-19', '2005-03-13', '2011-12-01'))) AS x ON (x.x.x = x.x) WHERE (x.x.x IN ((7)::integer, (8)::integer, (9)::integer, (10)::integer, (100)::integer, (101)::integer))) AS x ON (x.x = x.x) WHERE (x.x.x > (53)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= '11:10:41')) AS x ON (x.x.x = x.x) WHERE (x.x.x = false)) AS x ON (x.x.x = x.x) WHERE (x.x.x <= '2017-07-26')) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (209)::integer)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (58)::bigint)) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (38)::smallint)) AS x ON (x.x.x = x.x) WHERE (x.x.x != '11:41:47')) AS x ON (x.x = x.x) WHERE (x.x.x = '11:41:47')) AS x ON (x.x.x = x.x) GROUP BY x.x.x) AS x ON (x.x.x = x.x) WHERE (x.x.x >= (58)::bigint)) AS x ON (x.x = x.x) LIMIT 10000
----
Catalog Error: Table with name "x.x" does not exist because schema "x" does not exist.