Template:Resultbycountry
From Testiwiki
{{#sql-query: SELECT Loc.*, Rawloc.*, Cell.*, Obj.*, Loccell.*, Res.* FROM Loc, Loc AS Rawloc, Cell, Obj, Loccell, Res WHERE Loc.Obj_id_i = 422 AND Loc.Location = '{{{country}}}' AND Loc.id = Rawloc.Std_id AND Obj.Ident = 'Op_en{{{PAGEID}}}' AND Obj.id = Cell.Obj_id_v AND Cell.id = Loccell.Cell_id AND Loccell.Loc_id = Rawloc.id AND Cell.id = Res.Cell_id |·{{{country}}} }}
This template is for downloading results from Opasnet base by country.