joinD.test - OpenGrok cross reference for /sqlite-3.40.0/test/joinD.test

Lines Matching refs:c
39   CREATE TABLE t1(a INT, b INT, c INT, d INT);
40   WITH RECURSIVE c(x) AS (VALUES(0) UNION ALL SELECT x+1 FROM c WHERE x<95)
41     INSERT INTO t1(a,b,c,d) SELECT x, x+100, x+200, x+300 FROM c;
45   CREATE TABLE t3(c INT, y INT);
46   INSERT INTO t3(c,y) SELECT c, a FROM t1 WHERE a%3=0;
47   CREATE INDEX t3c ON t3(c);
51   INSERT INTO t1(a,b,c,d) VALUES
61   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
63   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
72   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
74   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
83   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
86   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
95   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
98   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
107   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
110   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
119   INNER JOIN t3 ON t1.c=t3.c
122   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
131   INNER JOIN t3 ON t1.c=t3.c
134   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
143   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
146   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
155   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
158   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
167   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
170   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
179   INNER JOIN t3 ON t1.c=t3.c
182   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
191   INNER JOIN t3 ON t1.c=t3.c
194   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
203   INNER JOIN t3 ON t1.c=t3.c
206   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
215   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
217   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
226   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
229   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
240   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
241   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
250   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
253   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
262   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
264   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
273   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
275   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
284   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
286   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
307   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
309   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
330   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
333   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
354   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
357   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
378   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
381   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
402   INNER JOIN t3 ON t1.c=t3.c
405   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
426   INNER JOIN t3 ON t1.c=t3.c
429   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
450   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
453   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
462   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
465   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
486   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
489   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
498   INNER JOIN t3 ON t1.c=t3.c
501   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
510   INNER JOIN t3 ON t1.c=t3.c
513   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
534   INNER JOIN t3 ON t1.c=t3.c
537   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
546   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
548   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
569   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
572   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
595   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
596   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
617   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
620   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
629   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
631   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
652   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
654   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
675   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
677   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
703   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
705   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
731   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
734   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
743   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
746   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
772   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
775   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
784   INNER JOIN t3 ON t1.c=t3.c
787   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
796   INNER JOIN t3 ON t1.c=t3.c
799   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
825   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
828   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
853   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
856   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
881   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
884   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
893   INNER JOIN t3 ON t1.c=t3.c
896   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
905   INNER JOIN t3 ON t1.c=t3.c
908   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
917   INNER JOIN t3 ON t1.c=t3.c
920   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
929   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
931   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
957   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
960   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
985   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
986   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
996   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
999   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1008   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
1010   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1036   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
1038   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1064   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
1066   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1104   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
1106   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1144   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
1147   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1168   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
1171   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1209   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
1212   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1233   INNER JOIN t3 ON t1.c=t3.c
1236   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1257   INNER JOIN t3 ON t1.c=t3.c
1260   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1298   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
1301   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1326   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
1329   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1366   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
1369   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1378   INNER JOIN t3 ON t1.c=t3.c
1381   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1390   INNER JOIN t3 ON t1.c=t3.c
1393   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1414   INNER JOIN t3 ON t1.c=t3.c
1417   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1426   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
1428   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1466   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
1469   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1506   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
1507   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1529   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
1532   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1541   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
1543   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1581   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
1583   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1621   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
1623   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1638   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
1640   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1655   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
1658   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1673   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
1676   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1691   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
1694   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1709   LEFT JOIN t3 ON t1.c=t3.c
1712   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1721   LEFT JOIN t3 ON t1.c=t3.c
1724   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1739   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
1742   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1757   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
1760   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1775   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
1778   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1793   LEFT JOIN t3 ON t1.c=t3.c
1796   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1805   LEFT JOIN t3 ON t1.c=t3.c
1808   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1817   LEFT JOIN t3 ON t1.c=t3.c
1820   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1829   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
1831   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1846   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
1849   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1866   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
1867   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1876   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
1879   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1894   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
1896   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1911   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
1913   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1928   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
1930   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1983   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
1985   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2038   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
2041   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2094   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
2097   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2150   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
2153   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2206   LEFT JOIN t3 ON t1.c=t3.c
2209   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2230   LEFT JOIN t3 ON t1.c=t3.c
2233   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2286   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
2289   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2304   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
2307   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2360   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
2363   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2378   LEFT JOIN t3 ON t1.c=t3.c
2381   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2390   LEFT JOIN t3 ON t1.c=t3.c
2393   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2414   LEFT JOIN t3 ON t1.c=t3.c
2417   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2426   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
2428   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2481   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
2484   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2539   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
2540   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2561   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
2564   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2579   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
2581   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2634   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
2636   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2689   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
2691   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2717   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
2719   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2745   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
2748   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2763   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
2766   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2792   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
2795   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2810   LEFT JOIN t3 ON t1.c=t3.c
2813   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2822   LEFT JOIN t3 ON t1.c=t3.c
2825   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2851   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
2854   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2879   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
2882   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2907   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
2910   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2925   LEFT JOIN t3 ON t1.c=t3.c
2928   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2937   LEFT JOIN t3 ON t1.c=t3.c
2940   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2949   LEFT JOIN t3 ON t1.c=t3.c
2952   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2961   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
2963   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2989   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
2992   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3010   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
3011   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3021   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
3024   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3039   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
3041   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3067   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
3069   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3095   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
3097   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3161   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
3163   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3227   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
3230   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3283   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
3286   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3350   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
3353   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3406   LEFT JOIN t3 ON t1.c=t3.c
3409   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3430   LEFT JOIN t3 ON t1.c=t3.c
3433   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3497   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
3500   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3525   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
3528   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3591   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
3594   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3609   LEFT JOIN t3 ON t1.c=t3.c
3612   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3621   LEFT JOIN t3 ON t1.c=t3.c
3624   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3645   LEFT JOIN t3 ON t1.c=t3.c
3648   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3657   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
3659   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3723   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
3726   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3782   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
3783   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3805   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
3808   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3823   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
3825   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3889   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
3891   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3955   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
3957   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3966   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
3968   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3977   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
3980   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3989   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
3992   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4001   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4004   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4013   RIGHT JOIN t3 ON t1.c=t3.c
4016   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4025   RIGHT JOIN t3 ON t1.c=t3.c
4028   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4037   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4040   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4049   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4052   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4061   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4064   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4073   RIGHT JOIN t3 ON t1.c=t3.c
4076   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4085   RIGHT JOIN t3 ON t1.c=t3.c
4088   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4097   RIGHT JOIN t3 ON t1.c=t3.c
4100   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4109   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
4111   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4120   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
4123   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4134   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
4135   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4144   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
4147   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4156   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4158   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4167   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
4169   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4178   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4180   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4218   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4220   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4258   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4261   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4282   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4285   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4323   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4326   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4347   RIGHT JOIN t3 ON t1.c=t3.c
4350   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4387   RIGHT JOIN t3 ON t1.c=t3.c
4390   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4427   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4430   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4439   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4442   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4480   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4483   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4492   RIGHT JOIN t3 ON t1.c=t3.c
4495   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4504   RIGHT JOIN t3 ON t1.c=t3.c
4507   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4528   RIGHT JOIN t3 ON t1.c=t3.c
4531   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4540   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
4542   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4580   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
4583   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4607   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
4608   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4629   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
4632   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4641   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4643   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4681   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
4683   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4721   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4723   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4749   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4751   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4777   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4780   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4789   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4792   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4818   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4821   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4830   RIGHT JOIN t3 ON t1.c=t3.c
4833   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4842   RIGHT JOIN t3 ON t1.c=t3.c
4845   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4871   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4874   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4899   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4902   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4927   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
4930   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4939   RIGHT JOIN t3 ON t1.c=t3.c
4942   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4951   RIGHT JOIN t3 ON t1.c=t3.c
4954   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4963   RIGHT JOIN t3 ON t1.c=t3.c
4966   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4975   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
4977   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5003   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
5006   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5031   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
5032   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5042   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
5045   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5054   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
5056   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5082   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
5084   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5110   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
5112   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5167   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
5169   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5224   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
5227   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5248   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
5251   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5306   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
5309   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5330   RIGHT JOIN t3 ON t1.c=t3.c
5333   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5370   RIGHT JOIN t3 ON t1.c=t3.c
5373   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5427   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
5430   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5455   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
5458   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5512   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
5515   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5524   RIGHT JOIN t3 ON t1.c=t3.c
5527   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5536   RIGHT JOIN t3 ON t1.c=t3.c
5539   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5560   RIGHT JOIN t3 ON t1.c=t3.c
5563   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5572   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
5574   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5629   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
5632   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5670   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
5671   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5693   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
5696   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5705   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
5707   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5762   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
5764   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5819   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
5821   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5836   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
5838   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5853   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
5856   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5871   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
5874   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5889   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
5892   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5907   FULL JOIN t3 ON t1.c=t3.c
5910   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5919   FULL JOIN t3 ON t1.c=t3.c
5922   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5937   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
5940   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5955   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
5958   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5973   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
5976   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5991   FULL JOIN t3 ON t1.c=t3.c
5994   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6003   FULL JOIN t3 ON t1.c=t3.c
6006   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6015   FULL JOIN t3 ON t1.c=t3.c
6018   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6027   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
6029   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6044   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
6047   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6064   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
6065   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6074   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
6077   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6092   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
6094   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6109   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
6111   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6181   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
6183   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6253   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
6256   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6309   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
6312   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6382   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
6385   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6438   FULL JOIN t3 ON t1.c=t3.c
6441   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6478   FULL JOIN t3 ON t1.c=t3.c
6481   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6550   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
6553   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6568   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
6571   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6641   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
6644   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6659   FULL JOIN t3 ON t1.c=t3.c
6662   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6671   FULL JOIN t3 ON t1.c=t3.c
6674   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6695   FULL JOIN t3 ON t1.c=t3.c
6698   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6707   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
6709   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6779   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
6782   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6838   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
6839   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6860   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
6863   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6878   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
6880   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6950   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
6952   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6978   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
6980   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7006   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
7009   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7024   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
7027   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7053   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
7056   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7071   FULL JOIN t3 ON t1.c=t3.c
7074   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7083   FULL JOIN t3 ON t1.c=t3.c
7086   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7112   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
7115   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7140   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
7143   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7168   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
7171   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7186   FULL JOIN t3 ON t1.c=t3.c
7189   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7198   FULL JOIN t3 ON t1.c=t3.c
7201   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7210   FULL JOIN t3 ON t1.c=t3.c
7213   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7222   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
7224   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7250   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
7253   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7271   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
7272   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7281   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
7284   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7299   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
7301   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7327   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
7329   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7410   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
7412   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7493   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
7496   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7549   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
7552   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7633   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
7636   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7689   FULL JOIN t3 ON t1.c=t3.c
7692   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7729   FULL JOIN t3 ON t1.c=t3.c
7732   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7812   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
7815   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7840   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
7843   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7923   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
7926   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7941   FULL JOIN t3 ON t1.c=t3.c
7944   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7953   FULL JOIN t3 ON t1.c=t3.c
7956   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7977   FULL JOIN t3 ON t1.c=t3.c
7980   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7989   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
7991   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8072   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
8075   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8132   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
8133   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8154   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
8157   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8172   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
8174   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8255   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8257   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8269   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8271   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8283   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8286   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8295   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8298   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8310   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8313   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8322   INNER JOIN t3 ON t1.c=t3.c
8325   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8337   INNER JOIN t3 ON t1.c=t3.c
8340   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8352   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8355   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8367   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8370   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8382   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8385   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8394   INNER JOIN t3 ON t1.c=t3.c
8397   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8409   INNER JOIN t3 ON t1.c=t3.c
8412   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8421   INNER JOIN t3 ON t1.c=t3.c
8424   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8433   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
8435   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8447   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
8450   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8461   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
8462   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8471   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
8474   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8483   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8485   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8497   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
8499   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8511   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8513   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8550   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8552   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8589   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8592   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8613   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8616   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8653   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8656   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8677   INNER JOIN t3 ON t1.c=t3.c
8680   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8717   INNER JOIN t3 ON t1.c=t3.c
8720   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8757   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8760   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8772   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8775   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8812   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8815   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8824   INNER JOIN t3 ON t1.c=t3.c
8827   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8839   INNER JOIN t3 ON t1.c=t3.c
8842   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8863   INNER JOIN t3 ON t1.c=t3.c
8866   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8875   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
8877   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8914   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
8917   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8940   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
8941   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8962   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
8965   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8974   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
8976   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9013   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
9015   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9052   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9054   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9080   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9082   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9108   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9111   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9120   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9123   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9149   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9152   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9161   INNER JOIN t3 ON t1.c=t3.c
9164   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9176   INNER JOIN t3 ON t1.c=t3.c
9179   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9205   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9208   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9233   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9236   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9261   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9264   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9273   INNER JOIN t3 ON t1.c=t3.c
9276   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9288   INNER JOIN t3 ON t1.c=t3.c
9291   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9300   INNER JOIN t3 ON t1.c=t3.c
9303   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9312   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
9314   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9340   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
9343   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9368   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
9369   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9379   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
9382   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9391   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9393   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9419   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
9421   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9447   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9449   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9500   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9502   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9553   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9556   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9577   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9580   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9631   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9634   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9655   INNER JOIN t3 ON t1.c=t3.c
9658   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9695   INNER JOIN t3 ON t1.c=t3.c
9698   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9749   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9752   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9777   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9780   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9830   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
9833   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9842   INNER JOIN t3 ON t1.c=t3.c
9845   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9857   INNER JOIN t3 ON t1.c=t3.c
9860   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9881   INNER JOIN t3 ON t1.c=t3.c
9884   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9893   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
9895   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9946   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
9949   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9986   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
9987   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10009   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
10012   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10021   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
10023   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10074   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
10076   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10127   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
10129   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10154   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
10156   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10181   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
10184   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10199   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
10202   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10227   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
10230   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10245   LEFT JOIN t3 ON t1.c=t3.c
10248   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10260   LEFT JOIN t3 ON t1.c=t3.c
10263   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10288   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
10291   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10316   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
10319   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10344   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
10347   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10362   LEFT JOIN t3 ON t1.c=t3.c
10365   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10377   LEFT JOIN t3 ON t1.c=t3.c
10380   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10389   LEFT JOIN t3 ON t1.c=t3.c
10392   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10401   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
10403   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10428   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
10431   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10448   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
10449   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10458   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
10461   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10476   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
10478   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10503   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
10505   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10530   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
10532   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10638   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
10640   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10746   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
10749   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10802   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
10805   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10910   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
10913   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10966   LEFT JOIN t3 ON t1.c=t3.c
10969   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11006   LEFT JOIN t3 ON t1.c=t3.c
11009   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11114   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
11117   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11142   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
11145   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11250   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
11253   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11268   LEFT JOIN t3 ON t1.c=t3.c
11271   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11283   LEFT JOIN t3 ON t1.c=t3.c
11286   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11307   LEFT JOIN t3 ON t1.c=t3.c
11310   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11319   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
11321   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11427   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
11430   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11485   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
11486   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11507   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
11510   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11525   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
11527   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11633   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
11635   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11741   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
11743   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11769   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
11771   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11797   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
11800   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11815   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
11818   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11844   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
11847   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11862   LEFT JOIN t3 ON t1.c=t3.c
11865   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11877   LEFT JOIN t3 ON t1.c=t3.c
11880   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11906   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
11909   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11934   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
11937   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11962   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
11965   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11980   LEFT JOIN t3 ON t1.c=t3.c
11983   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11995   LEFT JOIN t3 ON t1.c=t3.c
11998   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12007   LEFT JOIN t3 ON t1.c=t3.c
12010   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12019   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
12021   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12047   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
12050   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12068   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
12069   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12079   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
12082   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12097   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
12099   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12125   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
12127   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12153   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
12155   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12262   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
12264   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12371   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
12374   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12427   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
12430   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12536   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
12539   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12592   LEFT JOIN t3 ON t1.c=t3.c
12595   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12632   LEFT JOIN t3 ON t1.c=t3.c
12635   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12741   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
12744   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12769   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
12772   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12877   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
12880   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12895   LEFT JOIN t3 ON t1.c=t3.c
12898   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12910   LEFT JOIN t3 ON t1.c=t3.c
12913   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12934   LEFT JOIN t3 ON t1.c=t3.c
12937   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12946   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
12948   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13055   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
13058   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13114   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
13115   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13137   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
13140   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13155   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
13157   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13264   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
13266   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13373   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13375   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13387   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13389   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13401   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13404   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13413   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13416   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13428   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13431   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13440   RIGHT JOIN t3 ON t1.c=t3.c
13443   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13455   RIGHT JOIN t3 ON t1.c=t3.c
13458   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13470   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13473   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13485   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13488   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13500   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13503   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13512   RIGHT JOIN t3 ON t1.c=t3.c
13515   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13527   RIGHT JOIN t3 ON t1.c=t3.c
13530   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13539   RIGHT JOIN t3 ON t1.c=t3.c
13542   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13551   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
13553   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13565   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
13568   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13579   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
13580   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13589   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
13592   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13601   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13603   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13615   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
13617   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13629   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13631   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13669   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13671   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13709   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13712   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13733   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13736   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13774   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13777   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13798   RIGHT JOIN t3 ON t1.c=t3.c
13801   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13838   RIGHT JOIN t3 ON t1.c=t3.c
13841   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13878   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13881   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13893   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13896   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13934   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
13937   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13946   RIGHT JOIN t3 ON t1.c=t3.c
13949   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13961   RIGHT JOIN t3 ON t1.c=t3.c
13964   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13985   RIGHT JOIN t3 ON t1.c=t3.c
13988   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13997   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
13999   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14037   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
14040   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14064   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
14065   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14086   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
14089   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14098   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14100   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14138   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
14140   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14178   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14180   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14206   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14208   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14234   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14237   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14246   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14249   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14275   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14278   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14287   RIGHT JOIN t3 ON t1.c=t3.c
14290   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14302   RIGHT JOIN t3 ON t1.c=t3.c
14305   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14331   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14334   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14359   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14362   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14387   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14390   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14399   RIGHT JOIN t3 ON t1.c=t3.c
14402   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14414   RIGHT JOIN t3 ON t1.c=t3.c
14417   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14426   RIGHT JOIN t3 ON t1.c=t3.c
14429   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14438   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
14440   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14466   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
14469   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14494   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
14495   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14505   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
14508   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14517   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14519   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14545   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
14547   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14573   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14575   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14627   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14629   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14681   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14684   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14705   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14708   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14760   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14763   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14784   RIGHT JOIN t3 ON t1.c=t3.c
14787   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14824   RIGHT JOIN t3 ON t1.c=t3.c
14827   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14878   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14881   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14906   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14909   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14960   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
14963   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14972   RIGHT JOIN t3 ON t1.c=t3.c
14975   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14987   RIGHT JOIN t3 ON t1.c=t3.c
14990   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15011   RIGHT JOIN t3 ON t1.c=t3.c
15014   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15023   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
15025   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15077   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
15080   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15118   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
15119   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15141   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
15144   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15153   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
15155   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15207   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
15209   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15261   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
15263   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15288   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
15290   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15315   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
15318   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15333   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
15336   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15361   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
15364   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15379   FULL JOIN t3 ON t1.c=t3.c
15382   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15394   FULL JOIN t3 ON t1.c=t3.c
15397   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15422   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
15425   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15450   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
15453   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15478   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
15481   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15496   FULL JOIN t3 ON t1.c=t3.c
15499   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15511   FULL JOIN t3 ON t1.c=t3.c
15514   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15523   FULL JOIN t3 ON t1.c=t3.c
15526   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15535   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
15537   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15562   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
15565   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15582   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
15583   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15592   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
15595   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15610   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
15612   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15637   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
15639   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15746   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
15748   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15855   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
15858   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15911   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
15914   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16020   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
16023   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16076   FULL JOIN t3 ON t1.c=t3.c
16079   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16116   FULL JOIN t3 ON t1.c=t3.c
16119   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16224   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
16227   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16252   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
16255   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16361   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
16364   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16379   FULL JOIN t3 ON t1.c=t3.c
16382   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16394   FULL JOIN t3 ON t1.c=t3.c
16397   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16418   FULL JOIN t3 ON t1.c=t3.c
16421   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16430   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
16432   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16539   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
16542   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16598   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
16599   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16620   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
16623   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16638   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
16640   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16747   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
16749   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16775   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
16777   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16803   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
16806   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16821   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
16824   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16850   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
16853   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16868   FULL JOIN t3 ON t1.c=t3.c
16871   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16883   FULL JOIN t3 ON t1.c=t3.c
16886   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16912   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
16915   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16940   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
16943   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16968   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
16971   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16986   FULL JOIN t3 ON t1.c=t3.c
16989   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17001   FULL JOIN t3 ON t1.c=t3.c
17004   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17013   FULL JOIN t3 ON t1.c=t3.c
17016   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17025   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
17027   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17053   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
17056   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17074   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
17075   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17084   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
17087   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17102   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
17104   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17130   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
17132   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17240   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
17242   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17350   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
17353   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17406   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
17409   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17516   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
17519   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17572   FULL JOIN t3 ON t1.c=t3.c
17575   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17612   FULL JOIN t3 ON t1.c=t3.c
17615   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17721   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
17724   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17749   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
17752   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17858   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
17861   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17876   FULL JOIN t3 ON t1.c=t3.c
17879   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17891   FULL JOIN t3 ON t1.c=t3.c
17894   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17915   FULL JOIN t3 ON t1.c=t3.c
17918   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17927   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
17929   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18037   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
18040   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18097   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
18098   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18119   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
18122   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18137   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
18139   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18247   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18249   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18258   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18260   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18269   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18272   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18281   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18284   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18293   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18296   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18305   INNER JOIN t3 ON t1.c=t3.c
18308   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18317   INNER JOIN t3 ON t1.c=t3.c
18320   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18329   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18332   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18341   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18344   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18353   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18356   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18365   INNER JOIN t3 ON t1.c=t3.c
18368   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18377   INNER JOIN t3 ON t1.c=t3.c
18380   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18389   INNER JOIN t3 ON t1.c=t3.c
18392   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18401   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
18403   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18412   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
18415   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18426   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
18427   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18436   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
18439   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18448   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18450   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18459   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
18461   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18470   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18472   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18493   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18495   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18516   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18519   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18540   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18543   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18564   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18567   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18588   INNER JOIN t3 ON t1.c=t3.c
18591   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18612   INNER JOIN t3 ON t1.c=t3.c
18615   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18636   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18639   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18648   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18651   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18672   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18675   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18684   INNER JOIN t3 ON t1.c=t3.c
18687   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18696   INNER JOIN t3 ON t1.c=t3.c
18699   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18720   INNER JOIN t3 ON t1.c=t3.c
18723   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18732   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
18734   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18755   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
18758   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18781   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
18782   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18803   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
18806   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18815   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18817   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18838   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
18840   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18861   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18863   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18889   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18891   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18917   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18920   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18929   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18932   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18958   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
18961   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18970   INNER JOIN t3 ON t1.c=t3.c
18973   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18982   INNER JOIN t3 ON t1.c=t3.c
18985   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19011   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
19014   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19039   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
19042   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19067   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
19070   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19079   INNER JOIN t3 ON t1.c=t3.c
19082   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19091   INNER JOIN t3 ON t1.c=t3.c
19094   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19103   INNER JOIN t3 ON t1.c=t3.c
19106   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19115   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
19117   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19143   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
19146   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19171   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
19172   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19182   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
19185   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19194   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
19196   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19222   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
19224   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19250   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
19252   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19290   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
19292   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19330   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
19333   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19354   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
19357   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19395   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
19398   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19419   INNER JOIN t3 ON t1.c=t3.c
19422   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19443   INNER JOIN t3 ON t1.c=t3.c
19446   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19484   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
19487   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19512   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
19515   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19552   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
19555   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19564   INNER JOIN t3 ON t1.c=t3.c
19567   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19576   INNER JOIN t3 ON t1.c=t3.c
19579   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19600   INNER JOIN t3 ON t1.c=t3.c
19603   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19612   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
19614   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19652   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
19655   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19692   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
19693   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19715   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
19718   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19727   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
19729   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19767   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
19769   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19807   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
19809   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19824   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
19826   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19841   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
19844   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19859   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
19862   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19877   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
19880   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19895   LEFT JOIN t3 ON t1.c=t3.c
19898   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19907   LEFT JOIN t3 ON t1.c=t3.c
19910   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19925   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
19928   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19943   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
19946   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19961   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
19964   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19979   LEFT JOIN t3 ON t1.c=t3.c
19982   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19991   LEFT JOIN t3 ON t1.c=t3.c
19994   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20003   LEFT JOIN t3 ON t1.c=t3.c
20006   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20015   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
20017   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20032   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
20035   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20052   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
20053   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20062   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
20065   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20080   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
20082   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20097   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
20099   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20114   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
20116   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20170   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
20172   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20226   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
20229   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20282   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
20285   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20338   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
20341   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20394   LEFT JOIN t3 ON t1.c=t3.c
20397   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20418   LEFT JOIN t3 ON t1.c=t3.c
20421   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20475   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
20478   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20493   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
20496   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20550   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
20553   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20568   LEFT JOIN t3 ON t1.c=t3.c
20571   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20580   LEFT JOIN t3 ON t1.c=t3.c
20583   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20604   LEFT JOIN t3 ON t1.c=t3.c
20607   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20616   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
20618   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20672   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
20675   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20730   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
20731   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20752   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
20755   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20770   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
20772   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20826   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
20828   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20882   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
20884   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20910   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
20912   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20938   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
20941   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20956   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
20959   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20985   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
20988   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21003   LEFT JOIN t3 ON t1.c=t3.c
21006   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21015   LEFT JOIN t3 ON t1.c=t3.c
21018   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21044   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
21047   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21072   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
21075   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21100   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
21103   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21118   LEFT JOIN t3 ON t1.c=t3.c
21121   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21130   LEFT JOIN t3 ON t1.c=t3.c
21133   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21142   LEFT JOIN t3 ON t1.c=t3.c
21145   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21154   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
21156   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21182   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
21185   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21203   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
21204   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21214   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
21217   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21232   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
21234   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21260   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
21262   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21288   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
21290   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21355   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
21357   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21422   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
21425   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21478   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
21481   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21545   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
21548   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21601   LEFT JOIN t3 ON t1.c=t3.c
21604   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21625   LEFT JOIN t3 ON t1.c=t3.c
21628   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21693   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
21696   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21721   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
21724   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21788   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
21791   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21806   LEFT JOIN t3 ON t1.c=t3.c
21809   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21818   LEFT JOIN t3 ON t1.c=t3.c
21821   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21842   LEFT JOIN t3 ON t1.c=t3.c
21845   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21854   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
21856   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21921   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
21924   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21980   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
21981   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22003   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
22006   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22021   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
22023   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22088   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
22090   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22155   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22157   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22166   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22168   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22177   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22180   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22189   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22192   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22201   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22204   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22213   RIGHT JOIN t3 ON t1.c=t3.c
22216   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22225   RIGHT JOIN t3 ON t1.c=t3.c
22228   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22237   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22240   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22249   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22252   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22261   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22264   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22273   RIGHT JOIN t3 ON t1.c=t3.c
22276   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22285   RIGHT JOIN t3 ON t1.c=t3.c
22288   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22297   RIGHT JOIN t3 ON t1.c=t3.c
22300   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22309   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
22311   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22320   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
22323   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22334   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
22335   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22344   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
22347   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22356   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22358   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22367   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
22369   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22378   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22380   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22418   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22420   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22458   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22461   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22482   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22485   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22523   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22526   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22547   RIGHT JOIN t3 ON t1.c=t3.c
22550   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22587   RIGHT JOIN t3 ON t1.c=t3.c
22590   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22627   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22630   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22639   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22642   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22680   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22683   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22692   RIGHT JOIN t3 ON t1.c=t3.c
22695   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22704   RIGHT JOIN t3 ON t1.c=t3.c
22707   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22728   RIGHT JOIN t3 ON t1.c=t3.c
22731   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22740   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
22742   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22780   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
22783   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22807   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
22808   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22829   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
22832   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22841   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22843   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22881   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
22883   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22921   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22923   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22949   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22951   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22977   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22980   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22989   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
22992   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23018   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
23021   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23030   RIGHT JOIN t3 ON t1.c=t3.c
23033   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23042   RIGHT JOIN t3 ON t1.c=t3.c
23045   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23071   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
23074   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23099   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
23102   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23127   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
23130   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23139   RIGHT JOIN t3 ON t1.c=t3.c
23142   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23151   RIGHT JOIN t3 ON t1.c=t3.c
23154   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23163   RIGHT JOIN t3 ON t1.c=t3.c
23166   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23175   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
23177   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23203   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
23206   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23231   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
23232   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23242   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
23245   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23254   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
23256   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23282   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
23284   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23310   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
23312   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23367   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
23369   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23424   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
23427   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23448   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
23451   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23506   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
23509   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23530   RIGHT JOIN t3 ON t1.c=t3.c
23533   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23570   RIGHT JOIN t3 ON t1.c=t3.c
23573   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23627   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
23630   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23655   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
23658   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23712   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
23715   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23724   RIGHT JOIN t3 ON t1.c=t3.c
23727   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23736   RIGHT JOIN t3 ON t1.c=t3.c
23739   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23760   RIGHT JOIN t3 ON t1.c=t3.c
23763   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23772   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
23774   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23829   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
23832   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23870   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
23871   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23893   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
23896   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23905   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
23907   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23962   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
23964   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24019   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24021   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24036   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24038   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24053   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24056   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24071   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24074   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24089   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24092   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24107   FULL JOIN t3 ON t1.c=t3.c
24110   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24119   FULL JOIN t3 ON t1.c=t3.c
24122   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24137   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24140   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24155   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24158   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24173   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24176   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24191   FULL JOIN t3 ON t1.c=t3.c
24194   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24203   FULL JOIN t3 ON t1.c=t3.c
24206   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24215   FULL JOIN t3 ON t1.c=t3.c
24218   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24227   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
24229   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24244   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
24247   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24264   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
24265   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24274   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
24277   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24292   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24294   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24309   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24311   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24382   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24384   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24455   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24458   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24511   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24514   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24584   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24587   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24640   FULL JOIN t3 ON t1.c=t3.c
24643   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24680   FULL JOIN t3 ON t1.c=t3.c
24683   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24753   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24756   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24771   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24774   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24845   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
24848   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24863   FULL JOIN t3 ON t1.c=t3.c
24866   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24875   FULL JOIN t3 ON t1.c=t3.c
24878   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24899   FULL JOIN t3 ON t1.c=t3.c
24902   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24911   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
24913   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24984   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
24987   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25043   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
25044   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25065   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
25068   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25083   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
25085   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25156   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
25158   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25184   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
25186   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25212   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
25215   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25230   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
25233   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25259   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
25262   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25277   FULL JOIN t3 ON t1.c=t3.c
25280   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25289   FULL JOIN t3 ON t1.c=t3.c
25292   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25318   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
25321   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25346   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
25349   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25374   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
25377   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25392   FULL JOIN t3 ON t1.c=t3.c
25395   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25404   FULL JOIN t3 ON t1.c=t3.c
25407   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25416   FULL JOIN t3 ON t1.c=t3.c
25419   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25428   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
25430   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25456   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
25459   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25477   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
25478   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25487   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
25490   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25505   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
25507   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25533   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
25535   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25617   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
25619   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25701   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
25704   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25757   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
25760   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25841   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
25844   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25897   FULL JOIN t3 ON t1.c=t3.c
25900   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25937   FULL JOIN t3 ON t1.c=t3.c
25940   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26021   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
26024   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26049   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
26052   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26133   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
26136   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26151   FULL JOIN t3 ON t1.c=t3.c
26154   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26163   FULL JOIN t3 ON t1.c=t3.c
26166   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26187   FULL JOIN t3 ON t1.c=t3.c
26190   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26199   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
26201   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26283   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
26286   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26343   WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
26344   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26365   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
26368   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26383   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
26385   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26467   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
26469   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26481   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
26484   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26493   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
26496   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26508   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
26511   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26520   INNER JOIN t3 ON t1.c=t3.c
26523   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26535   INNER JOIN t3 ON t1.c=t3.c
26538   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26550   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
26553   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26565   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
26568   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26580   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
26583   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26592   INNER JOIN t3 ON t1.c=t3.c
26595   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26607   INNER JOIN t3 ON t1.c=t3.c
26610   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26619   INNER JOIN t3 ON t1.c=t3.c
26622   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26631   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
26633   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26645   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
26648   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26659   WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
26660   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26669   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
26672   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26681   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
26683   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26695   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
26697   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26734   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
26737   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26758   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
26761   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26798   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
26801   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26822   INNER JOIN t3 ON t1.c=t3.c
26825   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26862   INNER JOIN t3 ON t1.c=t3.c
26865   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26902   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
26905   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26917   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
26920   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26957   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
26960   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26969   INNER JOIN t3 ON t1.c=t3.c
26972   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26984   INNER JOIN t3 ON t1.c=t3.c
26987   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27008   INNER JOIN t3 ON t1.c=t3.c
27011   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27020   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
27022   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27059   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
27062   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27085   WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
27086   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27107   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
27110   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27119   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
27121   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27158   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
27160   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27186   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
27189   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27198   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
27201   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27227   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
27230   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27239   INNER JOIN t3 ON t1.c=t3.c
27242   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27254   INNER JOIN t3 ON t1.c=t3.c
27257   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27283   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
27286   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27311   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
27314   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27339   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
27342   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27351   INNER JOIN t3 ON t1.c=t3.c
27354   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27366   INNER JOIN t3 ON t1.c=t3.c
27369   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27378   INNER JOIN t3 ON t1.c=t3.c
27381   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27390   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
27392   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27418   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
27421   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27432   WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
27433   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27442   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
27445   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27454   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
27456   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27482   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
27484   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27535   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
27538   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27559   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
27562   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27613   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
27616   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27637   INNER JOIN t3 ON t1.c=t3.c
27640   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27677   INNER JOIN t3 ON t1.c=t3.c
27680   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27731   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
27734   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27759   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
27762   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27812   INNER JOIN t3 ON t1.c=t3.c AND t3.y>0
27815   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27824   INNER JOIN t3 ON t1.c=t3.c
27827   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27839   INNER JOIN t3 ON t1.c=t3.c
27842   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27863   INNER JOIN t3 ON t1.c=t3.c
27866   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27875   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
27877   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27928   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
27931   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27954   WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
27955   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27976   INNER JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
27979   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27988   INNER JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
27990   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28041   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
28043   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28068   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
28071   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28086   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
28089   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28114   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
28117   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28132   LEFT JOIN t3 ON t1.c=t3.c
28135   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28147   LEFT JOIN t3 ON t1.c=t3.c
28150   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28175   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
28178   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28203   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
28206   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28231   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
28234   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28249   LEFT JOIN t3 ON t1.c=t3.c
28252   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28264   LEFT JOIN t3 ON t1.c=t3.c
28267   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28276   LEFT JOIN t3 ON t1.c=t3.c
28279   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28288   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
28290   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28315   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
28318   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28335   WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
28336   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28345   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
28348   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28363   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
28365   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28390   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
28392   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28499   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
28502   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28555   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
28558   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28663   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
28666   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28719   LEFT JOIN t3 ON t1.c=t3.c
28722   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28759   LEFT JOIN t3 ON t1.c=t3.c
28762   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28868   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
28871   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28896   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
28899   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29005   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
29008   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29023   LEFT JOIN t3 ON t1.c=t3.c
29026   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29038   LEFT JOIN t3 ON t1.c=t3.c
29041   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29062   LEFT JOIN t3 ON t1.c=t3.c
29065   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29074   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
29076   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29183   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
29186   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29241   WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
29242   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29263   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
29266   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29281   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
29283   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29390   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
29392   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29418   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
29421   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29436   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
29439   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29465   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
29468   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29483   LEFT JOIN t3 ON t1.c=t3.c
29486   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29498   LEFT JOIN t3 ON t1.c=t3.c
29501   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29527   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
29530   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29555   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
29558   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29583   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
29586   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29601   LEFT JOIN t3 ON t1.c=t3.c
29604   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29616   LEFT JOIN t3 ON t1.c=t3.c
29619   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29628   LEFT JOIN t3 ON t1.c=t3.c
29631   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29640   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
29642   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29668   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
29671   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29688   WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
29689   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29698   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
29701   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29716   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
29718   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29744   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
29746   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29854   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
29857   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29910   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
29913   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30019   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
30022   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30075   LEFT JOIN t3 ON t1.c=t3.c
30078   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30115   LEFT JOIN t3 ON t1.c=t3.c
30118   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30225   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
30228   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30253   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
30256   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30362   LEFT JOIN t3 ON t1.c=t3.c AND t3.y>0
30365   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30380   LEFT JOIN t3 ON t1.c=t3.c
30383   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30395   LEFT JOIN t3 ON t1.c=t3.c
30398   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30419   LEFT JOIN t3 ON t1.c=t3.c
30422   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30431   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
30433   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30541   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
30544   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30599   WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
30600   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30621   LEFT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
30624   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30639   LEFT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
30641   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30749   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
30751   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30763   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
30766   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30775   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
30778   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30790   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
30793   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30802   RIGHT JOIN t3 ON t1.c=t3.c
30805   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30817   RIGHT JOIN t3 ON t1.c=t3.c
30820   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30832   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
30835   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30847   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
30850   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30862   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
30865   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30874   RIGHT JOIN t3 ON t1.c=t3.c
30877   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30889   RIGHT JOIN t3 ON t1.c=t3.c
30892   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30901   RIGHT JOIN t3 ON t1.c=t3.c
30904   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30913   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
30915   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30927   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
30930   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30941   WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
30942   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30951   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
30954   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30963   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
30965   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30977   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
30979   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31017   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31020   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31041   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31044   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31082   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31085   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31106   RIGHT JOIN t3 ON t1.c=t3.c
31109   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31146   RIGHT JOIN t3 ON t1.c=t3.c
31149   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31186   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31189   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31201   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31204   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31242   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31245   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31254   RIGHT JOIN t3 ON t1.c=t3.c
31257   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31269   RIGHT JOIN t3 ON t1.c=t3.c
31272   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31293   RIGHT JOIN t3 ON t1.c=t3.c
31296   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31305   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
31307   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31345   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
31348   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31371   WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
31372   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31393   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
31396   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31405   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
31407   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31445   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31447   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31473   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31476   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31485   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31488   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31514   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31517   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31526   RIGHT JOIN t3 ON t1.c=t3.c
31529   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31541   RIGHT JOIN t3 ON t1.c=t3.c
31544   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31570   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31573   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31598   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31601   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31626   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31629   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31638   RIGHT JOIN t3 ON t1.c=t3.c
31641   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31653   RIGHT JOIN t3 ON t1.c=t3.c
31656   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31665   RIGHT JOIN t3 ON t1.c=t3.c
31668   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31677   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
31679   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31705   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
31708   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31719   WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
31720   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31729   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
31732   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31741   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
31743   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31769   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31771   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31823   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31826   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31847   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31850   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31902   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
31905   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31926   RIGHT JOIN t3 ON t1.c=t3.c
31929   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31966   RIGHT JOIN t3 ON t1.c=t3.c
31969   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32020   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
32023   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32048   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
32051   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32102   RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
32105   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32114   RIGHT JOIN t3 ON t1.c=t3.c
32117   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32129   RIGHT JOIN t3 ON t1.c=t3.c
32132   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32153   RIGHT JOIN t3 ON t1.c=t3.c
32156   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32165   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
32167   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32219   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
32222   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32245   WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
32246   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32267   RIGHT JOIN t3 ON t1.c IS NOT DISTINCT FROM t3.c AND t3.y>0
32270   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32279   RIGHT JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0
32281   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32333   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
32335   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32360   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
32363   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32378   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
32381   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32406   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
32409   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32424   FULL JOIN t3 ON t1.c=t3.c
32427   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32439   FULL JOIN t3 ON t1.c=t3.c
32442   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32467   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
32470   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32495   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
32498   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32523   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
32526   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32541   FULL JOIN t3 ON t1.c=t3.c
32544   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32556   FULL JOIN t3 ON t1.c=t3.c
32559   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32568   FULL JOIN t3 ON t1.c=t3.c
32571   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32580   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
32582   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32607   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
32610   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32627   WHERE t1.b = t2.b AND t1.c = t3.c
32628   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32637   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
32640   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32655   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
32657   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32765   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
32768   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32821   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
32824   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32930   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
32933   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32986   FULL JOIN t3 ON t1.c=t3.c
32989   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33026   FULL JOIN t3 ON t1.c=t3.c
33029   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33135   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
33138   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33163   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
33166   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33273   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
33276   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33291   FULL JOIN t3 ON t1.c=t3.c
33294   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33306   FULL JOIN t3 ON t1.c=t3.c
33309   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33330   FULL JOIN t3 ON t1.c=t3.c
33333   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33342   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
33344   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33452   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
33455   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33510   WHERE t1.b = t2.b AND t1.c = t3.c
33511   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33532   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
33535   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33550   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
33552   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33578   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
33581   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33596   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
33599   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33625   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
33628   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33643   FULL JOIN t3 ON t1.c=t3.c
33646   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33658   FULL JOIN t3 ON t1.c=t3.c
33661   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33687   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
33690   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33715   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
33718   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33743   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
33746   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33761   FULL JOIN t3 ON t1.c=t3.c
33764   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33776   FULL JOIN t3 ON t1.c=t3.c
33779   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33788   FULL JOIN t3 ON t1.c=t3.c
33791   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33800   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
33802   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33828   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
33831   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33848   WHERE t1.b = t2.b AND t1.c = t3.c
33849   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33858   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
33861   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33876   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
33878   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33987   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
33990   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34043   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
34046   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34153   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
34156   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34209   FULL JOIN t3 ON t1.c=t3.c
34212   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34249   FULL JOIN t3 ON t1.c=t3.c
34252   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34359   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
34362   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34387   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
34390   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34497   FULL JOIN t3 ON t1.c=t3.c AND t3.y>0
34500   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34515   FULL JOIN t3 ON t1.c=t3.c
34518   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34530   FULL JOIN t3 ON t1.c=t3.c
34533   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34554   FULL JOIN t3 ON t1.c=t3.c
34557   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34566   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
34568   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34677   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
34680   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34735   WHERE t1.b = t2.b AND t1.c = t3.c
34736   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34757   FULL JOIN t3 ON t1.c = t3.c AND t3.y>0
34760   ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34778     RIGHT JOIN t3 ON t1.c=t3.c AND t3.y>0
34780   CREATE TRIGGER v1r1 INSTEAD OF UPDATE OF c ON v1 BEGIN
34781     UPDATE t1 SET c=new.c WHERE (a,b,c,d) IS (old.a,old.b,old.c,old.d);
34782     UPDATE t3 SET c=new.c WHERE (c,y) IS (old.c,old.y);
34793   UPDATE v1 SET c=c+1000 WHERE y BETWEEN 30 and 40;
34816 # CREATE TABLE t1(a INT, b INT, c INT, d INT);
34817 # WITH RECURSIVE c(x) AS (VALUES(0) UNION ALL SELECT x+1 FROM c WHERE x<95)
34818 #   INSERT INTO t1(a,b,c,d) SELECT x, x+100, x+200, x+300 FROM c;
34822 # CREATE TABLE t3(c INT, y INT);
34823 # INSERT INTO t3(c,y) SELECT c, a FROM t1 WHERE a%3=0;
34824 # CREATE INDEX t3c ON t3(c);
34828 # INSERT INTO t1(a,b,c,d) VALUES
34849 # append q1 "          $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34851 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34864 #   append q1 "          $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34866 #   append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34879 # append q1 "          $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34882 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34894 # append q1 "          $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34897 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34909 # append q1 "          $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34912 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34924 # append q1 "          $j2 JOIN t3 ON t1.c=t3.c\n"
34927 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34939 # append q1 "          $j2 JOIN t3 ON t1.c=t3.c\n"
34942 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34954 # append q1 "          $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34957 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34969 # append q1 "          $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34972 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34984 # append q1 "          $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34987 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34999 # append q1 "          $j2 JOIN t3 ON t1.c=t3.c\n"
35002 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35014 # append q1 "          $j2 JOIN t3 ON t1.c=t3.c\n"
35017 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35029 # append q1 "          $j2 JOIN t3 ON t1.c=t3.c\n"
35032 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35047 # append q1 "          $j2 JOIN t3 ON t1.c $op2 t3.c AND t3.y>0\n"
35049 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35061 # append q1 "          $j2 JOIN t3 ON t1.c $op2 t3.c AND t3.y>0\n"
35064 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35078 # append q1 " WHERE t1.b $op1 t2.b AND t1.c $op2 t3.c\n"
35079 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35091 # append q1 "          $j2 JOIN t3 ON t1.c $op2 t3.c AND t3.y>0\n"
35094 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35107 #   append q1 "          $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
35109 #   append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35123 #   append q1 "          $j2 JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0\n"
35125 #   append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"