Changes between Version 19 and Version 20 of Meuse dbeel

Timestamp:

Jun 30, 2014 1:10:52 PM (11 years ago)

Author:

laura

Comment:

--

Meuse dbeel

@@ -1303 +1303 @@
 where wso_id in (select wso_id from europe.wso where area='Meuse');
 }}}
+
+
+= Recherche des wso1_id où il y a eu des déversements =
+{{{
+#!sql
+select b.wso1_id, a.ob_op_id from belge.electrofishing a
+JOIN dbeel.observation_places_ccm_500 b ON b.op_id=a.ob_op_id  where a.ope_id in (1275,1276,1277,1288,1290,1338) 
+}}}