| vFinalRanking |
qRank_All (Query)
qRank_Current (Query) |
|
Details |
160 |
Data |
SELECT
1 AS "R",
CASEWHEN("X" > "Y", "A", "B") AS "CC",
"TID",
"X",
"Y",
CASEWHEN("X" > "Y", "X" - "Y", "Y" - "X") AS "D"
FROM
PUBLIC."Matches"
WHERE
"G" = 'Z'
UNION
SELECT
2 AS "R",
CASEWHEN("X" < "Y", "A", "B") AS "CC",
"TID",
"X",
"Y",
CASEWHEN("X" < "Y", "X" - "Y", "Y" - "X") AS "D"
FROM
PUBLIC."Matches"
WHERE
"G" = 'Z'
UNION
SELECT
3 AS "R",
CASEWHEN("X" > "Y", "A", "B") AS "CC",
"TID",
"X",
"Y",
CASEWHEN("X" > "Y", "X" - "Y", "Y" - "X") AS "D"
FROM
PUBLIC."Matches"
WHERE
"G" = 'Y'
UNION
SELECT
4 AS "R",
CASEWHEN("X" < "Y", "A", "B") AS "CC",
"TID",
"X",
"Y",
CASEWHEN("X" < "Y", "X" - "Y", "Y" - "X") AS "D"
FROM
PUBLIC."Matches"
WHERE
"G" = 'Y'
UNION ALL
SELECT
5 AS "R",
"A" AS "CC",
"TID",
"X",
"Y",
"X" - "Y" AS "D"
FROM
PUBLIC."Matches"
WHERE
"G" = 'Q'
AND "X" < "Y"
UNION ALL
SELECT
5 AS "R",
"B" AS "CC",
"TID",
"X",
"Y",
"X" - "Y" AS "D"
FROM
PUBLIC."Matches"
WHERE
"G" = 'Q'
AND "X" > "Y"
UNION ALL
SELECT
6 AS "R",
"A" AS "CC",
"TID",
"X",
"Y",
"X" - "Y" AS "D"
FROM
PUBLIC."Matches"
WHERE
"G" = 'P'
AND "X" < "Y"
UNION ALL
SELECT
6 AS "R",
"B" AS "CC",
"TID",
"X",
"Y",
"X" - "Y" AS "D"
FROM
PUBLIC."Matches"
WHERE
"G" = 'P'
AND "X" > "Y"
UNION ALL
SELECT
7 AS "R",
"T" AS "CC",
"TID",
"GAIN",
"LOSS",
"GDIFF"
FROM
PUBLIC."vGroupStageRanking"
WHERE
"Rank" = 3
UNION ALL
SELECT
8 AS "R",
"T" AS "CC",
"TID",
"GAIN",
"LOSS",
"GDIFF"
FROM
PUBLIC."vGroupStageRanking"
WHERE
"Rank" = 4 |
| vGroupStageFix |
GroupStageFix (Query)
Round16 (Query) |
|
Details |
160 |
Data |
SELECT
"GST1"."TID",
"GST1"."G",
ASCII("GST1"."G") AS "GN",
"GST1"."T",
"GST1"."GDIFF",
"GST1"."CNT",
"GST1"."PTS",
"GST1"."MAX",
"GST1"."R",
"GST1"."Rank",
"GST2"."T" IS NULL
AND "CNT" > 1 AS "FIX"
FROM
PUBLIC."vGroupStageRanking" AS "GST1"
LEFT JOIN PUBLIC."vGroupStageRanking" AS "GST2" ON "GST2"."TID" = "GST1"."TID"
AND "GST2"."G" = "GST1"."G"
AND "GST1"."R" > "GST2"."R"
AND "GST1"."PTS" <= "GST2"."MAX"
AND "GST2"."CNT" < 3
GROUP BY
"GST1"."TID",
"GST2"."TID",
"GST1"."G",
"GST1"."T",
"GST1"."PTS",
"GST1"."GDIFF",
"GST1"."CNT",
"GST1"."MAX",
"GST1"."R",
"GST1"."Rank",
"GST2"."T" IS NULL
AND "CNT" > 1 |
| vGroupStageRanking |
vFinalRanking (Table)
vGroupStageFix (Table)
GroupStageTables (Query)
qReportGroupStage (Query) |
|
Details |
160 |
Data |
SELECT
"GST1"."TID",
"GST1"."G",
"GST1"."T",
"GST1"."GDIFF",
"GST1"."CNT",
"GST1"."PTS",
"GST1"."GAIN",
"GST1"."LOSS",
"GST1"."MAX",
"GST1"."R",
COUNT("GST1"."TID") AS "Rank"
FROM
PUBLIC."vGroupStageTables" AS "GST1"
JOIN PUBLIC."vGroupStageTables" AS "GST2" ON "GST1"."R" <= "GST2"."R"
AND "GST1"."TID" = "GST2"."TID"
AND "GST1"."G" = "GST2"."G"
GROUP BY
"GST1"."TID",
"GST1"."G",
"GST1"."T",
"GST1"."PTS",
"GST1"."GAIN",
"GST1"."LOSS",
"GST1"."GDIFF",
"GST1"."CNT",
"GST1"."MAX",
"GST1"."R" |
| vGroupStageTables |
vGroupStageRanking (Table) |
|
Details |
160 |
Data |
SELECT
TID,
G,
T,
SUM("PTS") AS "PTS",
SUM(GAIN) AS GAIN,
SUM(LOSS) AS LOSS,
SUM("GDIFF") AS GDIFF,
COUNT(*) AS CNT,
3 *(
3 - COUNT(*))+ SUM("PTS") AS "MAX",
SUM(PTS)* 10000 + SUM(GDIFF)* 1000 + SUM(GAIN)* 10 + SUM(LOSS) AS R
FROM
PUBLIC."vPointsGoals"
GROUP BY
TID,
G,
T |
| vPointsGoals |
vGroupStageTables (Table)
qRank_All (Query) |
|
Details |
480 |
Data |
SELECT
M.TID,
M.G,
M.A AS T,
POWER(
2,
SIGN(M.X - M.Y) +1) -1 AS PTS,
M.X AS GAIN,
M.Y AS LOSS,
M.X - M.Y AS GDIFF
FROM
PUBLIC."Matches" AS M
WHERE
M.G <= 'H'
UNION ALL
SELECT
M.TID,
M.G,
M.B AS T,
POWER(
2,
SIGN(M.Y - M.X) +1) -1 AS PTS,
M.Y AS GAIN,
M.X AS LOSS,
M.Y - M.X AS GDIFF
FROM
PUBLIC."Matches" AS M
WHERE
M.G <= 'H' |
