Changeset 334 for trunk/info/info/alkis/alkisbestnw.php
- Timestamp:
- 09/15/14 17:52:35 (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/info/info/alkis/alkisbestnw.php
r333 r334 198 198 // sh=herrschend sd=dienend 199 199 $sql ="SELECT sd.gml_id, sd.buchungsart, sd.laufendenummer AS lfd, sd.beschreibungdesumfangsderbuchung AS udb, sd.nummerimaufteilungsplan AS nrap, sd.beschreibungdessondereigentums AS sond, b.bezeichner AS bart "; 200 $sql.="FROM ax_buchungsstelle sh JOIN ax_buchungsstelle sd ON (s d.gml_id=ANY(sh.an) OR sd.gml_id=ANY(sh.zu)) ";200 $sql.="FROM ax_buchungsstelle sh JOIN ax_buchungsstelle sd ON (substring(sd.gml_id,1,16)=ANY(sh.an) OR substring(sd.gml_id,1,16)=ANY(sh.zu)) "; 201 201 $sql.="LEFT JOIN ax_buchungsstelle_buchungsart b ON sd.buchungsart=b.wert "; 202 202 $sql.="WHERE sh.gml_id= $1 AND sh.endet IS NULL AND sd.endet IS NULL ORDER BY sd.laufendenummer;";
Note: See TracChangeset
for help on using the changeset viewer.