Difference between revisions of "Template:Resultbycountry"
From Testiwiki
m |
(syntax error corrected) |
||
| Line 3: | Line 3: | ||
FROM Loc, Loc AS Rawloc, Cell, Obj, Loccell, Res | FROM Loc, Loc AS Rawloc, Cell, Obj, Loccell, Res | ||
WHERE Loc.Obj_id_i = 422 | WHERE Loc.Obj_id_i = 422 | ||
| − | AND Loc.Location = | + | AND Loc.Location = "{{{country}}}" |
AND Loc.id = Rawloc.Std_id | AND Loc.id = Rawloc.Std_id | ||
| − | AND Obj.Ident = | + | AND Obj.Ident = "Op_en{{PAGEID}}" |
AND Obj.id = Cell.Obj_id_v | AND Obj.id = Cell.Obj_id_v | ||
AND Cell.id = Loccell.Cell_id | AND Cell.id = Loccell.Cell_id | ||
Revision as of 07:37, 4 June 2009
{{#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_en3076" 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.
