log
graph
tags
branches
changeset
browse
file
latest
diff
comparison
annotate
file log
raw
help
Mercurial
>
hg
>
tema
view misc/biotopes/class.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
FROM biotopelist AS t1
3
WHERE rusname AND Right(t1.rangcode, 8) = '00000000'
4
AND EXISTS
5
(SELECT NULL FROM biotopelist AS t2
6
WHERE Left(t2.rangcode, 1) = Left(t1.rangcode, 1)
7
AND Right(t2.rangcode, 8) <> '00000000')