Lines Matching refs:b
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;
42 CREATE TABLE t2(b INT, x INT);
43 INSERT INTO t2(b,x) SELECT b, a FROM t1 WHERE a%2=0;
44 CREATE INDEX t2b ON t2(b);
51 INSERT INTO t1(a,b,c,d) VALUES
60 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
63 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
71 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
74 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
82 FROM t1 INNER JOIN t2 ON t1.b=t2.b
86 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
94 FROM t1 INNER JOIN t2 ON t1.b=t2.b
98 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
109 WHERE t1.b=t2.b AND t2.x>0
110 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
118 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
122 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
130 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
134 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
142 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
146 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
154 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
158 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
166 FROM t1 INNER JOIN t2 ON t1.b=t2.b
170 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
178 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
182 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
190 FROM t1 INNER JOIN t2 ON t1.b=t2.b
194 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
202 FROM t1 INNER JOIN t2 ON t1.b=t2.b
206 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
214 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
217 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
228 WHERE t1.b IS NOT DISTINCT FROM t2.b
229 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
240 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
241 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
261 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
264 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
272 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
275 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
283 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
286 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
306 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
309 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
329 FROM t1 INNER JOIN t2 ON t1.b=t2.b
333 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
353 FROM t1 INNER JOIN t2 ON t1.b=t2.b
357 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
380 WHERE t1.b=t2.b AND t2.x>0
381 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
401 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
405 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
425 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
429 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
449 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
453 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
461 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
465 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
485 FROM t1 INNER JOIN t2 ON t1.b=t2.b
489 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
497 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
501 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
509 FROM t1 INNER JOIN t2 ON t1.b=t2.b
513 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
533 FROM t1 INNER JOIN t2 ON t1.b=t2.b
537 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
545 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
548 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
571 WHERE t1.b IS NOT DISTINCT FROM t2.b
572 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
595 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
596 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
628 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
631 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
651 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
654 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
674 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
677 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
702 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
705 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
730 FROM t1 INNER JOIN t2 ON t1.b=t2.b
734 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
742 FROM t1 INNER JOIN t2 ON t1.b=t2.b
746 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
774 WHERE t1.b=t2.b AND t2.x>0
775 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
783 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
787 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
795 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
799 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
824 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
828 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
852 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
856 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
880 FROM t1 INNER JOIN t2 ON t1.b=t2.b
884 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
892 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
896 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
904 FROM t1 INNER JOIN t2 ON t1.b=t2.b
908 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
916 FROM t1 INNER JOIN t2 ON t1.b=t2.b
920 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
928 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
931 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
959 WHERE t1.b IS NOT DISTINCT FROM t2.b
960 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
985 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
986 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
1007 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
1010 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1035 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1038 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1063 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1066 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1103 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
1106 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1143 FROM t1 INNER JOIN t2 ON t1.b=t2.b
1147 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1167 FROM t1 INNER JOIN t2 ON t1.b=t2.b
1171 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1211 WHERE t1.b=t2.b AND t2.x>0
1212 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1232 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1236 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1256 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1260 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1297 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1301 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1325 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1329 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1365 FROM t1 INNER JOIN t2 ON t1.b=t2.b
1369 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1377 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1381 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1389 FROM t1 INNER JOIN t2 ON t1.b=t2.b
1393 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1413 FROM t1 INNER JOIN t2 ON t1.b=t2.b
1417 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1425 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
1428 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1468 WHERE t1.b IS NOT DISTINCT FROM t2.b
1469 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1506 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
1507 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
1540 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
1543 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1580 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1583 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1620 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1623 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1637 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
1640 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1654 FROM t1 INNER JOIN t2 ON t1.b=t2.b
1658 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1672 FROM t1 INNER JOIN t2 ON t1.b=t2.b
1676 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1693 WHERE t1.b=t2.b AND t2.x>0
1694 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1708 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1712 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1720 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1724 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1738 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1742 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1756 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1760 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1774 FROM t1 INNER JOIN t2 ON t1.b=t2.b
1778 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1792 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1796 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1804 FROM t1 INNER JOIN t2 ON t1.b=t2.b
1808 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1816 FROM t1 INNER JOIN t2 ON t1.b=t2.b
1820 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1828 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
1831 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1848 WHERE t1.b IS NOT DISTINCT FROM t2.b
1849 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1866 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
1867 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
1893 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
1896 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1910 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1913 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1927 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
1930 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
1982 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
1985 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2037 FROM t1 INNER JOIN t2 ON t1.b=t2.b
2041 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2093 FROM t1 INNER JOIN t2 ON t1.b=t2.b
2097 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2152 WHERE t1.b=t2.b AND t2.x>0
2153 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2205 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
2209 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2229 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
2233 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2285 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
2289 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2303 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
2307 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2359 FROM t1 INNER JOIN t2 ON t1.b=t2.b
2363 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2377 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
2381 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2389 FROM t1 INNER JOIN t2 ON t1.b=t2.b
2393 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2413 FROM t1 INNER JOIN t2 ON t1.b=t2.b
2417 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2425 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
2428 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2483 WHERE t1.b IS NOT DISTINCT FROM t2.b
2484 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2539 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
2540 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
2578 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
2581 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2633 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
2636 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2688 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
2691 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2716 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
2719 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2744 FROM t1 INNER JOIN t2 ON t1.b=t2.b
2748 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2762 FROM t1 INNER JOIN t2 ON t1.b=t2.b
2766 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2794 WHERE t1.b=t2.b AND t2.x>0
2795 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2809 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
2813 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2821 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
2825 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2850 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
2854 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2878 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
2882 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2906 FROM t1 INNER JOIN t2 ON t1.b=t2.b
2910 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2924 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
2928 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2936 FROM t1 INNER JOIN t2 ON t1.b=t2.b
2940 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2948 FROM t1 INNER JOIN t2 ON t1.b=t2.b
2952 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2960 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
2963 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
2991 WHERE t1.b IS NOT DISTINCT FROM t2.b
2992 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3010 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
3011 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
3038 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
3041 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3066 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
3069 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3094 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
3097 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3160 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
3163 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3226 FROM t1 INNER JOIN t2 ON t1.b=t2.b
3230 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3282 FROM t1 INNER JOIN t2 ON t1.b=t2.b
3286 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3352 WHERE t1.b=t2.b AND t2.x>0
3353 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3405 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
3409 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3429 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
3433 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3496 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
3500 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3524 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
3528 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3590 FROM t1 INNER JOIN t2 ON t1.b=t2.b
3594 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3608 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
3612 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3620 FROM t1 INNER JOIN t2 ON t1.b=t2.b
3624 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3644 FROM t1 INNER JOIN t2 ON t1.b=t2.b
3648 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3656 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
3659 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3725 WHERE t1.b IS NOT DISTINCT FROM t2.b
3726 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3782 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
3783 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
3822 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
3825 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3888 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
3891 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3954 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
3957 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3965 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
3968 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3976 FROM t1 INNER JOIN t2 ON t1.b=t2.b
3980 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
3988 FROM t1 INNER JOIN t2 ON t1.b=t2.b
3992 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4003 WHERE t1.b=t2.b AND t2.x>0
4004 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4012 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4016 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4024 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4028 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4036 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4040 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4048 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4052 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4060 FROM t1 INNER JOIN t2 ON t1.b=t2.b
4064 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4072 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4076 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4084 FROM t1 INNER JOIN t2 ON t1.b=t2.b
4088 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4096 FROM t1 INNER JOIN t2 ON t1.b=t2.b
4100 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4108 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
4111 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4122 WHERE t1.b IS NOT DISTINCT FROM t2.b
4123 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4134 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
4135 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
4155 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
4158 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4166 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4169 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4177 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4180 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4217 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
4220 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4257 FROM t1 INNER JOIN t2 ON t1.b=t2.b
4261 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4281 FROM t1 INNER JOIN t2 ON t1.b=t2.b
4285 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4325 WHERE t1.b=t2.b AND t2.x>0
4326 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4346 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4350 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4386 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4390 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4426 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4430 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4438 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4442 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4479 FROM t1 INNER JOIN t2 ON t1.b=t2.b
4483 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4491 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4495 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4503 FROM t1 INNER JOIN t2 ON t1.b=t2.b
4507 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4527 FROM t1 INNER JOIN t2 ON t1.b=t2.b
4531 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4539 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
4542 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4582 WHERE t1.b IS NOT DISTINCT FROM t2.b
4583 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4607 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
4608 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
4640 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
4643 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4680 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4683 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4720 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4723 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4748 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
4751 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4776 FROM t1 INNER JOIN t2 ON t1.b=t2.b
4780 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4788 FROM t1 INNER JOIN t2 ON t1.b=t2.b
4792 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4820 WHERE t1.b=t2.b AND t2.x>0
4821 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4829 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4833 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4841 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4845 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4870 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4874 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4898 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4902 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4926 FROM t1 INNER JOIN t2 ON t1.b=t2.b
4930 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4938 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
4942 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4950 FROM t1 INNER JOIN t2 ON t1.b=t2.b
4954 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4962 FROM t1 INNER JOIN t2 ON t1.b=t2.b
4966 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
4974 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
4977 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5005 WHERE t1.b IS NOT DISTINCT FROM t2.b
5006 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5031 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
5032 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
5053 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
5056 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5081 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
5084 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5109 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
5112 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5166 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
5169 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5223 FROM t1 INNER JOIN t2 ON t1.b=t2.b
5227 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5247 FROM t1 INNER JOIN t2 ON t1.b=t2.b
5251 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5308 WHERE t1.b=t2.b AND t2.x>0
5309 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5329 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
5333 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5369 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
5373 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5426 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
5430 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5454 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
5458 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5511 FROM t1 INNER JOIN t2 ON t1.b=t2.b
5515 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5523 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
5527 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5535 FROM t1 INNER JOIN t2 ON t1.b=t2.b
5539 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5559 FROM t1 INNER JOIN t2 ON t1.b=t2.b
5563 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5571 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
5574 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5631 WHERE t1.b IS NOT DISTINCT FROM t2.b
5632 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5670 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
5671 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
5704 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
5707 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5761 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
5764 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5818 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
5821 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5835 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
5838 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5852 FROM t1 INNER JOIN t2 ON t1.b=t2.b
5856 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5870 FROM t1 INNER JOIN t2 ON t1.b=t2.b
5874 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5891 WHERE t1.b=t2.b AND t2.x>0
5892 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5906 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
5910 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5918 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
5922 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5936 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
5940 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5954 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
5958 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5972 FROM t1 INNER JOIN t2 ON t1.b=t2.b
5976 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
5990 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
5994 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6002 FROM t1 INNER JOIN t2 ON t1.b=t2.b
6006 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6014 FROM t1 INNER JOIN t2 ON t1.b=t2.b
6018 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6026 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
6029 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6046 WHERE t1.b IS NOT DISTINCT FROM t2.b
6047 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6064 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
6065 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
6091 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
6094 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6108 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
6111 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6180 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
6183 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6252 FROM t1 INNER JOIN t2 ON t1.b=t2.b
6256 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6308 FROM t1 INNER JOIN t2 ON t1.b=t2.b
6312 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6384 WHERE t1.b=t2.b AND t2.x>0
6385 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6437 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
6441 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6477 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
6481 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6549 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
6553 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6567 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
6571 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6640 FROM t1 INNER JOIN t2 ON t1.b=t2.b
6644 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6658 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
6662 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6670 FROM t1 INNER JOIN t2 ON t1.b=t2.b
6674 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6694 FROM t1 INNER JOIN t2 ON t1.b=t2.b
6698 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6706 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
6709 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6781 WHERE t1.b IS NOT DISTINCT FROM t2.b
6782 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6838 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
6839 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
6877 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
6880 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6949 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
6952 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
6977 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
6980 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7005 FROM t1 INNER JOIN t2 ON t1.b=t2.b
7009 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7023 FROM t1 INNER JOIN t2 ON t1.b=t2.b
7027 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7055 WHERE t1.b=t2.b AND t2.x>0
7056 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7070 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
7074 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7082 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
7086 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7111 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
7115 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7139 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
7143 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7167 FROM t1 INNER JOIN t2 ON t1.b=t2.b
7171 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7185 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
7189 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7197 FROM t1 INNER JOIN t2 ON t1.b=t2.b
7201 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7209 FROM t1 INNER JOIN t2 ON t1.b=t2.b
7213 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7221 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
7224 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7252 WHERE t1.b IS NOT DISTINCT FROM t2.b
7253 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7271 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
7272 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
7298 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
7301 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7326 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
7329 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7409 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
7412 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7492 FROM t1 INNER JOIN t2 ON t1.b=t2.b
7496 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7548 FROM t1 INNER JOIN t2 ON t1.b=t2.b
7552 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7635 WHERE t1.b=t2.b AND t2.x>0
7636 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7688 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
7692 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7728 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
7732 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7811 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
7815 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7839 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
7843 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7922 FROM t1 INNER JOIN t2 ON t1.b=t2.b
7926 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7940 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>0
7944 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7952 FROM t1 INNER JOIN t2 ON t1.b=t2.b
7956 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7976 FROM t1 INNER JOIN t2 ON t1.b=t2.b
7980 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
7988 FROM t1 INNER JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
7991 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8074 WHERE t1.b IS NOT DISTINCT FROM t2.b
8075 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8132 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
8133 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
8171 FROM t1 INNER JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
8174 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8254 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
8257 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8268 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
8271 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8282 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
8286 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8294 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
8298 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8312 WHERE t1.b=t2.b AND t2.x>0
8313 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8321 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
8325 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8336 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
8340 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8351 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
8355 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8366 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
8370 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8381 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
8385 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8393 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
8397 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8408 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
8412 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8420 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
8424 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8432 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
8435 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8449 WHERE t1.b IS NOT DISTINCT FROM t2.b
8450 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8461 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
8462 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
8482 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
8485 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8496 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
8499 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8510 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
8513 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8549 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
8552 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8588 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
8592 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8612 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
8616 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8655 WHERE t1.b=t2.b AND t2.x>0
8656 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8676 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
8680 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8716 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
8720 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8756 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
8760 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8771 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
8775 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8811 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
8815 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8823 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
8827 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8838 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
8842 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8862 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
8866 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8874 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
8877 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8916 WHERE t1.b IS NOT DISTINCT FROM t2.b
8917 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
8940 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
8941 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
8973 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
8976 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9012 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
9015 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9051 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
9054 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9079 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
9082 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9107 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
9111 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9119 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
9123 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9151 WHERE t1.b=t2.b AND t2.x>0
9152 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9160 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
9164 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9175 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
9179 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9204 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
9208 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9232 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
9236 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9260 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
9264 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9272 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
9276 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9287 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
9291 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9299 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
9303 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9311 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
9314 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9342 WHERE t1.b IS NOT DISTINCT FROM t2.b
9343 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9368 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
9369 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
9390 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
9393 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9418 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
9421 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9446 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
9449 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9499 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
9502 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9552 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
9556 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9576 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
9580 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9633 WHERE t1.b=t2.b AND t2.x>0
9634 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9654 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
9658 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9694 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
9698 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9748 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
9752 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9776 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
9780 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9829 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
9833 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9841 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
9845 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9856 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
9860 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9880 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
9884 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9892 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
9895 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9948 WHERE t1.b IS NOT DISTINCT FROM t2.b
9949 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
9986 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
9987 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
10020 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
10023 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10073 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
10076 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10126 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
10129 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10153 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
10156 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10180 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
10184 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10198 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
10202 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10229 WHERE t1.b=t2.b AND t2.x>0
10230 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10244 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
10248 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10259 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
10263 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10287 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
10291 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10315 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
10319 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10343 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
10347 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10361 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
10365 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10376 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
10380 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10388 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
10392 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10400 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
10403 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10430 WHERE t1.b IS NOT DISTINCT FROM t2.b
10431 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10448 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
10449 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
10475 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
10478 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10502 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
10505 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10529 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
10532 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10637 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
10640 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10745 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
10749 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10801 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
10805 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10912 WHERE t1.b=t2.b AND t2.x>0
10913 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
10965 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
10969 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11005 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
11009 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11113 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
11117 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11141 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
11145 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11249 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
11253 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11267 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
11271 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11282 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
11286 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11306 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
11310 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11318 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
11321 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11429 WHERE t1.b IS NOT DISTINCT FROM t2.b
11430 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11485 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
11486 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
11524 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
11527 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11632 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
11635 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11740 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
11743 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11768 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
11771 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11796 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
11800 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11814 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
11818 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11846 WHERE t1.b=t2.b AND t2.x>0
11847 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11861 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
11865 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11876 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
11880 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11905 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
11909 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11933 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
11937 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11961 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
11965 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11979 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
11983 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
11994 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
11998 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12006 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
12010 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12018 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
12021 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12049 WHERE t1.b IS NOT DISTINCT FROM t2.b
12050 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12068 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
12069 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
12096 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
12099 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12124 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
12127 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12152 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
12155 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12261 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
12264 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12370 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
12374 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12426 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
12430 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12538 WHERE t1.b=t2.b AND t2.x>0
12539 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12591 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
12595 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12631 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
12635 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12740 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
12744 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12768 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
12772 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12876 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
12880 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12894 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
12898 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12909 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
12913 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12933 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
12937 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
12945 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
12948 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13057 WHERE t1.b IS NOT DISTINCT FROM t2.b
13058 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13114 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
13115 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
13154 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
13157 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13263 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
13266 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13372 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
13375 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13386 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
13389 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13400 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
13404 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13412 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
13416 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13430 WHERE t1.b=t2.b AND t2.x>0
13431 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13439 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
13443 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13454 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
13458 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13469 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
13473 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13484 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
13488 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13499 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
13503 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13511 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
13515 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13526 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
13530 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13538 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
13542 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13550 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
13553 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13567 WHERE t1.b IS NOT DISTINCT FROM t2.b
13568 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13579 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
13580 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
13600 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
13603 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13614 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
13617 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13628 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
13631 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13668 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
13671 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13708 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
13712 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13732 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
13736 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13776 WHERE t1.b=t2.b AND t2.x>0
13777 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13797 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
13801 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13837 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
13841 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13877 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
13881 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13892 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
13896 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13933 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
13937 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13945 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
13949 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13960 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
13964 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13984 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
13988 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
13996 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
13999 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14039 WHERE t1.b IS NOT DISTINCT FROM t2.b
14040 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14064 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
14065 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
14097 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
14100 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14137 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
14140 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14177 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
14180 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14205 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
14208 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14233 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
14237 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14245 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
14249 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14277 WHERE t1.b=t2.b AND t2.x>0
14278 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14286 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
14290 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14301 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
14305 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14330 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
14334 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14358 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
14362 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14386 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
14390 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14398 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
14402 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14413 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
14417 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14425 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
14429 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14437 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
14440 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14468 WHERE t1.b IS NOT DISTINCT FROM t2.b
14469 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14494 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
14495 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
14516 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
14519 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14544 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
14547 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14572 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
14575 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14626 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
14629 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14680 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
14684 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14704 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
14708 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14762 WHERE t1.b=t2.b AND t2.x>0
14763 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14783 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
14787 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14823 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
14827 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14877 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
14881 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14905 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
14909 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14959 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
14963 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14971 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
14975 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
14986 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
14990 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15010 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
15014 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15022 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
15025 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15079 WHERE t1.b IS NOT DISTINCT FROM t2.b
15080 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15118 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
15119 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
15152 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
15155 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15206 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
15209 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15260 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
15263 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15287 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
15290 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15314 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
15318 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15332 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
15336 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15363 WHERE t1.b=t2.b AND t2.x>0
15364 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15378 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
15382 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15393 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
15397 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15421 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
15425 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15449 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
15453 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15477 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
15481 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15495 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
15499 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15510 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
15514 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15522 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
15526 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15534 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
15537 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15564 WHERE t1.b IS NOT DISTINCT FROM t2.b
15565 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15582 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
15583 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
15609 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
15612 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15636 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
15639 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15745 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
15748 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15854 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
15858 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
15910 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
15914 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16022 WHERE t1.b=t2.b AND t2.x>0
16023 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16075 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
16079 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16115 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
16119 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16223 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
16227 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16251 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
16255 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16360 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
16364 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16378 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
16382 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16393 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
16397 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16417 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
16421 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16429 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
16432 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16541 WHERE t1.b IS NOT DISTINCT FROM t2.b
16542 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16598 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
16599 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
16637 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
16640 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16746 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
16749 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16774 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
16777 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16802 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
16806 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16820 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
16824 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16852 WHERE t1.b=t2.b AND t2.x>0
16853 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16867 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
16871 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16882 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
16886 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16911 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
16915 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16939 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
16943 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16967 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
16971 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
16985 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
16989 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17000 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
17004 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17012 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
17016 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17024 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
17027 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17055 WHERE t1.b IS NOT DISTINCT FROM t2.b
17056 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17074 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
17075 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
17101 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
17104 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17129 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
17132 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17239 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
17242 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17349 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
17353 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17405 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
17409 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17518 WHERE t1.b=t2.b AND t2.x>0
17519 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17571 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
17575 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17611 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
17615 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17720 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
17724 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17748 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
17752 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17857 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
17861 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17875 FROM t1 LEFT JOIN t2 ON t1.b=t2.b AND t2.x>0
17879 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17890 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
17894 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17914 FROM t1 LEFT JOIN t2 ON t1.b=t2.b
17918 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
17926 FROM t1 LEFT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
17929 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18039 WHERE t1.b IS NOT DISTINCT FROM t2.b
18040 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18097 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
18098 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
18136 FROM t1 LEFT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
18139 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18246 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18249 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18257 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
18260 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18268 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
18272 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18280 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
18284 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18295 WHERE t1.b=t2.b AND t2.x>0
18296 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18304 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18308 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18316 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18320 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18328 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18332 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18340 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18344 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18352 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
18356 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18364 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18368 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18376 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
18380 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18388 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
18392 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18400 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
18403 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18414 WHERE t1.b IS NOT DISTINCT FROM t2.b
18415 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18426 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
18427 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
18447 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
18450 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18458 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18461 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18469 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18472 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18492 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
18495 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18515 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
18519 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18539 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
18543 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18566 WHERE t1.b=t2.b AND t2.x>0
18567 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18587 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18591 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18611 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18615 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18635 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18639 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18647 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18651 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18671 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
18675 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18683 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18687 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18695 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
18699 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18719 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
18723 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18731 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
18734 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18757 WHERE t1.b IS NOT DISTINCT FROM t2.b
18758 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18781 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
18782 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
18814 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
18817 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18837 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18840 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18860 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18863 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18888 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
18891 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18916 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
18920 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18928 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
18932 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18960 WHERE t1.b=t2.b AND t2.x>0
18961 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18969 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18973 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
18981 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
18985 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19010 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19014 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19038 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19042 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19066 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
19070 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19078 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19082 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19090 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
19094 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19102 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
19106 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19114 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
19117 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19145 WHERE t1.b IS NOT DISTINCT FROM t2.b
19146 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19171 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
19172 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
19193 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
19196 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19221 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19224 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19249 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19252 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19289 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
19292 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19329 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
19333 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19353 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
19357 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19397 WHERE t1.b=t2.b AND t2.x>0
19398 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19418 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19422 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19442 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19446 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19483 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19487 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19511 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19515 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19551 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
19555 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19563 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19567 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19575 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
19579 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19599 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
19603 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19611 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
19614 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19654 WHERE t1.b IS NOT DISTINCT FROM t2.b
19655 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19692 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
19693 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
19726 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
19729 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19766 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19769 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19806 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19809 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19823 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
19826 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19840 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
19844 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19858 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
19862 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19879 WHERE t1.b=t2.b AND t2.x>0
19880 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19894 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19898 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19906 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19910 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19924 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19928 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19942 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19946 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19960 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
19964 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19978 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
19982 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
19990 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
19994 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20002 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
20006 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20014 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
20017 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20034 WHERE t1.b IS NOT DISTINCT FROM t2.b
20035 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20052 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
20053 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
20079 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
20082 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20096 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
20099 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20113 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
20116 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20169 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
20172 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20225 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
20229 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20281 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
20285 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20340 WHERE t1.b=t2.b AND t2.x>0
20341 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20393 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
20397 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20417 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
20421 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20474 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
20478 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20492 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
20496 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20549 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
20553 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20567 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
20571 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20579 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
20583 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20603 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
20607 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20615 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
20618 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20674 WHERE t1.b IS NOT DISTINCT FROM t2.b
20675 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20730 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
20731 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
20769 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
20772 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20825 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
20828 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20881 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
20884 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20909 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
20912 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20937 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
20941 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20955 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
20959 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
20987 WHERE t1.b=t2.b AND t2.x>0
20988 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21002 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
21006 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21014 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
21018 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21043 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
21047 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21071 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
21075 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21099 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
21103 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21117 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
21121 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21129 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
21133 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21141 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
21145 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21153 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
21156 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21184 WHERE t1.b IS NOT DISTINCT FROM t2.b
21185 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21203 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
21204 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
21231 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
21234 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21259 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
21262 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21287 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
21290 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21354 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
21357 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21421 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
21425 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21477 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
21481 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21547 WHERE t1.b=t2.b AND t2.x>0
21548 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21600 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
21604 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21624 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
21628 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21692 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
21696 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21720 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
21724 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21787 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
21791 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21805 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
21809 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21817 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
21821 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21841 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
21845 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21853 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
21856 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21923 WHERE t1.b IS NOT DISTINCT FROM t2.b
21924 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
21980 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
21981 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
22020 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
22023 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22087 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22090 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22154 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22157 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22165 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
22168 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22176 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
22180 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22188 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
22192 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22203 WHERE t1.b=t2.b AND t2.x>0
22204 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22212 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22216 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22224 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22228 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22236 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22240 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22248 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22252 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22260 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
22264 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22272 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22276 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22284 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
22288 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22296 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
22300 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22308 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
22311 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22322 WHERE t1.b IS NOT DISTINCT FROM t2.b
22323 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22334 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
22335 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
22355 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
22358 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22366 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22369 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22377 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22380 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22417 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
22420 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22457 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
22461 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22481 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
22485 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22525 WHERE t1.b=t2.b AND t2.x>0
22526 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22546 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22550 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22586 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22590 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22626 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22630 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22638 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22642 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22679 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
22683 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22691 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22695 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22703 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
22707 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22727 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
22731 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22739 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
22742 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22782 WHERE t1.b IS NOT DISTINCT FROM t2.b
22783 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22807 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
22808 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
22840 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
22843 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22880 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22883 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22920 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
22923 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22948 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
22951 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22976 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
22980 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
22988 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
22992 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23020 WHERE t1.b=t2.b AND t2.x>0
23021 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23029 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
23033 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23041 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
23045 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23070 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
23074 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23098 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
23102 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23126 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
23130 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23138 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
23142 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23150 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
23154 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23162 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
23166 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23174 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
23177 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23205 WHERE t1.b IS NOT DISTINCT FROM t2.b
23206 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23231 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
23232 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
23253 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
23256 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23281 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
23284 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23309 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
23312 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23366 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
23369 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23423 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
23427 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23447 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
23451 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23508 WHERE t1.b=t2.b AND t2.x>0
23509 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23529 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
23533 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23569 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
23573 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23626 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
23630 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23654 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
23658 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23711 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
23715 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23723 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
23727 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23735 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
23739 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23759 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
23763 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23771 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
23774 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23831 WHERE t1.b IS NOT DISTINCT FROM t2.b
23832 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23870 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c IS NOT DISTINCT FROM t3.c
23871 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
23904 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
23907 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
23961 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
23964 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24018 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
24021 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24035 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
24038 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24052 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
24056 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24070 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
24074 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24091 WHERE t1.b=t2.b AND t2.x>0
24092 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24106 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
24110 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24118 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
24122 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24136 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
24140 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24154 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
24158 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24172 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
24176 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24190 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
24194 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24202 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
24206 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24214 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
24218 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24226 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
24229 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24246 WHERE t1.b IS NOT DISTINCT FROM t2.b
24247 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24264 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
24265 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
24291 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
24294 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24308 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
24311 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24381 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
24384 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24454 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
24458 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24510 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
24514 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24586 WHERE t1.b=t2.b AND t2.x>0
24587 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24639 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
24643 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24679 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
24683 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24752 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
24756 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24770 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
24774 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24844 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
24848 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24862 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
24866 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24874 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
24878 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24898 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
24902 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24910 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
24913 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
24986 WHERE t1.b IS NOT DISTINCT FROM t2.b
24987 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25043 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
25044 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
25082 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
25085 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25155 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
25158 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25183 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
25186 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25211 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
25215 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25229 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
25233 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25261 WHERE t1.b=t2.b AND t2.x>0
25262 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25276 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
25280 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25288 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
25292 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25317 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
25321 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25345 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
25349 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25373 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
25377 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25391 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
25395 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25403 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
25407 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25415 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
25419 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25427 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
25430 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25458 WHERE t1.b IS NOT DISTINCT FROM t2.b
25459 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25477 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
25478 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
25504 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
25507 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25532 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
25535 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25616 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
25619 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25700 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
25704 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25756 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
25760 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25843 WHERE t1.b=t2.b AND t2.x>0
25844 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25896 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
25900 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
25936 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
25940 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26020 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
26024 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26048 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
26052 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26132 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
26136 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26150 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b AND t2.x>0
26154 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26162 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
26166 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26186 FROM t1 RIGHT JOIN t2 ON t1.b=t2.b
26190 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26198 FROM t1 RIGHT JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0
26201 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26285 WHERE t1.b IS NOT DISTINCT FROM t2.b
26286 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26343 WHERE t1.b IS NOT DISTINCT FROM t2.b AND t1.c = t3.c
26344 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
26382 FROM t1 RIGHT JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0
26385 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26466 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
26469 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26480 FROM t1 FULL JOIN t2 ON t1.b=t2.b
26484 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26492 FROM t1 FULL JOIN t2 ON t1.b=t2.b
26496 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26510 WHERE t1.b=t2.b AND t2.x>0
26511 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26519 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
26523 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26534 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
26538 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26549 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
26553 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26564 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
26568 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26579 FROM t1 FULL JOIN t2 ON t1.b=t2.b
26583 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26591 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
26595 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26606 FROM t1 FULL JOIN t2 ON t1.b=t2.b
26610 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26618 FROM t1 FULL JOIN t2 ON t1.b=t2.b
26622 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26630 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
26633 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26647 WHERE t1.b = t2.b
26648 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26659 WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
26660 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
26680 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
26683 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26694 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
26697 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26733 FROM t1 FULL JOIN t2 ON t1.b=t2.b
26737 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26757 FROM t1 FULL JOIN t2 ON t1.b=t2.b
26761 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26800 WHERE t1.b=t2.b AND t2.x>0
26801 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26821 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
26825 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26861 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
26865 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26901 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
26905 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26916 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
26920 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26956 FROM t1 FULL JOIN t2 ON t1.b=t2.b
26960 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26968 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
26972 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
26983 FROM t1 FULL JOIN t2 ON t1.b=t2.b
26987 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27007 FROM t1 FULL JOIN t2 ON t1.b=t2.b
27011 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27019 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
27022 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27061 WHERE t1.b = t2.b
27062 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27085 WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
27086 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
27118 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
27121 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27157 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
27160 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27185 FROM t1 FULL JOIN t2 ON t1.b=t2.b
27189 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27197 FROM t1 FULL JOIN t2 ON t1.b=t2.b
27201 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27229 WHERE t1.b=t2.b AND t2.x>0
27230 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27238 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
27242 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27253 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
27257 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27282 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
27286 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27310 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
27314 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27338 FROM t1 FULL JOIN t2 ON t1.b=t2.b
27342 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27350 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
27354 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27365 FROM t1 FULL JOIN t2 ON t1.b=t2.b
27369 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27377 FROM t1 FULL JOIN t2 ON t1.b=t2.b
27381 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27389 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
27392 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27420 WHERE t1.b = t2.b
27421 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27432 WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
27433 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
27453 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
27456 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27481 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
27484 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27534 FROM t1 FULL JOIN t2 ON t1.b=t2.b
27538 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27558 FROM t1 FULL JOIN t2 ON t1.b=t2.b
27562 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27615 WHERE t1.b=t2.b AND t2.x>0
27616 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27636 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
27640 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27676 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
27680 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27730 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
27734 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27758 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
27762 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27811 FROM t1 FULL JOIN t2 ON t1.b=t2.b
27815 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27823 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
27827 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27838 FROM t1 FULL JOIN t2 ON t1.b=t2.b
27842 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27862 FROM t1 FULL JOIN t2 ON t1.b=t2.b
27866 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27874 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
27877 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27930 WHERE t1.b = t2.b
27931 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27954 WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
27955 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27978 WHERE t1.b = t2.b AND t1.d = t4.d
27979 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
27987 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
27990 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28040 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
28043 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28067 FROM t1 FULL JOIN t2 ON t1.b=t2.b
28071 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28085 FROM t1 FULL JOIN t2 ON t1.b=t2.b
28089 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28116 WHERE t1.b=t2.b AND t2.x>0
28117 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28131 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
28135 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28146 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
28150 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28174 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
28178 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28202 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
28206 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28230 FROM t1 FULL JOIN t2 ON t1.b=t2.b
28234 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28248 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
28252 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28263 FROM t1 FULL JOIN t2 ON t1.b=t2.b
28267 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28275 FROM t1 FULL JOIN t2 ON t1.b=t2.b
28279 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28287 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
28290 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28317 WHERE t1.b = t2.b
28318 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28335 WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
28336 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
28362 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
28365 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28389 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
28392 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28498 FROM t1 FULL JOIN t2 ON t1.b=t2.b
28502 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28554 FROM t1 FULL JOIN t2 ON t1.b=t2.b
28558 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28665 WHERE t1.b=t2.b AND t2.x>0
28666 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28718 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
28722 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28758 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
28762 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28867 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
28871 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
28895 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
28899 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29004 FROM t1 FULL JOIN t2 ON t1.b=t2.b
29008 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29022 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
29026 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29037 FROM t1 FULL JOIN t2 ON t1.b=t2.b
29041 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29061 FROM t1 FULL JOIN t2 ON t1.b=t2.b
29065 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29073 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
29076 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29185 WHERE t1.b = t2.b
29186 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29241 WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
29242 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
29280 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
29283 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29389 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
29392 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29417 FROM t1 FULL JOIN t2 ON t1.b=t2.b
29421 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29435 FROM t1 FULL JOIN t2 ON t1.b=t2.b
29439 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29467 WHERE t1.b=t2.b AND t2.x>0
29468 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29482 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
29486 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29497 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
29501 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29526 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
29530 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29554 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
29558 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29582 FROM t1 FULL JOIN t2 ON t1.b=t2.b
29586 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29600 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
29604 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29615 FROM t1 FULL JOIN t2 ON t1.b=t2.b
29619 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29627 FROM t1 FULL JOIN t2 ON t1.b=t2.b
29631 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29639 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
29642 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29670 WHERE t1.b = t2.b
29671 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29688 WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
29689 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
29715 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
29718 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29743 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
29746 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29853 FROM t1 FULL JOIN t2 ON t1.b=t2.b
29857 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
29909 FROM t1 FULL JOIN t2 ON t1.b=t2.b
29913 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30021 WHERE t1.b=t2.b AND t2.x>0
30022 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30074 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
30078 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30114 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
30118 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30224 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
30228 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30252 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
30256 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30361 FROM t1 FULL JOIN t2 ON t1.b=t2.b
30365 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30379 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
30383 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30394 FROM t1 FULL JOIN t2 ON t1.b=t2.b
30398 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30418 FROM t1 FULL JOIN t2 ON t1.b=t2.b
30422 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30430 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
30433 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30543 WHERE t1.b = t2.b
30544 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30599 WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
30600 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30623 WHERE t1.b = t2.b AND t1.d = t4.d
30624 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30638 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
30641 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30748 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
30751 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30762 FROM t1 FULL JOIN t2 ON t1.b=t2.b
30766 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30774 FROM t1 FULL JOIN t2 ON t1.b=t2.b
30778 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30792 WHERE t1.b=t2.b AND t2.x>0
30793 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30801 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
30805 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30816 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
30820 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30831 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
30835 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30846 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
30850 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30861 FROM t1 FULL JOIN t2 ON t1.b=t2.b
30865 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30873 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
30877 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30888 FROM t1 FULL JOIN t2 ON t1.b=t2.b
30892 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30900 FROM t1 FULL JOIN t2 ON t1.b=t2.b
30904 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30912 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
30915 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30929 WHERE t1.b = t2.b
30930 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30941 WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
30942 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
30962 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
30965 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
30976 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
30979 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31016 FROM t1 FULL JOIN t2 ON t1.b=t2.b
31020 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31040 FROM t1 FULL JOIN t2 ON t1.b=t2.b
31044 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31084 WHERE t1.b=t2.b AND t2.x>0
31085 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31105 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31109 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31145 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31149 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31185 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31189 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31200 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31204 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31241 FROM t1 FULL JOIN t2 ON t1.b=t2.b
31245 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31253 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31257 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31268 FROM t1 FULL JOIN t2 ON t1.b=t2.b
31272 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31292 FROM t1 FULL JOIN t2 ON t1.b=t2.b
31296 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31304 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
31307 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31347 WHERE t1.b = t2.b
31348 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31371 WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
31372 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
31404 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31407 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31444 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31447 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31472 FROM t1 FULL JOIN t2 ON t1.b=t2.b
31476 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31484 FROM t1 FULL JOIN t2 ON t1.b=t2.b
31488 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31516 WHERE t1.b=t2.b AND t2.x>0
31517 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31525 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31529 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31540 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31544 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31569 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31573 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31597 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31601 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31625 FROM t1 FULL JOIN t2 ON t1.b=t2.b
31629 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31637 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31641 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31652 FROM t1 FULL JOIN t2 ON t1.b=t2.b
31656 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31664 FROM t1 FULL JOIN t2 ON t1.b=t2.b
31668 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31676 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
31679 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31707 WHERE t1.b = t2.b
31708 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31719 WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
31720 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
31740 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31743 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31768 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31771 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31822 FROM t1 FULL JOIN t2 ON t1.b=t2.b
31826 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31846 FROM t1 FULL JOIN t2 ON t1.b=t2.b
31850 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31904 WHERE t1.b=t2.b AND t2.x>0
31905 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31925 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31929 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
31965 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
31969 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32019 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
32023 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32047 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
32051 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32101 FROM t1 FULL JOIN t2 ON t1.b=t2.b
32105 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32113 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
32117 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32128 FROM t1 FULL JOIN t2 ON t1.b=t2.b
32132 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32152 FROM t1 FULL JOIN t2 ON t1.b=t2.b
32156 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32164 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
32167 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32221 WHERE t1.b = t2.b
32222 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32245 WHERE t1.b = t2.b AND t1.c IS NOT DISTINCT FROM t3.c
32246 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32269 WHERE t1.b = t2.b AND t1.d = t4.d
32270 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32278 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
32281 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32332 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
32335 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32359 FROM t1 FULL JOIN t2 ON t1.b=t2.b
32363 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32377 FROM t1 FULL JOIN t2 ON t1.b=t2.b
32381 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32408 WHERE t1.b=t2.b AND t2.x>0
32409 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32423 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
32427 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32438 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
32442 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32466 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
32470 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32494 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
32498 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32522 FROM t1 FULL JOIN t2 ON t1.b=t2.b
32526 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32540 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
32544 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32555 FROM t1 FULL JOIN t2 ON t1.b=t2.b
32559 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32567 FROM t1 FULL JOIN t2 ON t1.b=t2.b
32571 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32579 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
32582 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32609 WHERE t1.b = t2.b
32610 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32627 WHERE t1.b = t2.b AND t1.c = t3.c
32628 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
32654 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
32657 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32764 FROM t1 FULL JOIN t2 ON t1.b=t2.b
32768 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32820 FROM t1 FULL JOIN t2 ON t1.b=t2.b
32824 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32932 WHERE t1.b=t2.b AND t2.x>0
32933 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
32985 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
32989 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33025 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
33029 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33134 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
33138 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33162 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
33166 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33272 FROM t1 FULL JOIN t2 ON t1.b=t2.b
33276 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33290 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
33294 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33305 FROM t1 FULL JOIN t2 ON t1.b=t2.b
33309 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33329 FROM t1 FULL JOIN t2 ON t1.b=t2.b
33333 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33341 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
33344 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33454 WHERE t1.b = t2.b
33455 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33510 WHERE t1.b = t2.b AND t1.c = t3.c
33511 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
33549 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
33552 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33577 FROM t1 FULL JOIN t2 ON t1.b=t2.b
33581 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33595 FROM t1 FULL JOIN t2 ON t1.b=t2.b
33599 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33627 WHERE t1.b=t2.b AND t2.x>0
33628 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33642 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
33646 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33657 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
33661 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33686 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
33690 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33714 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
33718 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33742 FROM t1 FULL JOIN t2 ON t1.b=t2.b
33746 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33760 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
33764 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33775 FROM t1 FULL JOIN t2 ON t1.b=t2.b
33779 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33787 FROM t1 FULL JOIN t2 ON t1.b=t2.b
33791 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33799 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
33802 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33830 WHERE t1.b = t2.b
33831 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33848 WHERE t1.b = t2.b AND t1.c = t3.c
33849 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
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);
33875 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
33878 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
33986 FROM t1 FULL JOIN t2 ON t1.b=t2.b
33990 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34042 FROM t1 FULL JOIN t2 ON t1.b=t2.b
34046 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34155 WHERE t1.b=t2.b AND t2.x>0
34156 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34208 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
34212 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34248 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
34252 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34358 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
34362 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34386 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
34390 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34496 FROM t1 FULL JOIN t2 ON t1.b=t2.b
34500 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34514 FROM t1 FULL JOIN t2 ON t1.b=t2.b AND t2.x>0
34518 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34529 FROM t1 FULL JOIN t2 ON t1.b=t2.b
34533 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34553 FROM t1 FULL JOIN t2 ON t1.b=t2.b
34557 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34565 FROM t1 FULL JOIN t2 ON t1.b = t2.b AND t2.x>0
34568 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34679 WHERE t1.b = t2.b
34680 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34735 WHERE t1.b = t2.b AND t1.c = t3.c
34736 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34759 WHERE t1.b = t2.b AND t1.d = t4.d
34760 ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);
34777 FROM t1 INNER JOIN t2 ON t1.b=t2.b AND t2.x>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;
34819 # CREATE TABLE t2(b INT, x INT);
34820 # INSERT INTO t2(b,x) SELECT b, a FROM t1 WHERE a%2=0;
34821 # CREATE INDEX t2b ON t2(b);
34828 # INSERT INTO t1(a,b,c,d) VALUES
34848 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34851 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34863 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0\n"
34866 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34878 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b\n"
34882 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34893 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b\n"
34897 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34911 # append q1 " WHERE t1.b=t2.b AND t2.x>0\n"
34912 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34923 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34927 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34938 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34942 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34953 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34957 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34968 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34972 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34983 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b\n"
34987 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34998 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
35002 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35013 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b\n"
35017 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35028 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b\n"
35032 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35046 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b $op1 t2.b AND t2.x>0\n"
35049 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35063 # append q1 " WHERE t1.b $op1 t2.b\n"
35064 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35078 # append q1 " WHERE t1.b $op1 t2.b AND t1.c $op2 t3.c\n"
35079 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
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);"
35106 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0\n"
35109 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35122 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
35125 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"