Difference between revisions of "Template:Resultbycountry"
From Testiwiki
(first draft based on own thinking) |
m |
||
| Line 10: | Line 10: | ||
AND Loccell.Loc_id = Rawloc.id | AND Loccell.Loc_id = Rawloc.id | ||
AND Cell.id = Res.Cell_id | AND Cell.id = Res.Cell_id | ||
| − | |·{{{country}}} }} | + | |·{{{country}}} }}<noinclude> |
| − | <noinclude> | ||
This template is for downloading results from [[Opasnet base]] by country. | This template is for downloading results from [[Opasnet base]] by country. | ||
</noinclude> | </noinclude> | ||
Revision as of 20:38, 28 May 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_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.
