|
|
| Line 3: |
Line 3: |
| Currently closed for maintenence | | Currently closed for maintenence |
| <noinclude> | | <noinclude> |
| {{#sql-query:
| |
| SELECT Var.Ident, Var.Name, Var.Unit, Run.Ident, Objinfo.Moment, Objinfo.Who, Run.Name as Method
| |
| FROM Obj as Var, Obj as Run, Cell, Objinfo
| |
| WHERE Var.Ident = "Op_en{{PAGEID}}"
| |
| AND Var.id = Cell.Obj_id_v
| |
| AND Run.id = Cell.Obj_id_r
| |
| AND Run.id = Objinfo.Obj_id
| |
| GROUP BY Var.id, Run.id
| |
| ORDER BY Run.id DESC
| |
| |List of uploads}} |
| |
| [http://base.opasnet.org/index.php?page_id={{PAGEID}}&wiki_id=1&sample={{{1|1}}} The newest upload] |
| |
| {{#sql-query:
| |
| SELECT Temp.*, GROUP_CONCAT(Location SEPARATOR ', ') AS Locations
| |
| FROM Loccell, (SELECT Rawloc.id, Loc.Obj_id_i, Loc.Location, Loc.Roww, Loc.Description FROM Loc AS Rawloc, Loc WHERE Rawloc.Std_id = Loc.id) AS Loc,
| |
| (SELECT Var.Ident, Var.Name, Cell.id, Run.id as Upload, N, Objinfo.Moment, Mean, Var.Unit
| |
| FROM Obj as Var, Obj as Run, Cell, Objinfo
| |
| WHERE Var.Ident = "Op_en{{PAGEID}}"
| |
| AND Var.id = Cell.Obj_id_v
| |
| AND Run.id = Cell.Obj_id_r
| |
| AND Run.id = Objinfo.Obj_id
| |
| {{#if: {{{upload|}}}|AND Run.id = {{{upload}}}|}}
| |
| GROUP BY Cell.id ORDER BY Run.id DESC, Var.Ident) AS Temp
| |
| WHERE Temp.id = Loccell.Cell_id
| |
| AND Loc.id = Loccell.Loc_id
| |
| GROUP BY Temp.id
| |
| ORDER BY Upload DESC
| |
| |Cell means and samplesizes (N)}} |
| |
| {{#sql-query:
| |
| SELECT Temp.*, GROUP_CONCAT(Location SEPARATOR ', ') AS Locations
| |
| FROM Loccell, (SELECT Rawloc.id, Loc.Obj_id_i, Loc.Location, Loc.Roww, Loc.Description FROM Loc AS Rawloc, Loc WHERE Rawloc.Std_id = Loc.id) AS Loc,
| |
| (SELECT Var.Ident, Cell.id, Cell.Obj_id_r as Upload, Obs, Result, Var.Unit, Restext
| |
| FROM Obj as Var, Cell, Res
| |
| LEFT JOIN Resinfo ON Res.id = Resinfo.id
| |
| WHERE Var.Ident = "Op_en{{PAGEID}}"
| |
| AND Var.id = Cell.Obj_id_v
| |
| AND Cell.id = Res.Cell_id
| |
| {{#if: {{{upload|}}}|AND Cell.Obj_id_r = {{{upload}}}|}}
| |
| ORDER BY Cell.Obj_id_r, Var.Ident, Cell.id) AS Temp
| |
| WHERE Temp.id = Loccell.Cell_id AND Loc.id = Loccell.Loc_id
| |
| GROUP BY Temp.id, Obs ORDER BY Upload DESC
| |
| |Full sample}}
| |
|
| |
| {{#sql-query:
| |
| SELECT Var.Ident, Var.Name, Cell.id, Run.id, N, Objinfo.Moment, Mean, Var.Unit
| |
| FROM Obj AS Var, Obj AS Run, Cell, Objinfo
| |
| WHERE Var.Ident = "Op_en{{PAGEID}}"
| |
| AND Var.id = Cell.Obj_id_v
| |
| AND Run.id = Cell.Obj_id_r
| |
| AND Run.id = Objinfo.Obj_id
| |
| {{#if: {{{upload}}}|AND Run.id = {{{upload}}}|}}
| |
| ORDER BY Run.id DESC , Var.Ident
| |
| |Cell means without explanation}}
| |
|
| |
|
| |
|
| |
|
| '''USAGE:'''<br> | | '''USAGE:'''<br> |