SELECT 
	"Groupings"."TID" AS "TID", 
	"Defaults"."G", 
	"Defaults"."A", 
	"Defaults"."B", 
	"Defaults"."ID", 
	"Countries"."N" AS "AName", 
	"Countries_1"."N" AS "BName", 
	"Defaults"."ID" 
FROM 
	"Defaults", 
	"Groupings", 
	"Groupings" AS "Groupings_1", 
	"Countries", 
	"Countries" AS "Countries_1" 
WHERE 
	"Defaults"."G" = "Groupings"."G" 
	AND "Defaults"."A" = "Groupings"."N" 
	AND "Groupings_1"."N" = "Defaults"."B" 
	AND "Groupings_1"."G" = "Defaults"."G" 
	AND "Groupings"."TID" = "Groupings_1"."TID" 
	AND "Groupings"."CC" = "Countries"."CODE" 
	AND "Groupings_1"."CC" = "Countries_1"."CODE" 
ORDER BY 
	"Defaults"."ID" ASC

SELECT 
	"vMatchofHonour"."TID", 
	"vMatchofHonour"."Q" AS "CCA", 
	"vMatchofHonour_1"."Q" AS "CCB", 
	"vCurrentDefaults"."ID", 
	"vCurrentDefaults"."G", 
	"vCurrentDefaults"."A" AS "GA", 
	"vCurrentDefaults"."B" AS "GB" 
FROM 
	"vMatchofHonour" 
	RIGHT JOIN "vCurrentDefaults" ON "vMatchofHonour"."MID" = "vCurrentDefaults"."A" 
	AND "vMatchofHonour"."TID" = "vCurrentDefaults"."TID" 
	LEFT JOIN "vMatchofHonour" AS "vMatchofHonour_1" ON "vMatchofHonour_1"."MID" = "vCurrentDefaults"."B" 
	AND "vMatchofHonour_1"."TID" = "vCurrentDefaults"."TID"

SELECT 
	"Tournaments"."ID", 
	"Tournaments"."Year" || ' -- ' || "Tournaments"."Host" AS "T", 
	"Countries"."N", 
	"vFinalRanking"."R", 
	SUM("vPointsGoals"."PTS") AS "PTS", 
	SUM("vPointsGoals"."GDIFF") AS "GDIFF", 
	SUM("vPointsGoals"."GAIN") AS "GAIN", 
	SUM(- 1 * "LOSS") AS "LOSS" 
FROM 
	"vFinalRanking", 
	"Countries", 
	"vPointsGoals", 
	"Tournaments" 
WHERE 
	"vFinalRanking"."CC" = "Countries"."CODE" 
	AND "vPointsGoals"."T" = "vFinalRanking"."CC" 
	AND "vPointsGoals"."TID" = "vFinalRanking"."TID" 
	AND "vFinalRanking"."TID" = "Tournaments"."ID" 
GROUP BY 
	"Tournaments"."ID", 
	"Countries"."N", 
	"vFinalRanking"."R", 
	"Tournaments"."Year", 
	"Tournaments"."Host"

SELECT 
	"Tournaments"."Host" || ' ' || "Tournaments"."Year" || ' ' || "Tournaments"."Description" AS "Tournament", 
	"vGroupStageRanking"."G" AS "Group", 
	"vGroupStageRanking"."Rank", 
	"Countries"."N" AS "Country", 
	"vGroupStageRanking"."PTS" AS "Points", 
	"vGroupStageRanking"."GDIFF" AS "Goals Diff" 
FROM 
	{ OJ "vGroupStageRanking" 
	RIGHT OUTER JOIN "Tournaments" ON "vGroupStageRanking"."TID" = "Tournaments"."ID" }, 
	"Countries", 
	"Filter" 
WHERE 
	"Countries"."CODE" = "vGroupStageRanking"."T" 
	AND "Tournaments"."ID" = "Filter"."INT1" 
	AND "Filter"."ID" = 0 
ORDER BY 
	"Tournament" ASC, 
	"Group" ASC, 
	"vGroupStageRanking"."Rank" ASC

SELECT 
	"G1"."A", 
	"G1"."B", 
	POWER(2, "F"."ID") - 1 AS "R" 
FROM 
	"Filter" AS "F", 
	"vCurrentDefaults" AS "G1" 
WHERE 
	"F"."ID" BETWEEN 0 
	AND 2 
	AND "G1"."TID" = 4 
	AND "G1"."G" = 'G'

SELECT 
	"F1"."ID" - 1 AS "X1", 
	"F2"."ID" - 1 AS "X2", 
	"F3"."ID" - 1 AS "X3", 
	"F4"."ID" - 1 AS "X4", 
	"F5"."ID" - 1 AS "X5", 
	"F6"."ID" - 1 AS "X6" 
FROM 
	"Filter" AS "F1", 
	"Filter" AS "F2", 
	"Filter" AS "F3", 
	"Filter" AS "F4", 
	"Filter" AS "F5", 
	"Filter" AS "F6" 
WHERE 
	"F1"."ID" BETWEEN 0 
	AND 2 
	AND "F1"."ID" >= "F2"."ID" 
	AND "F2"."ID" BETWEEN 0 
	AND 2 
	AND "F2"."ID" >= "F3"."ID" 
	AND "F3"."ID" BETWEEN 0 
	AND 2 
	AND "F3"."ID" >= "F4"."ID" 
	AND "F4"."ID" BETWEEN 0 
	AND 2 
	AND "F4"."ID" >= "F5"."ID" 
	AND "F5"."ID" BETWEEN 0 
	AND 2 
	AND "F5"."ID" >= "F6"."ID" 
	AND "F6"."ID" BETWEEN 0 
	AND 2