Lines Matching refs:q1
34846 # set q1 ""
34847 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
34848 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34849 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34850 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
34851 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34854 # echo "\\qecho X " $q1
34856 # puts $q1
34861 # set q1 ""
34862 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
34863 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b IS NOT DISTINCT FROM t2.b AND t2.x>0\n"
34864 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34865 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
34866 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34869 # echo "\\qecho X " $q1
34871 # puts $q1
34876 # set q1 ""
34877 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
34878 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b\n"
34879 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34880 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
34881 # append q1 " WHERE t2.x>0\n"
34882 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34885 # echo "\\qecho X " $q1
34887 # puts $q1
34891 # set q1 ""
34892 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
34893 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b\n"
34894 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34895 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
34896 # append q1 " WHERE (t2.x>0 OR t2.x IS NULL)\n"
34897 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34900 # echo "\\qecho X " $q1
34902 # puts $q1
34906 # set q1 ""
34907 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
34908 # append q1 " FROM t1 $j1 JOIN t2 ON true\n"
34909 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34910 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
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);"
34915 # echo "\\qecho X " $q1
34917 # puts $q1
34921 # set q1 ""
34922 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
34923 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34924 # append q1 " $j2 JOIN t3 ON t1.c=t3.c\n"
34925 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
34926 # append q1 " WHERE t3.y>0\n"
34927 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34930 # echo "\\qecho X " $q1
34932 # puts $q1
34936 # set q1 ""
34937 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
34938 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34939 # append q1 " $j2 JOIN t3 ON t1.c=t3.c\n"
34940 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
34941 # append q1 " WHERE t3.y>0 OR t3.y IS NULL\n"
34942 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34945 # echo "\\qecho X " $q1
34947 # puts $q1
34951 # set q1 ""
34952 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
34953 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34954 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34955 # append q1 " $j3 JOIN t4 ON t1.d=t4.d\n"
34956 # append q1 " WHERE t4.z>0\n"
34957 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34960 # echo "\\qecho X " $q1
34962 # puts $q1
34966 # set q1 ""
34967 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
34968 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34969 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34970 # append q1 " $j3 JOIN t4 ON t1.d=t4.d\n"
34971 # append q1 " WHERE t4.z IS NULL OR t4.z>0\n"
34972 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34975 # echo "\\qecho X " $q1
34977 # puts $q1
34981 # set q1 ""
34982 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
34983 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b\n"
34984 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
34985 # append q1 " $j3 JOIN t4 ON t1.d=t4.d\n"
34986 # append q1 " WHERE t2.x>0 AND t4.z>0\n"
34987 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
34990 # echo "\\qecho X " $q1
34992 # puts $q1
34996 # set q1 ""
34997 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
34998 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
34999 # append q1 " $j2 JOIN t3 ON t1.c=t3.c\n"
35000 # append q1 " $j3 JOIN t4 ON t1.d=t4.d\n"
35001 # append q1 " WHERE t4.z>0 AND t3.y>0\n"
35002 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35005 # echo "\\qecho X " $q1
35007 # puts $q1
35011 # set q1 ""
35012 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
35013 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b\n"
35014 # append q1 " $j2 JOIN t3 ON t1.c=t3.c\n"
35015 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
35016 # append q1 " WHERE t2.x>0 AND t3.y>0\n"
35017 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35020 # echo "\\qecho X " $q1
35022 # puts $q1
35026 # set q1 ""
35027 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
35028 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b\n"
35029 # append q1 " $j2 JOIN t3 ON t1.c=t3.c\n"
35030 # append q1 " $j3 JOIN t4 ON t1.d=t4.d\n"
35031 # append q1 " WHERE t2.x>0 AND t3.y>0 AND t4.z>0\n"
35032 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35035 # echo "\\qecho X " $q1
35037 # puts $q1
35044 # set q1 ""
35045 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
35046 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b $op1 t2.b AND t2.x>0\n"
35047 # append q1 " $j2 JOIN t3 ON t1.c $op2 t3.c AND t3.y>0\n"
35048 # append q1 " $j3 JOIN t4 ON t1.d $op3 t4.d AND t4.z>0\n"
35049 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35052 # echo "\\qecho X " $q1
35054 # puts $q1
35058 # set q1 ""
35059 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
35060 # append q1 " FROM t1 $j1 JOIN t2 ON t2.x>0\n"
35061 # append q1 " $j2 JOIN t3 ON t1.c $op2 t3.c AND t3.y>0\n"
35062 # append q1 " $j3 JOIN t4 ON t1.d $op3 t4.d AND t4.z>0\n"
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);"
35067 # echo "\\qecho X " $q1
35069 # puts $q1
35073 # set q1 ""
35074 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
35075 # append q1 " FROM t1 $j1 JOIN t2 ON t2.x>0\n"
35076 # append q1 " $j2 JOIN t3 ON t3.y>0\n"
35077 # append q1 " $j3 JOIN t4 ON t1.d $op3 t4.d AND t4.z>0\n"
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);"
35082 # echo "\\qecho X " $q1
35084 # puts $q1
35088 # set q1 ""
35089 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
35090 # append q1 " FROM t1 $j1 JOIN t2 ON t2.x>0\n"
35091 # append q1 " $j2 JOIN t3 ON t1.c $op2 t3.c AND t3.y>0\n"
35092 # append q1 " $j3 JOIN t4 ON t4.z>0\n"
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);"
35097 # echo "\\qecho X " $q1
35099 # puts $q1
35104 # set q1 ""
35105 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
35106 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b IN (t2.b,-2,-3) AND t2.x>0\n"
35107 # append q1 " $j2 JOIN t3 ON t1.c=t3.c AND t3.y>0\n"
35108 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
35109 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35112 # echo "\\qecho X " $q1
35114 # puts $q1
35120 # set q1 ""
35121 # append q1 "SELECT t1.*, t2.*, t3.*, t4.*\n"
35122 # append q1 " FROM t1 $j1 JOIN t2 ON t1.b=t2.b AND t2.x>0\n"
35123 # append q1 " $j2 JOIN t3 ON t1.c IN (-4,t3.c,-5) AND t3.y>0\n"
35124 # append q1 " $j3 JOIN t4 ON t1.d=t4.d AND t4.z>0\n"
35125 # append q1 " ORDER BY coalesce(t1.a,t2.b,t3.c,t4.d,0);"
35128 # echo "\\qecho X " $q1
35130 # puts $q1