Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/SQOverview.java @ 3389:816ceb0418b9
Q is not taken from MESSUNG.Q but from MESSUNG.Q_BPEGEL
flys-artifacts/trunk@5017 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Mon, 16 Jul 2012 09:12:56 +0000 |
parents | 36f3b53d5cfc |
children | 35a6c9a49a76 |
comparison
equal
deleted
inserted
replaced
3388:ef3cb5421bf7 | 3389:816ceb0418b9 |
---|---|
93 " JOIN station s" + | 93 " JOIN station s" + |
94 " ON m.stationid = s.stationid " + | 94 " ON m.stationid = s.stationid " + |
95 " JOIN gewaesser g " + | 95 " JOIN gewaesser g " + |
96 " ON s.gewaesserid = g.gewaesserid " + | 96 " ON s.gewaesserid = g.gewaesserid " + |
97 "WHERE" + | 97 "WHERE" + |
98 " m.q IS NOT NULL AND" + | 98 " m.q_bpegel IS NOT NULL AND" + |
99 " g.name = :name " + | 99 " g.name = :name " + |
100 "ORDER by" + | 100 "ORDER by" + |
101 " s.km, m.datum"; | 101 " s.km, m.datum"; |
102 | 102 |
103 protected String riverName; | 103 protected String riverName; |