Mercurial > hg > tema

view misc/biotopes/biotope-top.sql @ 2:6c41a0b43e58

find changesets by author, revision, files, or words in the commit message
Tema 0.3 (imported from CVS).
author Mikhail Kryshen <mikhail@kryshen.net>
date Tue, 19 Feb 2008 20:32:17 +0300
parents
children
line source
1 SELECT t1.*,
2
3 (SELECT t2.rusname FROM biotopelist AS t2
4 WHERE Left(t2.rangcode, 1) = Left(t1.rangcode, 1) AND
5 Right(t2.rangcode, 8) = '00000000') AS class0,
6
7 (SELECT t2.rusname FROM biotopelist AS t2
8 WHERE Left(t2.rangcode, 3) = Left(t1.rangcode, 3) AND
9 Right(t2.rangcode, 6) = '000000') AS class1,
10
11 (SELECT t2.rusname FROM biotopelist AS t2
12 WHERE Left(t2.rangcode, 5) = Left(t1.rangcode, 5) AND
13 Right(t2.rangcode, 4) = '0000') AS class2,
14
15 (SELECT t2.rusname FROM biotopelist AS t2
16 WHERE Left(t2.rangcode, 7) = Left(t1.rangcode, 7) AND
17 Right(t2.rangcode, 2) = '00') AS class3
18
19 FROM biotopelist AS t1
20 WHERE Right(t1.rangcode, 2) <> '00' AND rusname