Mercurial > dive4elements > river
comparison backend/src/main/java/org/dive4elements/river/model/CrossSection.java @ 6621:7e697c6eb379
CrossSection: Improve SQl compat of statement.
| author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
|---|---|
| date | Mon, 22 Jul 2013 11:03:41 +0200 |
| parents | de62db0f2035 |
| children | 718b0822374d |
comparison
equal
deleted
inserted
replaced
| 6620:0bc7d3546470 | 6621:7e697c6eb379 |
|---|---|
| 63 "SELECT cross_section_id, MIN(km) AS minkm, MAX(km) AS maxkm " + | 63 "SELECT cross_section_id, MIN(km) AS minkm, MAX(km) AS maxkm " + |
| 64 "FROM cross_section_lines " + | 64 "FROM cross_section_lines " + |
| 65 "WHERE cross_section_id IN " + | 65 "WHERE cross_section_id IN " + |
| 66 " (SELECT id FROM cross_sections WHERE river_id = :river_id) " + | 66 " (SELECT id FROM cross_sections WHERE river_id = :river_id) " + |
| 67 " GROUP BY cross_section_id" + | 67 " GROUP BY cross_section_id" + |
| 68 ") AS cs_ranges " + | 68 ") cs_ranges " + |
| 69 "JOIN cross_sections as CS on cs_ranges.cross_section_id = cs.id " + | 69 "JOIN cross_sections CS on cs_ranges.cross_section_id = cs.id " + |
| 70 "LEFT OUTER JOIN time_intervals on cs.time_interval_id = time_intervals.id " + | 70 "LEFT OUTER JOIN time_intervals on cs.time_interval_id = time_intervals.id " + |
| 71 "WHERE :km BETWEEN minkm AND maxkm " + | 71 "WHERE :km BETWEEN minkm AND maxkm " + |
| 72 "ORDER BY stop_time desc, start_time asc, :km - minkm"; | 72 "ORDER BY stop_time desc, start_time asc, :km - minkm"; |
| 73 // Order by time interval missing. | 73 // Order by time interval missing. |
| 74 | 74 |