Lines Matching refs:d
39 CREATE TABLE t1(a INT, b INT, c INT, d INT);
41 INSERT INTO t1(a,b,c,d) SELECT x, x+100, x+200, x+300 FROM c;
48 CREATE TABLE t4(d INT, z INT);
49 INSERT INTO t4(d,z) SELECT d, a FROM t1 WHERE a%5=0;
50 CREATE INDEX t4d ON t4(d);
51 INSERT INTO t1(a,b,c,d) VALUES
62 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
63 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
73 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
74 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
84 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
86 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
96 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
98 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
108 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
110 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
120 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
122 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
132 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
134 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
144 INNER JOIN t4 ON t1.d=t4.d
146 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
156 INNER JOIN t4 ON t1.d=t4.d
158 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
168 INNER JOIN t4 ON t1.d=t4.d
170 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
180 INNER JOIN t4 ON t1.d=t4.d
182 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
192 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
194 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
204 INNER JOIN t4 ON t1.d=t4.d
206 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
216 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
217 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
227 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
229 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
239 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
241 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
252 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
253 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
263 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
264 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
274 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
275 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
285 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
286 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
308 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
309 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
331 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
333 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
355 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
357 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
379 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
381 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
403 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
405 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
427 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
429 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
451 LEFT JOIN t4 ON t1.d=t4.d
453 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
463 LEFT JOIN t4 ON t1.d=t4.d
465 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
487 LEFT JOIN t4 ON t1.d=t4.d
489 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
499 LEFT JOIN t4 ON t1.d=t4.d
501 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
511 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
513 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
535 LEFT JOIN t4 ON t1.d=t4.d
537 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
547 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
548 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
570 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
572 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
594 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
596 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
619 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
620 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
630 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
631 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
653 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
654 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
676 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
677 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
704 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
705 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
732 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
734 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
744 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
746 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
773 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
775 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
785 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
787 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
797 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
799 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
826 RIGHT JOIN t4 ON t1.d=t4.d
828 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
854 RIGHT JOIN t4 ON t1.d=t4.d
856 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
882 RIGHT JOIN t4 ON t1.d=t4.d
884 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
894 RIGHT JOIN t4 ON t1.d=t4.d
896 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
906 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
908 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
918 RIGHT JOIN t4 ON t1.d=t4.d
920 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
930 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
931 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
958 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
960 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
984 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
986 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
998 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
999 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1009 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
1010 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1037 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
1038 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1065 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
1066 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1105 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
1106 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1145 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
1147 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1169 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
1171 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1210 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
1212 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1234 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
1236 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1258 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
1260 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1299 FULL JOIN t4 ON t1.d=t4.d
1301 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1327 FULL JOIN t4 ON t1.d=t4.d
1329 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1367 FULL JOIN t4 ON t1.d=t4.d
1369 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1379 FULL JOIN t4 ON t1.d=t4.d
1381 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1391 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
1393 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1415 FULL JOIN t4 ON t1.d=t4.d
1417 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1427 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
1428 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1467 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
1469 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1505 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
1507 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1531 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d = t4.d
1532 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1542 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
1543 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1582 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
1583 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1622 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
1623 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1639 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
1640 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1656 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
1658 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1674 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
1676 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1692 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
1694 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1710 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
1712 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1722 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
1724 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1740 INNER JOIN t4 ON t1.d=t4.d
1742 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1758 INNER JOIN t4 ON t1.d=t4.d
1760 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1776 INNER JOIN t4 ON t1.d=t4.d
1778 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1794 INNER JOIN t4 ON t1.d=t4.d
1796 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1806 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
1808 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1818 INNER JOIN t4 ON t1.d=t4.d
1820 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1830 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
1831 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1847 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
1849 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1865 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
1867 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1878 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
1879 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1895 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
1896 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1912 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
1913 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1929 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
1930 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1984 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
1985 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2039 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
2041 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2095 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
2097 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2151 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
2153 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2207 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
2209 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2231 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
2233 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2287 LEFT JOIN t4 ON t1.d=t4.d
2289 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2305 LEFT JOIN t4 ON t1.d=t4.d
2307 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2361 LEFT JOIN t4 ON t1.d=t4.d
2363 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2379 LEFT JOIN t4 ON t1.d=t4.d
2381 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2391 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
2393 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2415 LEFT JOIN t4 ON t1.d=t4.d
2417 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2427 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
2428 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2482 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
2484 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2538 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
2540 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2563 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
2564 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2580 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
2581 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2635 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
2636 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2690 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
2691 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2718 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
2719 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2746 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
2748 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2764 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
2766 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2793 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
2795 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2811 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
2813 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2823 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
2825 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2852 RIGHT JOIN t4 ON t1.d=t4.d
2854 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2880 RIGHT JOIN t4 ON t1.d=t4.d
2882 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2908 RIGHT JOIN t4 ON t1.d=t4.d
2910 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2926 RIGHT JOIN t4 ON t1.d=t4.d
2928 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2938 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
2940 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2950 RIGHT JOIN t4 ON t1.d=t4.d
2952 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2962 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
2963 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2990 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
2992 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3009 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
3011 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3023 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
3024 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3040 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
3041 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3068 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
3069 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3096 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
3097 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3162 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
3163 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3228 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
3230 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3284 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
3286 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3351 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
3353 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3407 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
3409 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3431 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
3433 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3498 FULL JOIN t4 ON t1.d=t4.d
3500 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3526 FULL JOIN t4 ON t1.d=t4.d
3528 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3592 FULL JOIN t4 ON t1.d=t4.d
3594 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3610 FULL JOIN t4 ON t1.d=t4.d
3612 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3622 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
3624 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3646 FULL JOIN t4 ON t1.d=t4.d
3648 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3658 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
3659 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3724 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
3726 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3781 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
3783 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3807 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d = t4.d
3808 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3824 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
3825 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3890 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
3891 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3956 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
3957 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3967 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
3968 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3978 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
3980 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3990 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
3992 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4002 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
4004 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4014 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
4016 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4026 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
4028 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4038 INNER JOIN t4 ON t1.d=t4.d
4040 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4050 INNER JOIN t4 ON t1.d=t4.d
4052 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4062 INNER JOIN t4 ON t1.d=t4.d
4064 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4074 INNER JOIN t4 ON t1.d=t4.d
4076 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4086 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
4088 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4098 INNER JOIN t4 ON t1.d=t4.d
4100 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4110 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
4111 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4121 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
4123 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4133 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
4135 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4146 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
4147 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4157 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
4158 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4168 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
4169 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4179 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
4180 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4219 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
4220 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4259 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
4261 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4283 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
4285 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4324 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
4326 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4348 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
4350 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4388 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
4390 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4428 LEFT JOIN t4 ON t1.d=t4.d
4430 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4440 LEFT JOIN t4 ON t1.d=t4.d
4442 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4481 LEFT JOIN t4 ON t1.d=t4.d
4483 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4493 LEFT JOIN t4 ON t1.d=t4.d
4495 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4505 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
4507 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4529 LEFT JOIN t4 ON t1.d=t4.d
4531 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4541 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
4542 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4581 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
4583 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4606 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
4608 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4631 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
4632 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4642 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
4643 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4682 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
4683 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4722 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
4723 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4750 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
4751 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4778 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
4780 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4790 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
4792 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4819 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
4821 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4831 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
4833 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4843 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
4845 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4872 RIGHT JOIN t4 ON t1.d=t4.d
4874 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4900 RIGHT JOIN t4 ON t1.d=t4.d
4902 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4928 RIGHT JOIN t4 ON t1.d=t4.d
4930 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4940 RIGHT JOIN t4 ON t1.d=t4.d
4942 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4952 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
4954 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4964 RIGHT JOIN t4 ON t1.d=t4.d
4966 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4976 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
4977 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5004 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
5006 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5030 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
5032 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5044 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
5045 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5055 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
5056 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5083 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
5084 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5111 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
5112 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5168 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
5169 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5225 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
5227 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5249 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
5251 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5307 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
5309 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5331 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
5333 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5371 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
5373 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5428 FULL JOIN t4 ON t1.d=t4.d
5430 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5456 FULL JOIN t4 ON t1.d=t4.d
5458 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5513 FULL JOIN t4 ON t1.d=t4.d
5515 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5525 FULL JOIN t4 ON t1.d=t4.d
5527 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5537 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
5539 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5561 FULL JOIN t4 ON t1.d=t4.d
5563 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5573 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
5574 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5630 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
5632 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5669 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
5671 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5695 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d = t4.d
5696 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5706 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
5707 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5763 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
5764 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5820 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
5821 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5837 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
5838 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5854 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
5856 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5872 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
5874 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5890 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
5892 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5908 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
5910 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5920 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
5922 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5938 INNER JOIN t4 ON t1.d=t4.d
5940 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5956 INNER JOIN t4 ON t1.d=t4.d
5958 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5974 INNER JOIN t4 ON t1.d=t4.d
5976 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5992 INNER JOIN t4 ON t1.d=t4.d
5994 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6004 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
6006 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6016 INNER JOIN t4 ON t1.d=t4.d
6018 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6028 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
6029 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6045 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
6047 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6063 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
6065 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6076 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
6077 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6093 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
6094 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6110 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
6111 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6182 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
6183 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6254 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
6256 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6310 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
6312 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6383 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
6385 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6439 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
6441 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6479 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
6481 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6551 LEFT JOIN t4 ON t1.d=t4.d
6553 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6569 LEFT JOIN t4 ON t1.d=t4.d
6571 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6642 LEFT JOIN t4 ON t1.d=t4.d
6644 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6660 LEFT JOIN t4 ON t1.d=t4.d
6662 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6672 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
6674 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6696 LEFT JOIN t4 ON t1.d=t4.d
6698 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6708 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
6709 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6780 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
6782 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6837 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
6839 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6862 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
6863 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6879 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
6880 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6951 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
6952 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6979 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
6980 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7007 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
7009 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7025 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
7027 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7054 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
7056 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7072 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
7074 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7084 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
7086 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7113 RIGHT JOIN t4 ON t1.d=t4.d
7115 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7141 RIGHT JOIN t4 ON t1.d=t4.d
7143 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7169 RIGHT JOIN t4 ON t1.d=t4.d
7171 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7187 RIGHT JOIN t4 ON t1.d=t4.d
7189 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7199 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
7201 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7211 RIGHT JOIN t4 ON t1.d=t4.d
7213 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7223 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
7224 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7251 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
7253 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7270 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
7272 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7283 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
7284 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7300 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
7301 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7328 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
7329 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7411 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
7412 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7494 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
7496 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7550 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
7552 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7634 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
7636 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7690 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
7692 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7730 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
7732 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7813 FULL JOIN t4 ON t1.d=t4.d
7815 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7841 FULL JOIN t4 ON t1.d=t4.d
7843 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7924 FULL JOIN t4 ON t1.d=t4.d
7926 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7942 FULL JOIN t4 ON t1.d=t4.d
7944 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7954 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
7956 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7978 FULL JOIN t4 ON t1.d=t4.d
7980 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7990 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
7991 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8073 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
8075 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8131 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
8133 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8156 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d = t4.d
8157 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8173 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
8174 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8256 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
8257 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8270 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
8271 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8284 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
8286 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8296 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
8298 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8311 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
8313 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8323 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
8325 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8338 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
8340 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8353 INNER JOIN t4 ON t1.d=t4.d
8355 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8368 INNER JOIN t4 ON t1.d=t4.d
8370 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8383 INNER JOIN t4 ON t1.d=t4.d
8385 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8395 INNER JOIN t4 ON t1.d=t4.d
8397 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8410 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
8412 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8422 INNER JOIN t4 ON t1.d=t4.d
8424 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8434 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
8435 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8448 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
8450 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8460 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
8462 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8473 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
8474 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8484 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
8485 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8498 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
8499 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8512 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
8513 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8551 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
8552 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8590 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
8592 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8614 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
8616 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8654 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
8656 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8678 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
8680 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8718 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
8720 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8758 LEFT JOIN t4 ON t1.d=t4.d
8760 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8773 LEFT JOIN t4 ON t1.d=t4.d
8775 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8813 LEFT JOIN t4 ON t1.d=t4.d
8815 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8825 LEFT JOIN t4 ON t1.d=t4.d
8827 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8840 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
8842 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8864 LEFT JOIN t4 ON t1.d=t4.d
8866 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8876 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
8877 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8915 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
8917 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8939 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
8941 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8964 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
8965 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8975 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
8976 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9014 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
9015 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9053 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
9054 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9081 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
9082 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9109 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
9111 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9121 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
9123 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9150 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
9152 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9162 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
9164 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9177 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
9179 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9206 RIGHT JOIN t4 ON t1.d=t4.d
9208 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9234 RIGHT JOIN t4 ON t1.d=t4.d
9236 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9262 RIGHT JOIN t4 ON t1.d=t4.d
9264 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9274 RIGHT JOIN t4 ON t1.d=t4.d
9276 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9289 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
9291 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9301 RIGHT JOIN t4 ON t1.d=t4.d
9303 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9313 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
9314 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9341 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
9343 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9367 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
9369 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9381 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
9382 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9392 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
9393 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9420 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
9421 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9448 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
9449 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9501 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
9502 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9554 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
9556 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9578 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
9580 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9632 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
9634 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9656 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
9658 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9696 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
9698 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9750 FULL JOIN t4 ON t1.d=t4.d
9752 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9778 FULL JOIN t4 ON t1.d=t4.d
9780 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9831 FULL JOIN t4 ON t1.d=t4.d
9833 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9843 FULL JOIN t4 ON t1.d=t4.d
9845 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9858 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
9860 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9882 FULL JOIN t4 ON t1.d=t4.d
9884 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9894 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
9895 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9947 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
9949 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9985 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
9987 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10011 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d = t4.d
10012 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10022 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
10023 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10075 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
10076 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10128 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
10129 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10155 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
10156 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10182 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
10184 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10200 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
10202 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10228 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
10230 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10246 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
10248 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10261 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
10263 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10289 INNER JOIN t4 ON t1.d=t4.d
10291 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10317 INNER JOIN t4 ON t1.d=t4.d
10319 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10345 INNER JOIN t4 ON t1.d=t4.d
10347 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10363 INNER JOIN t4 ON t1.d=t4.d
10365 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10378 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
10380 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10390 INNER JOIN t4 ON t1.d=t4.d
10392 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10402 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
10403 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10429 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
10431 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10447 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
10449 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10460 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
10461 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10477 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
10478 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10504 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
10505 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10531 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
10532 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10639 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
10640 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10747 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
10749 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10803 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
10805 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10911 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
10913 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10967 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
10969 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11007 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
11009 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11115 LEFT JOIN t4 ON t1.d=t4.d
11117 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11143 LEFT JOIN t4 ON t1.d=t4.d
11145 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11251 LEFT JOIN t4 ON t1.d=t4.d
11253 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11269 LEFT JOIN t4 ON t1.d=t4.d
11271 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11284 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
11286 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11308 LEFT JOIN t4 ON t1.d=t4.d
11310 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11320 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
11321 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11428 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
11430 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11484 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
11486 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11509 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
11510 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11526 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
11527 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11634 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
11635 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11742 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
11743 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11770 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
11771 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11798 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
11800 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11816 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
11818 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11845 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
11847 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11863 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
11865 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11878 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
11880 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11907 RIGHT JOIN t4 ON t1.d=t4.d
11909 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11935 RIGHT JOIN t4 ON t1.d=t4.d
11937 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11963 RIGHT JOIN t4 ON t1.d=t4.d
11965 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11981 RIGHT JOIN t4 ON t1.d=t4.d
11983 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11996 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
11998 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12008 RIGHT JOIN t4 ON t1.d=t4.d
12010 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12020 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
12021 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12048 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
12050 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12067 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
12069 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12081 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
12082 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12098 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
12099 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12126 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
12127 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12154 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
12155 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12263 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
12264 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12372 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
12374 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12428 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
12430 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12537 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
12539 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12593 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
12595 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12633 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
12635 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12742 FULL JOIN t4 ON t1.d=t4.d
12744 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12770 FULL JOIN t4 ON t1.d=t4.d
12772 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12878 FULL JOIN t4 ON t1.d=t4.d
12880 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12896 FULL JOIN t4 ON t1.d=t4.d
12898 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12911 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
12913 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12935 FULL JOIN t4 ON t1.d=t4.d
12937 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12947 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
12948 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13056 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
13058 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13113 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
13115 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13139 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d = t4.d
13140 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13156 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
13157 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13265 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
13266 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13374 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
13375 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13388 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
13389 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13402 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
13404 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13414 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
13416 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13429 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
13431 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13441 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
13443 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13456 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
13458 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13471 INNER JOIN t4 ON t1.d=t4.d
13473 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13486 INNER JOIN t4 ON t1.d=t4.d
13488 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13501 INNER JOIN t4 ON t1.d=t4.d
13503 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13513 INNER JOIN t4 ON t1.d=t4.d
13515 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13528 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
13530 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13540 INNER JOIN t4 ON t1.d=t4.d
13542 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13552 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
13553 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13566 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
13568 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13578 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
13580 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13591 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
13592 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13602 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
13603 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13616 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
13617 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13630 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
13631 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13670 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
13671 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13710 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
13712 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13734 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
13736 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13775 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
13777 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13799 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
13801 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13839 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
13841 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13879 LEFT JOIN t4 ON t1.d=t4.d
13881 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13894 LEFT JOIN t4 ON t1.d=t4.d
13896 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13935 LEFT JOIN t4 ON t1.d=t4.d
13937 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13947 LEFT JOIN t4 ON t1.d=t4.d
13949 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13962 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
13964 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13986 LEFT JOIN t4 ON t1.d=t4.d
13988 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13998 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
13999 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14038 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
14040 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14063 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
14065 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14088 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
14089 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14099 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
14100 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14139 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
14140 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14179 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
14180 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14207 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
14208 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14235 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
14237 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14247 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
14249 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14276 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
14278 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14288 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
14290 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14303 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
14305 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14332 RIGHT JOIN t4 ON t1.d=t4.d
14334 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14360 RIGHT JOIN t4 ON t1.d=t4.d
14362 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14388 RIGHT JOIN t4 ON t1.d=t4.d
14390 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14400 RIGHT JOIN t4 ON t1.d=t4.d
14402 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14415 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
14417 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14427 RIGHT JOIN t4 ON t1.d=t4.d
14429 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14439 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
14440 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14467 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
14469 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14493 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
14495 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14507 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
14508 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14518 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
14519 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14546 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
14547 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14574 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
14575 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14628 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
14629 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14682 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
14684 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14706 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
14708 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14761 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
14763 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14785 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
14787 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14825 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
14827 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14879 FULL JOIN t4 ON t1.d=t4.d
14881 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14907 FULL JOIN t4 ON t1.d=t4.d
14909 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14961 FULL JOIN t4 ON t1.d=t4.d
14963 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14973 FULL JOIN t4 ON t1.d=t4.d
14975 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14988 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
14990 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15012 FULL JOIN t4 ON t1.d=t4.d
15014 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15024 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
15025 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15078 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
15080 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15117 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
15119 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15143 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d = t4.d
15144 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15154 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
15155 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15208 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
15209 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15262 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
15263 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15289 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
15290 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15316 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
15318 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15334 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
15336 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15362 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
15364 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15380 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
15382 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15395 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
15397 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15423 INNER JOIN t4 ON t1.d=t4.d
15425 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15451 INNER JOIN t4 ON t1.d=t4.d
15453 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15479 INNER JOIN t4 ON t1.d=t4.d
15481 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15497 INNER JOIN t4 ON t1.d=t4.d
15499 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15512 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
15514 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15524 INNER JOIN t4 ON t1.d=t4.d
15526 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15536 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
15537 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15563 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
15565 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15581 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
15583 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15594 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
15595 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15611 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
15612 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15638 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
15639 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15747 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
15748 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15856 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
15858 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15912 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
15914 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16021 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
16023 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16077 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
16079 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16117 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
16119 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16225 LEFT JOIN t4 ON t1.d=t4.d
16227 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16253 LEFT JOIN t4 ON t1.d=t4.d
16255 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16362 LEFT JOIN t4 ON t1.d=t4.d
16364 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16380 LEFT JOIN t4 ON t1.d=t4.d
16382 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16395 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
16397 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16419 LEFT JOIN t4 ON t1.d=t4.d
16421 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16431 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
16432 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16540 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
16542 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16597 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
16599 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16622 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
16623 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16639 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
16640 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16748 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
16749 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16776 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
16777 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16804 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
16806 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16822 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
16824 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16851 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
16853 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16869 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
16871 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16884 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
16886 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16913 RIGHT JOIN t4 ON t1.d=t4.d
16915 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16941 RIGHT JOIN t4 ON t1.d=t4.d
16943 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16969 RIGHT JOIN t4 ON t1.d=t4.d
16971 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16987 RIGHT JOIN t4 ON t1.d=t4.d
16989 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17002 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
17004 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17014 RIGHT JOIN t4 ON t1.d=t4.d
17016 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17026 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
17027 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17054 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
17056 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17073 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
17075 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17086 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
17087 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17103 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
17104 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17131 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
17132 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17241 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
17242 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17351 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
17353 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17407 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
17409 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17517 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
17519 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17573 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
17575 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17613 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
17615 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17722 FULL JOIN t4 ON t1.d=t4.d
17724 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17750 FULL JOIN t4 ON t1.d=t4.d
17752 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17859 FULL JOIN t4 ON t1.d=t4.d
17861 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17877 FULL JOIN t4 ON t1.d=t4.d
17879 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17892 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
17894 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17916 FULL JOIN t4 ON t1.d=t4.d
17918 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17928 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
17929 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18038 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
18040 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18096 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
18098 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18121 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d = t4.d
18122 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18138 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
18139 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18248 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
18249 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18259 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
18260 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18270 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
18272 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18282 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
18284 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18294 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
18296 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18306 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
18308 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18318 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
18320 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18330 INNER JOIN t4 ON t1.d=t4.d
18332 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18342 INNER JOIN t4 ON t1.d=t4.d
18344 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18354 INNER JOIN t4 ON t1.d=t4.d
18356 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18366 INNER JOIN t4 ON t1.d=t4.d
18368 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18378 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
18380 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18390 INNER JOIN t4 ON t1.d=t4.d
18392 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18402 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
18403 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18413 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
18415 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18425 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
18427 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18438 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
18439 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18449 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
18450 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18460 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
18461 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18471 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
18472 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18494 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
18495 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18517 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
18519 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18541 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
18543 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18565 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
18567 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18589 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
18591 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18613 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
18615 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18637 LEFT JOIN t4 ON t1.d=t4.d
18639 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18649 LEFT JOIN t4 ON t1.d=t4.d
18651 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18673 LEFT JOIN t4 ON t1.d=t4.d
18675 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18685 LEFT JOIN t4 ON t1.d=t4.d
18687 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18697 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
18699 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18721 LEFT JOIN t4 ON t1.d=t4.d
18723 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18733 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
18734 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18756 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
18758 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18780 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
18782 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18805 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
18806 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18816 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
18817 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18839 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
18840 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18862 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
18863 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18890 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
18891 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18918 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
18920 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18930 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
18932 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18959 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
18961 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18971 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
18973 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18983 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
18985 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19012 RIGHT JOIN t4 ON t1.d=t4.d
19014 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19040 RIGHT JOIN t4 ON t1.d=t4.d
19042 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19068 RIGHT JOIN t4 ON t1.d=t4.d
19070 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19080 RIGHT JOIN t4 ON t1.d=t4.d
19082 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19092 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
19094 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19104 RIGHT JOIN t4 ON t1.d=t4.d
19106 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19116 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
19117 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19144 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
19146 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19170 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
19172 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19184 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
19185 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19195 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
19196 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19223 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
19224 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19251 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
19252 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19291 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
19292 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19331 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
19333 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19355 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
19357 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19396 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
19398 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19420 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
19422 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19444 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
19446 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19485 FULL JOIN t4 ON t1.d=t4.d
19487 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19513 FULL JOIN t4 ON t1.d=t4.d
19515 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19553 FULL JOIN t4 ON t1.d=t4.d
19555 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19565 FULL JOIN t4 ON t1.d=t4.d
19567 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19577 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
19579 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19601 FULL JOIN t4 ON t1.d=t4.d
19603 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19613 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
19614 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19653 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
19655 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19691 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
19693 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19717 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d = t4.d
19718 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19728 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
19729 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19768 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
19769 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19808 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
19809 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19825 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
19826 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19842 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
19844 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19860 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
19862 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19878 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
19880 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19896 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
19898 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19908 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
19910 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19926 INNER JOIN t4 ON t1.d=t4.d
19928 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19944 INNER JOIN t4 ON t1.d=t4.d
19946 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19962 INNER JOIN t4 ON t1.d=t4.d
19964 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19980 INNER JOIN t4 ON t1.d=t4.d
19982 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19992 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
19994 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20004 INNER JOIN t4 ON t1.d=t4.d
20006 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20016 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
20017 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20033 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
20035 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20051 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
20053 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20064 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
20065 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20081 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
20082 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20098 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
20099 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20115 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
20116 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20171 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
20172 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20227 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
20229 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20283 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
20285 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20339 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
20341 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20395 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
20397 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20419 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
20421 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20476 LEFT JOIN t4 ON t1.d=t4.d
20478 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20494 LEFT JOIN t4 ON t1.d=t4.d
20496 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20551 LEFT JOIN t4 ON t1.d=t4.d
20553 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20569 LEFT JOIN t4 ON t1.d=t4.d
20571 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20581 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
20583 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20605 LEFT JOIN t4 ON t1.d=t4.d
20607 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20617 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
20618 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20673 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
20675 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20729 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
20731 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20754 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
20755 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20771 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
20772 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20827 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
20828 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20883 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
20884 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20911 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
20912 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20939 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
20941 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20957 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
20959 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20986 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
20988 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21004 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
21006 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21016 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
21018 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21045 RIGHT JOIN t4 ON t1.d=t4.d
21047 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21073 RIGHT JOIN t4 ON t1.d=t4.d
21075 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21101 RIGHT JOIN t4 ON t1.d=t4.d
21103 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21119 RIGHT JOIN t4 ON t1.d=t4.d
21121 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21131 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
21133 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21143 RIGHT JOIN t4 ON t1.d=t4.d
21145 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21155 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
21156 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21183 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
21185 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21202 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
21204 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21216 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
21217 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21233 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
21234 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21261 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
21262 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21289 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
21290 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21356 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
21357 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21423 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
21425 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21479 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
21481 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21546 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
21548 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21602 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
21604 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21626 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
21628 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21694 FULL JOIN t4 ON t1.d=t4.d
21696 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21722 FULL JOIN t4 ON t1.d=t4.d
21724 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21789 FULL JOIN t4 ON t1.d=t4.d
21791 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21807 FULL JOIN t4 ON t1.d=t4.d
21809 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21819 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
21821 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21843 FULL JOIN t4 ON t1.d=t4.d
21845 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21855 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
21856 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21922 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
21924 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21979 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
21981 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22005 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d = t4.d
22006 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22022 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
22023 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22089 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
22090 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22156 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
22157 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22167 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
22168 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22178 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
22180 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22190 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
22192 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22202 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
22204 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22214 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
22216 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22226 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
22228 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22238 INNER JOIN t4 ON t1.d=t4.d
22240 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22250 INNER JOIN t4 ON t1.d=t4.d
22252 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22262 INNER JOIN t4 ON t1.d=t4.d
22264 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22274 INNER JOIN t4 ON t1.d=t4.d
22276 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22286 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
22288 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22298 INNER JOIN t4 ON t1.d=t4.d
22300 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22310 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
22311 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22321 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
22323 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22333 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
22335 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22346 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
22347 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22357 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
22358 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22368 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
22369 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22379 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
22380 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22419 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
22420 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22459 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
22461 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22483 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
22485 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22524 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
22526 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22548 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
22550 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22588 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
22590 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22628 LEFT JOIN t4 ON t1.d=t4.d
22630 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22640 LEFT JOIN t4 ON t1.d=t4.d
22642 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22681 LEFT JOIN t4 ON t1.d=t4.d
22683 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22693 LEFT JOIN t4 ON t1.d=t4.d
22695 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22705 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
22707 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22729 LEFT JOIN t4 ON t1.d=t4.d
22731 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22741 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
22742 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22781 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
22783 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22806 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
22808 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22831 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
22832 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22842 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
22843 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22882 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
22883 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22922 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
22923 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22950 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
22951 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22978 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
22980 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22990 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
22992 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23019 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
23021 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23031 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
23033 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23043 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
23045 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23072 RIGHT JOIN t4 ON t1.d=t4.d
23074 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23100 RIGHT JOIN t4 ON t1.d=t4.d
23102 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23128 RIGHT JOIN t4 ON t1.d=t4.d
23130 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23140 RIGHT JOIN t4 ON t1.d=t4.d
23142 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23152 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
23154 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23164 RIGHT JOIN t4 ON t1.d=t4.d
23166 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23176 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
23177 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23204 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
23206 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23230 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
23232 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23244 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
23245 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23255 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
23256 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23283 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
23284 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23311 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
23312 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23368 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
23369 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23425 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
23427 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23449 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
23451 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23507 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
23509 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23531 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
23533 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23571 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
23573 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23628 FULL JOIN t4 ON t1.d=t4.d
23630 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23656 FULL JOIN t4 ON t1.d=t4.d
23658 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23713 FULL JOIN t4 ON t1.d=t4.d
23715 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23725 FULL JOIN t4 ON t1.d=t4.d
23727 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23737 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
23739 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23761 FULL JOIN t4 ON t1.d=t4.d
23763 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23773 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
23774 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23830 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
23832 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23869 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
23871 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23895 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d = t4.d
23896 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23906 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
23907 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23963 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
23964 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24020 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
24021 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24037 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
24038 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24054 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
24056 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24072 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
24074 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24090 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
24092 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24108 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
24110 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24120 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
24122 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24138 INNER JOIN t4 ON t1.d=t4.d
24140 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24156 INNER JOIN t4 ON t1.d=t4.d
24158 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24174 INNER JOIN t4 ON t1.d=t4.d
24176 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24192 INNER JOIN t4 ON t1.d=t4.d
24194 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24204 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
24206 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24216 INNER JOIN t4 ON t1.d=t4.d
24218 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24228 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
24229 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24245 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
24247 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24263 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
24265 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24276 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
24277 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24293 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
24294 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24310 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
24311 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24383 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
24384 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24456 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
24458 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24512 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
24514 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24585 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
24587 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24641 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
24643 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24681 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
24683 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24754 LEFT JOIN t4 ON t1.d=t4.d
24756 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24772 LEFT JOIN t4 ON t1.d=t4.d
24774 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24846 LEFT JOIN t4 ON t1.d=t4.d
24848 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24864 LEFT JOIN t4 ON t1.d=t4.d
24866 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24876 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
24878 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24900 LEFT JOIN t4 ON t1.d=t4.d
24902 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24912 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
24913 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24985 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
24987 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25042 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
25044 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25067 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
25068 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25084 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
25085 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25157 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
25158 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25185 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
25186 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25213 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
25215 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25231 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
25233 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25260 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
25262 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25278 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
25280 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25290 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
25292 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25319 RIGHT JOIN t4 ON t1.d=t4.d
25321 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25347 RIGHT JOIN t4 ON t1.d=t4.d
25349 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25375 RIGHT JOIN t4 ON t1.d=t4.d
25377 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25393 RIGHT JOIN t4 ON t1.d=t4.d
25395 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25405 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
25407 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25417 RIGHT JOIN t4 ON t1.d=t4.d
25419 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25429 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
25430 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25457 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
25459 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25476 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
25478 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25489 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d IS NOT DISTINCT FROM t4.d
25490 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25506 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
25507 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25534 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
25535 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25618 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
25619 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25702 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
25704 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25758 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
25760 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25842 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
25844 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25898 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
25900 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25938 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
25940 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26022 FULL JOIN t4 ON t1.d=t4.d
26024 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26050 FULL JOIN t4 ON t1.d=t4.d
26052 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26134 FULL JOIN t4 ON t1.d=t4.d
26136 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26152 FULL JOIN t4 ON t1.d=t4.d
26154 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26164 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
26166 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26188 FULL JOIN t4 ON t1.d=t4.d
26190 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26200 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
26201 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26284 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
26286 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26342 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
26344 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26367 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.d = t4.d
26368 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26384 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
26385 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26468 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
26469 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26482 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
26484 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26494 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
26496 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26509 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
26511 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26521 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
26523 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26536 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
26538 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26551 INNER JOIN t4 ON t1.d=t4.d
26553 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26566 INNER JOIN t4 ON t1.d=t4.d
26568 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26581 INNER JOIN t4 ON t1.d=t4.d
26583 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26593 INNER JOIN t4 ON t1.d=t4.d
26595 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26608 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
26610 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26620 INNER JOIN t4 ON t1.d=t4.d
26622 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26632 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
26633 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26646 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
26648 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26658 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
26660 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26671 WHERE t1.b = t2.b AND t1.d IS NOT DISTINCT FROM t4.d
26672 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26682 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
26683 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26696 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
26697 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26735 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
26737 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26759 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
26761 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26799 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
26801 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26823 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
26825 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26863 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
26865 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26903 LEFT JOIN t4 ON t1.d=t4.d
26905 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26918 LEFT JOIN t4 ON t1.d=t4.d
26920 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26958 LEFT JOIN t4 ON t1.d=t4.d
26960 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26970 LEFT JOIN t4 ON t1.d=t4.d
26972 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26985 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
26987 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27009 LEFT JOIN t4 ON t1.d=t4.d
27011 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27021 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
27022 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27060 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
27062 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27084 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
27086 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27109 WHERE t1.b = t2.b AND t1.d IS NOT DISTINCT FROM t4.d
27110 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27120 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
27121 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27159 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
27160 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27187 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
27189 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27199 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
27201 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27228 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
27230 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27240 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
27242 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27255 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
27257 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27284 RIGHT JOIN t4 ON t1.d=t4.d
27286 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27312 RIGHT JOIN t4 ON t1.d=t4.d
27314 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27340 RIGHT JOIN t4 ON t1.d=t4.d
27342 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27352 RIGHT JOIN t4 ON t1.d=t4.d
27354 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27367 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
27369 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27379 RIGHT JOIN t4 ON t1.d=t4.d
27381 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27391 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
27392 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27419 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
27421 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27431 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
27433 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27444 WHERE t1.b = t2.b AND t1.d IS NOT DISTINCT FROM t4.d
27445 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27455 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
27456 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27483 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
27484 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27536 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
27538 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27560 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
27562 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27614 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
27616 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27638 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
27640 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27678 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
27680 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27732 FULL JOIN t4 ON t1.d=t4.d
27734 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27760 FULL JOIN t4 ON t1.d=t4.d
27762 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27813 FULL JOIN t4 ON t1.d=t4.d
27815 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27825 FULL JOIN t4 ON t1.d=t4.d
27827 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27840 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
27842 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27864 FULL JOIN t4 ON t1.d=t4.d
27866 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27876 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
27877 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27929 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
27931 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27953 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
27955 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27978 WHERE t1.b = t2.b AND t1.d = t4.d
27979 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27989 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
27990 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28042 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
28043 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28069 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
28071 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28087 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
28089 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28115 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
28117 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28133 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
28135 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28148 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
28150 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28176 INNER JOIN t4 ON t1.d=t4.d
28178 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28204 INNER JOIN t4 ON t1.d=t4.d
28206 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28232 INNER JOIN t4 ON t1.d=t4.d
28234 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28250 INNER JOIN t4 ON t1.d=t4.d
28252 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28265 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
28267 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28277 INNER JOIN t4 ON t1.d=t4.d
28279 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28289 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
28290 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28316 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
28318 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28334 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
28336 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28347 WHERE t1.b = t2.b AND t1.d IS NOT DISTINCT FROM t4.d
28348 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28364 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
28365 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28391 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
28392 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28500 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
28502 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28556 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
28558 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28664 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
28666 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28720 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
28722 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28760 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
28762 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28869 LEFT JOIN t4 ON t1.d=t4.d
28871 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28897 LEFT JOIN t4 ON t1.d=t4.d
28899 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29006 LEFT JOIN t4 ON t1.d=t4.d
29008 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29024 LEFT JOIN t4 ON t1.d=t4.d
29026 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29039 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
29041 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29063 LEFT JOIN t4 ON t1.d=t4.d
29065 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29075 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
29076 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29184 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
29186 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29240 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
29242 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29265 WHERE t1.b = t2.b AND t1.d IS NOT DISTINCT FROM t4.d
29266 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29282 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
29283 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29391 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
29392 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29419 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
29421 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29437 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
29439 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29466 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
29468 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29484 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
29486 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29499 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
29501 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29528 RIGHT JOIN t4 ON t1.d=t4.d
29530 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29556 RIGHT JOIN t4 ON t1.d=t4.d
29558 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29584 RIGHT JOIN t4 ON t1.d=t4.d
29586 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29602 RIGHT JOIN t4 ON t1.d=t4.d
29604 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29617 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
29619 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29629 RIGHT JOIN t4 ON t1.d=t4.d
29631 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29641 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
29642 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29669 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
29671 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29687 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
29689 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29700 WHERE t1.b = t2.b AND t1.d IS NOT DISTINCT FROM t4.d
29701 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29717 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
29718 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29745 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
29746 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29855 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
29857 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29911 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
29913 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30020 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
30022 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30076 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
30078 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30116 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
30118 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30226 FULL JOIN t4 ON t1.d=t4.d
30228 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30254 FULL JOIN t4 ON t1.d=t4.d
30256 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30363 FULL JOIN t4 ON t1.d=t4.d
30365 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30381 FULL JOIN t4 ON t1.d=t4.d
30383 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30396 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
30398 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30420 FULL JOIN t4 ON t1.d=t4.d
30422 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30432 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
30433 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30542 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
30544 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30598 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
30600 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30623 WHERE t1.b = t2.b AND t1.d = t4.d
30624 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30640 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
30641 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30750 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
30751 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30764 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
30766 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30776 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
30778 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30791 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
30793 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30803 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
30805 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30818 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
30820 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30833 INNER JOIN t4 ON t1.d=t4.d
30835 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30848 INNER JOIN t4 ON t1.d=t4.d
30850 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30863 INNER JOIN t4 ON t1.d=t4.d
30865 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30875 INNER JOIN t4 ON t1.d=t4.d
30877 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30890 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
30892 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30902 INNER JOIN t4 ON t1.d=t4.d
30904 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30914 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
30915 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30928 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
30930 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30940 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
30942 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30953 WHERE t1.b = t2.b AND t1.d IS NOT DISTINCT FROM t4.d
30954 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30964 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
30965 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30978 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
30979 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31018 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
31020 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31042 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
31044 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31083 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
31085 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31107 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
31109 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31147 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
31149 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31187 LEFT JOIN t4 ON t1.d=t4.d
31189 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31202 LEFT JOIN t4 ON t1.d=t4.d
31204 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31243 LEFT JOIN t4 ON t1.d=t4.d
31245 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31255 LEFT JOIN t4 ON t1.d=t4.d
31257 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31270 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
31272 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31294 LEFT JOIN t4 ON t1.d=t4.d
31296 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31306 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
31307 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31346 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
31348 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31370 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
31372 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31395 WHERE t1.b = t2.b AND t1.d IS NOT DISTINCT FROM t4.d
31396 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31406 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
31407 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31446 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
31447 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31474 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
31476 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31486 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
31488 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31515 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
31517 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31527 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
31529 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31542 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
31544 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31571 RIGHT JOIN t4 ON t1.d=t4.d
31573 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31599 RIGHT JOIN t4 ON t1.d=t4.d
31601 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31627 RIGHT JOIN t4 ON t1.d=t4.d
31629 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31639 RIGHT JOIN t4 ON t1.d=t4.d
31641 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31654 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
31656 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31666 RIGHT JOIN t4 ON t1.d=t4.d
31668 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31678 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
31679 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31706 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
31708 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31718 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
31720 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31731 WHERE t1.b = t2.b AND t1.d IS NOT DISTINCT FROM t4.d
31732 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31742 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
31743 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31770 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
31771 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31824 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
31826 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31848 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
31850 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31903 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
31905 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31927 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
31929 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31967 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
31969 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32021 FULL JOIN t4 ON t1.d=t4.d
32023 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32049 FULL JOIN t4 ON t1.d=t4.d
32051 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32103 FULL JOIN t4 ON t1.d=t4.d
32105 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32115 FULL JOIN t4 ON t1.d=t4.d
32117 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32130 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
32132 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32154 FULL JOIN t4 ON t1.d=t4.d
32156 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32166 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
32167 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32220 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
32222 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32244 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
32246 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32269 WHERE t1.b = t2.b AND t1.d = t4.d
32270 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32280 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
32281 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32334 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
32335 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32361 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
32363 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32379 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
32381 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32407 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
32409 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32425 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
32427 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32440 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
32442 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32468 INNER JOIN t4 ON t1.d=t4.d
32470 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32496 INNER JOIN t4 ON t1.d=t4.d
32498 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32524 INNER JOIN t4 ON t1.d=t4.d
32526 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32542 INNER JOIN t4 ON t1.d=t4.d
32544 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32557 INNER JOIN t4 ON t1.d=t4.d AND t4.z>0
32559 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32569 INNER JOIN t4 ON t1.d=t4.d
32571 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32581 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
32582 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32608 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
32610 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32626 INNER JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
32628 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32639 WHERE t1.b = t2.b AND t1.d IS NOT DISTINCT FROM t4.d
32640 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32656 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
32657 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32766 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
32768 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32822 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
32824 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32931 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
32933 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32987 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
32989 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33027 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
33029 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33136 LEFT JOIN t4 ON t1.d=t4.d
33138 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33164 LEFT JOIN t4 ON t1.d=t4.d
33166 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33274 LEFT JOIN t4 ON t1.d=t4.d
33276 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33292 LEFT JOIN t4 ON t1.d=t4.d
33294 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33307 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0
33309 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33331 LEFT JOIN t4 ON t1.d=t4.d
33333 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33343 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
33344 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33453 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
33455 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33509 LEFT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
33511 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33534 WHERE t1.b = t2.b AND t1.d IS NOT DISTINCT FROM t4.d
33535 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33551 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
33552 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33579 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
33581 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33597 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
33599 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33626 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
33628 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33644 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
33646 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33659 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
33661 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33688 RIGHT JOIN t4 ON t1.d=t4.d
33690 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33716 RIGHT JOIN t4 ON t1.d=t4.d
33718 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33744 RIGHT JOIN t4 ON t1.d=t4.d
33746 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33762 RIGHT JOIN t4 ON t1.d=t4.d
33764 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33777 RIGHT JOIN t4 ON t1.d=t4.d AND t4.z>0
33779 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33789 RIGHT JOIN t4 ON t1.d=t4.d
33791 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33801 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
33802 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33829 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
33831 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33847 RIGHT JOIN t4 ON t1.d IS NOT DISTINCT FROM t4.d AND t4.z>0
33849 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33860 WHERE t1.b = t2.b AND t1.d IS NOT DISTINCT FROM t4.d
33861 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33877 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
33878 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33988 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
33990 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34044 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
34046 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34154 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
34156 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34210 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
34212 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34250 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
34252 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34360 FULL JOIN t4 ON t1.d=t4.d
34362 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34388 FULL JOIN t4 ON t1.d=t4.d
34390 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34498 FULL JOIN t4 ON t1.d=t4.d
34500 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34516 FULL JOIN t4 ON t1.d=t4.d
34518 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34531 FULL JOIN t4 ON t1.d=t4.d AND t4.z>0
34533 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34555 FULL JOIN t4 ON t1.d=t4.d
34557 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34567 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
34568 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34678 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
34680 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34734 FULL JOIN t4 ON t1.d = t4.d AND t4.z>0
34736 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34759 WHERE t1.b = t2.b AND t1.d = t4.d
34760 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34779 LEFT JOIN t4 ON t1.d=t4.d AND t4.z>0;
34781 UPDATE t1 SET c=new.c WHERE (a,b,c,d) IS (old.a,old.b,old.c,old.d);
34816 # CREATE TABLE t1(a INT, b INT, c INT, d INT);
34818 # INSERT INTO t1(a,b,c,d) SELECT x, x+100, x+200, x+300 FROM c;
34825 # CREATE TABLE t4(d INT, z INT);
34826 # INSERT INTO t4(d,z) SELECT d, a FROM t1 WHERE a%5=0;
34827 # CREATE INDEX t4d ON t4(d);
34828 # INSERT INTO t1(a,b,c,d) VALUES
34850 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
34851 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34865 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
34866 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34880 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
34882 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34895 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
34897 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34910 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
34912 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34925 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
34927 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34940 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
34942 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34955 # append q1 " $j3 JOIN t4 ON t1.d=t4.d\n"
34957 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34970 # append q1 " $j3 JOIN t4 ON t1.d=t4.d\n"
34972 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34985 # append q1 " $j3 JOIN t4 ON t1.d=t4.d\n"
34987 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35000 # append q1 " $j3 JOIN t4 ON t1.d=t4.d\n"
35002 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35015 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
35017 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35030 # append q1 " $j3 JOIN t4 ON t1.d=t4.d\n"
35032 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35048 # append q1 " $j3 JOIN t4 ON t1.d $op3 t4.d AND t4.z>0\n"
35049 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35062 # append q1 " $j3 JOIN t4 ON t1.d $op3 t4.d AND t4.z>0\n"
35064 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35077 # append q1 " $j3 JOIN t4 ON t1.d $op3 t4.d AND t4.z>0\n"
35079 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35093 # append q1 " WHERE t1.b $op1 t2.b AND t1.d $op3 t4.d\n"
35094 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35108 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
35109 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35124 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
35125 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"