Lines Matching full:as

35                 "SELECT DATA.pid AS PID,
36                         DATA.col1 AS out1,
37                         DATA.col2 AS out2
38                    FROM data_testtable AS DATA
51                 "SELECT DATA.pid AS PID,
52                         DATA.col1 AS out1,
53                         DATA.col2 AS out2,
54                         GROUP_CONCAT_DISTINCT(M3.value,'" . Search::CONCAT_SEPARATOR . "') AS out3
55                    FROM data_testtable AS DATA
56                    LEFT OUTER JOIN multi_testtable AS M3
72                 "SELECT DATA.pid AS PID,
73                         GROUP_CONCAT_DISTINCT(M1.value,'" . Search::CONCAT_SEPARATOR . "') AS out1,
74                         GROUP_CONCAT_DISTINCT(M2.value,'" . Search::CONCAT_SEPARATOR . "') AS out2
75                    FROM data_testtable AS DATA
76                    LEFT OUTER JOIN multi_testtable AS M2
80                    LEFT OUTER JOIN multi_testtable AS M1