Search
References
Objects
User-defined list
Papers & Acknowledgement
Citation tool
☰
Display data from paper
Select data type:
H
2
O
TOF95 - Exploring the engines of molecular outflows. Radio continuum and H_2_O maser observations.
Interferometry data
Short title
: Tofani et al. (1995)
Authors
: Tofani, G.Felli, M.Taylor, G. B.Hunter, T. R.
Journal
: Astronomy and Astrophysics Supplement, v.112, p.299
Bibcode
:
1995A&AS..112..299T
Target type
: IRAS,Outflows
Abstract
We present A-configuration VLA observations of the 22GHz H_2_O maser line and 8.4GHz continuum emission of 22 selected CO bipolar outflows associated with water masers. These observations allow us to study the region within 10^4^AU of the engine powering the outflow. The positions of the maser spots are compared with those of ultra-compact (UC) continuum sources found in our observations, with IRAS data and with data from the literature on the molecular outflows. Weak unresolved continuum sources are found in several cases associated with the maser. Most probably they represent the ionized envelope surrounding the young stellar object (YSO) which powers the maser and the outflow. These weak radio continuum sources are not necessarily associated with the IRAS sources, which are more representative of the global emission from the star forming region. A comparison of the velocity pattern of the CO outflow with those of the maser spots detected with the VLA is also made. Asymmetries in the H_2_O velocities are found on opposite sides of the YSO, suggesting that the outflow acceleration begins from the YSO itself. In a few cases we find evidence for two outflows in different evolutionary stages. The H_2_O masers in these sources are always found at the centre of the younger outflow. The degree of variability of each maser is derived from single dish observations obtained with the Medicina radiotelescope before and after the VLA observations. Velocity drifts of some features are interpreted as acceleration of the maser.
Download as
:
Table (CSV)
View paper statistics
Detection table from Tofani et al. (1995)
Export table to csv
Hide
/
Show
individual components
ID
Obs. RA
Obs. Dec
RA offset
Dec offset
l
b
Group id
#
Location
Source name
Image
Descr.
V
peak
F
peak
∫F dv
Telescope
RMS
Beam
PA
Detection
Date
(J2000)
(J2000)
(arcsec)
(arcsec)
(deg.)
(deg.)
(km/s)
(Jy)
(Jy*km/s)
(mJy/beam)
(arcsec)
(deg.)
Yes
/
No
1
+00 52 24.1832
+56 33 43.7482
123.065682
-6.309346
G123.066-6.309
NGC281-west
Image
-31.2 .. -27.3
0.72 .. 9.38
NRAOVLA
31.000
0.116 x 0.109
-51.2
+H
2
O
+CH
3
OH I
+CH
3
OH II
1992 November 24
+00 52 24.1832
+56 33 43.7482
589.316 mas
0.00103151
123.065682
-6.309346
1
C1
NGC281-west
-27.9
9.38 (0.48)
17.66 (0.46)
+00 52 24.698
+56 33 44.334
7.72257
0.58679
123.066871
-6.309179
2
C2
NGC281-west
-27.3
0.72 (0.06)
0.81 (0.05)
+00 52 24.7125
+56 33 50.5568
7.94084
6.80956
123.066898
-6.307450
3
C3
NGC281-west
-31.2
8.38 (0.43)
36.82 (0.53)
2
+05 30 47.967
+33 47 52.9565
174.201064
-0.070969
G174.198-0.077
AFGL5142
Image
Descr
-9.6 .. -1.7
0.62 .. 23.05
NRAOVLA
32.000
0.119 x 0.109
-55
+H
2
O
+CH
3
OH I
+CH
3
OH II
1992 November 24
+05 30 47.967
+33 47 52.9565
0.00107534
0.00172446
174.201064
-0.070969
1
C1
AFGL5142
-8.3
0.62 (0.09)
0.64 (0.07)
+05 30 48.0111
+33 47 53.3373
0.664028
0.38254
174.201059
-0.070783
2
C2
AFGL5142
-5
18.78 (1.29)
35.73 (1.09)
+05 30 48.0128
+33 47 54.6622
0.68827
1.70744
174.200755
-0.070576
3
C3
AFGL5142
-1.7
10.34 (0.53)
23.35 (0.49)
+05 30 48.0286
+33 47 54.3931
0.926502
1.43829
174.200848
-0.070571
4
C4
AFGL5142
-9.6
23.05 (1.16)
58.95 (1.21)
+05 30 48.1918
+33 47 54.6173
3.37417
1.66252
174.201106
-0.070065
5
C5
AFGL5142
-5.7
7.63 (0.39)
11.08 (0.34)
3
+05 32 41.6312
-05 35 46.394
208.897972
-20.050218
G208.898-20.050
OriA-west
Image
Descr
8
2.09
NRAOVLA
44.000
0.105 x 0.088
-20.6
+H
2
O
-CH
3
OH I
-CH
3
OH II
1992 November 24
+05 32 41.6312
-05 35 46.394
-0.00169563
0.00162658
208.897972
-20.050218
1
C1
OriA-west
8
2.09 (0.14)
6.14 (0.2)
4
+05 35 27.6224
-05 09 34.1106
208.815457
-19.23852
G208.816-19.239
OMC-2
Image
Descr
6.1 .. 12
2.03 .. 14.96
NRAOVLA
44.000
0.105 x 0.091
-33.1
+H
2
O
+CH
3
OH I
+CH
3
OH II
1992 November 24
+05 35 27.6224
-05 09 34.1106
0.00111065
-585.012 mas
208.815457
-19.238520
1
C1
OMC-2
6.1
2.03 (0.13)
2.02 (0.11)
+05 35 27.6303
-05 09 34.4912
0.119253
-0.38116
208.815572
-19.238538
2
C2
OMC-2
12
14.96 (0.8)
25.04 (0.83)
5
+05 39 12.8045
+35 45 51.032
173.481288
2.445366
G173.481+2.446
S233
Image
Descr
-17.5 .. -12.9
0.69 .. 5.39
NRAOVLA
26.000
0.133 x 0.127
-47.2
+H
2
O
+CH
3
OH I
+CH
3
OH II
+OH
1992 November 24
+05 39 12.8045
+35 45 51.032
748.312 mas
-0.00156552
173.481288
2.445366
1
C1
S233
-16.9
5.39 (0.27)
12.29 (0.29)
+05 39 12.961
+35 45 49.9307
2.34851
-1.10293
173.481829
2.445651
2
C2
S233
-17.5
0.75 (0.06)
1.3 (0.08)
+05 39 13.0405
+35 45 48.7829
3.54051
-2.25072
173.482243
2.445709
3
C3
S233
-15.6
3.25 (0.17)
3.89 (0.15)
+05 39 13.128
+35 45 51.6866
4.8523
0.652993
173.481716
2.446388
4
C4
S233
-12.9
0.69 (0.06)
0.65 (0.06)
6
+05 40 24.1713
+23 50 54.9814
183.719844
-3.66448
G183.721-3.664
GGD 4
Image
Descr
-2.4 .. 2.8
0.41 .. 18.65
NRAOVLA
29.000
0.113
-45.4
+H
2
O
+CH
3
OH I
-CH
3
OH II
1992 November 24
+05 40 24.1713
+23 50 54.9814
-422.097 mas
-209.081 mas
183.719844
-3.664480
1
C1
GGD 4
-2.4
0.41 (0.05)
0.75 (0.08)
+05 40 24.2322
+23 50 54.735
0.913346
-0.246633
183.720025
-3.664318
2
C2
GGD 4
2.8
18.65 (0.94)
44.82 (0.88)
7
+05 40 53.3858
+35 41 48.5321
173.718949
2.698165
G173.719+2.698
S235 B
Image
Descr
-61.2
165.73
NRAOVLA
48.000
0.117 x 0.109
-53.9
+H
2
O
+CH
3
OH I
+CH
3
OH II
-OH
1992 November 24
+05 40 53.3858
+35 41 48.5321
-0.00109534
0.0017016
173.718949
2.698165
1
C1
S235 B
-61.2
165.73 (8.29)
257.51 (6.38)
8
+05 47 4.74973
+00 21 42.827
205.109885
-14.109029
G205.109-14.109
NGC2071
Image
Descr
6 .. 16.6
1 .. 629.6
NRAOVLA
481.000
0.095 x 0.087
-37.4
+H
2
O
+CH
3
OH I
+CH
3
OH II
1992 November 24
+05 47 4.74973
+00 21 42.827
-0.00167042
0.00136166
205.109885
-14.109029
1
C1
NGC2071
12.6
4.95 (0.28)
9.63 (0.29)
+05 47 4.76271
+00 21 42.769
0.193051
-0.0565833
205.109926
-14.108989
2
C2
NGC2071
10
629.6 (32.97)
873.33 (23.85)
+05 47 4.77673
+00 21 42.816
0.403282
-0.00960237
205.109942
-14.108931
3
C3
NGC2071
13.3
6.32 (0.33)
21.95 (0.38)
+05 47 4.79267
+00 21 42.6458
0.64246
-0.179764
205.110018
-14.108895
4
C4
NGC2071
16.6
1 (0.1)
1.04 (0.08)
+05 47 4.79276
+00 21 42.9308
0.643842
0.105232
205.109946
-14.108857
5
C5
NGC2071
9.3
61.52 (3.2)
79.9 (2.44)
+05 47 4.78472
+00 21 42.8064
0.523237
-0.0191842
205.109961
-14.108903
6
C6
NGC2071
6
3.16 (0.26)
7.32 (0.4)
9
+06 07 47.8558
-06 22 56.5224
213.704874
-12.596935
G213.705-12.597
Mon R2
Image
Descr
12
227.13
NRAOVLA
253.000
0.121 x 0.099
-19.6
+H
2
O
+CH
3
OH I
+CH
3
OH II
+OH
1992 November 24
+06 07 47.8558
-06 22 56.5224
245.226 mas
-0.00121338
213.704874
-12.596935
1
C1
Mon R2
12
227.13 (11.43)
254.83 (9.14)
10
+06 08 53.3077
+21 38 13.706
188.949809
0.883796
G188.946+0.887
AFGL5180
Image
Descr
-2.4 .. 9.3
0.56 .. 288.7
NRAOVLA
583.000
0.112 x 0.108
-48.9
+H
2
O
+CH
3
OH I
+CH
3
OH II
+OH
1992 November 24
+06 08 53.3077
+21 38 13.706
0.00172821
-0.00159041
188.949809
0.883796
1
C1
AFGL5180
9.3
288.7 (14.49)
632.36 (13.81)
+06 08 53.3419
+21 38 11.6465
0.515128
-2.06111
188.950374
0.883635
2
C2
AFGL5180
3.4
0.56 (0.05)
1.01 (0.07)
+06 08 53.3562
+21 38 12.3235
0.728922
-1.38414
188.950236
0.883775
3
C3
AFGL5180
2.1
0.93 (0.06)
0.61 (0.04)
+06 08 53.4981
+21 38 30.6684
2.85693
16.9608
188.946044
0.886724
4
C4
AFGL5180
8.7
38.76 (2.15)
56.18 (1.86)
+06 08 53.5138
+21 38 5.97389
3.09312
-7.73371
188.952075
0.883454
5
C5
AFGL5180
-2.4
3.47 (0.18)
3.85 (0.14)
11
+06 10 52.1638
-06 11 31.7498
213.87859
-11.828802
G213.879-11.831
GGD 12-15
Image
Descr
-22.6
104.67
NRAOVLA
53.000
0.105 x 0.091
-33.5
+H
2
O
+CH
3
OH I
-CH
3
OH II
1992 November 24
+06 10 52.1638
-06 11 31.7498
434.345 mas
0.00102338
213.878590
-11.828802
1
C1
GGD 12-15
-22.6
104.67 (5.24)
240.48 (4.71)
12
+06 41 10.1514
+09 29 21.3212
203.319782
2.054888
G203.316+2.055
NGC2264
Image
Descr
7.1
44.18
NRAOVLA
30.000
0.098 x 0.092
-36.4
+H
2
O
+CH
3
OH I
+CH
3
OH II
1992 November 24
+06 41 10.1514
+09 29 21.3212
-0.00134487
-368.412 mas
203.319782
2.054888
1
C1
NGC2264
7.1
44.18 (2.21)
60.55 (1.89)
13
+20 14 25.9721
+41 13 32.949
78.122227
3.633048
G78.122+3.633
IRAS20126+4104
Image
Descr
-4 .. 3.2
1.25 .. 17.55
NRAOVLA
60.000
0.113 x 0.098
-62.5
+H
2
O
+CH
3
OH I
+CH
3
OH II
+OH
1992 November 24
+20 14 25.9721
+41 13 32.949
-66.717 mas
618.347 mas
78.122227
3.633048
1
C1
IRAS20126+4104
3.2
1.25 (0.1)
1.14 (0.08)
+20 14 26.0193
+41 13 32.7109
0.708298
-0.237515
78.122253
3.632888
2
C2
IRAS20126+4104
2.5
3 (0.17)
11.03 (0.25)
+20 14 26.0574
+41 13 32.6242
1.28026
-0.324199
78.122299
3.632775
3
C3
IRAS20126+4104
-4
17.55 (0.89)
24.72 (0.69)
14
+20 29 24.5478
+40 11 20.9422
78.886437
0.709865
G78.887+0.709
AFGL2591
Image
Descr
-21.8 .. 1.2
0.59 .. 54.99
NRAOVLA
39.000
0.109 x 0.096
-66.2
+H
2
O
+CH
3
OH I
+CH
3
OH II
1992 November 24
+20 29 24.5478
+40 11 20.9422
0.00109516
-0.00143105
78.886437
0.709865
1
C1
AFGL2591
-6.6
0.71 (0.1)
1.37 (0.11)
+20 29 24.8202
+40 11 19.183
4.08786
-1.76064
78.886549
0.708876
2
C2
AFGL2591
1.2
0.59 (0.06)
0.39 (0.04)
+20 29 24.8711
+40 11 19.6159
4.85189
-1.32768
78.886742
0.708815
3
C3
AFGL2591
-21.8
22.9 (1.15)
142.17 (1.88)
+20 29 24.869
+40 11 19.9948
4.8193
-0.948804
78.886823
0.708882
4
C4
AFGL2591
-7.3
54.99 (2.75)
85.16 (2.2)
15
+20 38 36.4615
+42 37 34.4213
81.871243
0.780492
G81.877+0.782
W75-N
Image
Descr
-7 .. 17.9
0.31 .. 81.96
NRAOVLA
35.000
0.11 x 0.096
-68.6
+H
2
O
+CH
3
OH I
+CH
3
OH II
+OH
1992 November 24
+20 38 36.4615
+42 37 34.4213
-304.503 mas
452.232 mas
81.871243
0.780492
1
C1
W75-N
-7
0.31 (0.03)
0.26 (0.03)
+20 38 36.4422
+42 37 35.0302
-0.29033
0.609373
81.871341
0.780642
2
C2
W75-N
12.6
81.96 (4.46)
183.66 (5.5)
+20 38 36.474
+42 37 33.5139
0.186488
-0.906859
81.871066
0.780309
3
C3
W75-N
11.3
16.76 (0.84)
19.2 (0.64)
+20 38 36.4786
+42 37 34.3642
0.255816
-0.0565888
81.871262
0.780441
4
C4
W75-N
17.9
47.14 (2.36)
258.62 (3.37)
+20 38 36.492
+42 37 35.595
0.457896
1.17418
81.871559
0.780616
5
C5
W75-N
9.3
13.75 (0.69)
27.15 (0.56)
16
+21 39 58.2635
+50 14 21.1467
94.602534
-1.796079
G94.602-1.796
V645 Cyg
Image
Descr
-43.3
3.91
NRAOVLA
27.000
0.118 x 0.096
-67.6
+H
2
O
-CH
3
OH I
+CH
3
OH II
-OH
-SiO
1992 November 24
+21 39 58.2635
+50 14 21.1467
-0.00168245
0.00149659
94.602534
-1.796079
1
C1
V645 Cyg
-43.3
3.91 (0.2)
5.62 (0.17)
17
+21 40 41.8391
+58 16 12.0074
99.982053
4.170845
G99.982+4.170
IC1396-north
Image
Descr
-4.4 .. 15.9
0.57 .. 25.35
NRAOVLA
25.000
0.119 x 0.109
-53.4
+H
2
O
+CH
3
OH I
+CH
3
OH II
1992 November 24
+21 40 41.8391
+58 16 12.0074
0.00171102
203.309 mas
99.982053
4.170845
1
C1
IC1396-north
-4.4
25.35 (1.27)
52.17 (1.3)
+21 40 41.8581
+58 16 12.0852
0.287765
0.0779991
99.982099
4.170834
2
C2
IC1396-north
15.9
0.57 (0.07)
0.64 (0.06)
+21 40 41.8621
+58 16 12.1784
0.347215
0.171165
99.982122
4.170848
3
C3
IC1396-north
6.7
11.46 (0.58)
18.36 (0.54)
+21 40 42.8546
+58 16 1.39758
15.2351
-10.6096
99.981780
4.167162
4
C4
IC1396-north
8.7
7.53 (0.39)
7.1 (0.27)
18
+21 43 6.29984
+66 06 55.9446
105.415221
9.878518
G105.414+9.878
LkHa 234
Image
Descr
-9.6 .. 1.5
0.59 .. 23.69
NRAOVLA
25.000
0.129 x 0.104
-61.5
+H
2
O
-CH
3
OH I
-CH
3
OH II
1992 November 24
+21 43 6.29984
+66 06 55.9446
0.00112684
591.666 mas
105.415221
9.878518
1
C1
LkHa 234
-9.6
23.69 (1.19)
39.67 (0.92)
+21 43 6.3737
+66 06 48.4895
1.10909
-7.45455
105.413925
9.876883
2
C2
LkHa 234
1.5
0.59 (0.05)
0.67 (0.05)
+21 43 6.45489
+66 06 55.3439
2.32694
-0.600073
105.415308
9.878220
3
C3
LkHa 234
-7
8.34 (0.42)
40.43 (0.57)
19
+22 19 18.156
+63 18 46.8038
106.796647
5.312074
G106.797+5.312
S140
Image
Descr
-14.9 .. 4.1
2.72 .. 181.53
NRAOVLA
111.000
0.073
-44.5
+H
2
O
+CH
3
OH I
+CH
3
OH II
+OH
1992 November 24
+22 19 18.156
+63 18 46.8038
-581.17 mas
216.449 mas
106.796647
5.312074
1
C1
S140
-14.9
181.53 (9.08)
143.92 (6.05)
+22 19 18.2315
+63 18 46.9392
1.13285
0.135567
106.796786
5.312027
2
C2
S140
4.1
2.72 (0.16)
2.28 (0.12)
20
+22 21 26.7197
+63 51 38.2834
107.298191
5.639832
G107.300+5.640
L1204-G
Image
Descr
-19.5 .. -1.7
0.3 .. 35.09
NRAOVLA
61.000
0.126 x 0.109
-57.5
+H
2
O
-CH
3
OH I
+CH
3
OH II
1992 November 24
+22 21 26.7197
+63 51 38.2834
304.582 mas
972.895 mas
107.298191
5.639832
1
C1
L1204-G
-11.6
0.3 (0.05)
0.3 (0.05)
+22 21 26.731
+63 51 38.0517
0.169211
-0.230686
107.298173
5.639767
2
C2
L1204-G
-19.5
35.09 (1.82)
70.53 (1.92)
+22 21 26.7421
+63 51 37.9441
0.33682
-0.338347
107.298174
5.639730
3
C3
L1204-G
-16.2
7.17 (0.37)
10.19 (0.34)
+22 21 26.7672
+63 51 38.1388
0.713151
-0.143581
107.298242
5.639751
4
C4
L1204-G
-1.7
3.51 (0.19)
4.26 (0.16)
21
+23 16 9.89911
+59 55 32.2426
111.255148
-0.768482
G111.255-0.770
IRAS23139+5939
Image
Descr
-53.6 .. -43.7
0.92 .. 59.32
NRAOVLA
76.000
0.119 x 0.111
-52.2
+H
2
O
+CH
3
OH I
+CH
3
OH II
1992 November 24
+23 16 9.89911
+59 55 32.2426
0.0010969
-208.721 mas
111.255148
-0.768482
1
C1
IRAS23139+5939
-43.7
1.69 (0.12)
1.65 (0.11)
+23 16 10.3436
+59 55 28.8409
6.66809
-3.40193
111.255675
-0.769698
2
C2
IRAS23139+5939
-53.6
59.32 (3.0)
210.22 (3.3)
+23 16 10.3527
+59 55 28.602
6.8051
-3.6408
111.255668
-0.769766
3
C3
IRAS23139+5939
-45.7
0.96 (0.15)
1.19 (0.11)
+23 16 10.4415
+59 55 28.3563
8.13687
-3.88655
111.255817
-0.769897
4
C4
IRAS23139+5939
-47
0.92 (0.07)
1.09 (0.07)
22
+23 17 20.799
+59 28 47.1933
111.235007
-1.238146
G111.236-1.238
IRAS23151+5912
Image
Descr
-68.7 .. -52.9
2.46 .. 29.58
NRAOVLA
38.000
0.114 x 0.107
-51.2
+H
2
O
+CH
3
OH I
-CH
3
OH II
-OH
1992 November 24
+23 17 20.799
+59 28 47.1933
-0.00123917
-288.322 mas
111.235007
-1.238146
1
C1
IRAS23151+5912
-52.9
29.58 (1.48)
30.85 (1.06)
+23 17 20.8514
+59 28 47.434
0.784207
0.240433
111.235134
-1.238123
2
C2
IRAS23151+5912
-68.7
2.46 (0.14)
6.7 (0.19)
Get selected data
X
DSS colored
2MASS colored
WISE colored
SDSS color
IRAC color I1,I2,I4
GLIMPSE 360
PACS color (70-160 um)
SPIRE color (250-500 um)
NVSS (1.4GHz)
ATLASGAL 870 um
ATLASGAL 870 um + Planck
Bolocam 1.1 mm
UKIDSS K
2MASS K
select MAX(h2o_data_all.ra_hms) as ra_hms,MAX(h2o_data_all.dec_dms) as dec_dms,MAX(h2o_data_all.source_name) as source_name,MAX(h2o_data_all.ra) as ra,MAX(h2o_data_all.dec) as dec,MAX(h2o_data_all.l) as l,MAX(h2o_data_all.b) as b,MAX(h2o_data_all.grp) as grp,MAX(h2o_data_all.other_name) as other_name,MAX(h2o_data_all.other_desc) as other_desc,BOOL_OR(thermal) as thermal,MAX(h2o_data_all.vrange) as vrange,MAX(h2o_data_all.vpeak) as vpeak,MAX(h2o_data_all.peak) as peak,MAX(h2o_data_all.fwhm) as fwhm,MAX(h2o_data_all.int) as int,MAX(h2o_data_all.rms) as rms,MAX(h2o_data_all.units) as units,MAX(h2o_data_all.units_rms) as units_rms,MAX(h2o_data_all.date_txt) as date_txt,MAX(h2o_data_all.telescope_ref) as telescope_ref,MAX(h2o_data_all.beam) as beam,MAX(h2o_data_all.beam_maj) as beam_maj,MAX(h2o_data_all.beam_min) as beam_min,MAX(h2o_data_all.beam_pa) as beam_pa,MAX(h2o_data_all.ref) as ref,MAX(h2o_data_all.list_ref) as list_ref,MAX(h2o_data_all.ascii) as ascii,MAX(h2o_data_all.image) as image,MAX(h2o_data_all.descr) as descr,MAX(h2o_data_all.id) as id,BOOL_OR(mjy_flag) as mjy_flag,BOOL_OR(rms_mjy_flag) as rms_mjy_flag,MAX(h2o_data_all.dist) as dist,MAX(h2o_data_all.date_txt) as date_txt,MAX(line_det) as line_det FROM h2o_data_all LEFT JOIN all_objects_withmet ON h2o_data_all.grp=all_objects_withmet.group_name WHERE ref ilike 'TOF95' AND detected=true AND hide=false GROUP BY ref
select h2o_data_all.ra_hms,h2o_data_all.dec_dms,h2o_data_all.source_name,h2o_data_all.ra,h2o_data_all.dec,h2o_data_all.l,h2o_data_all.b,h2o_data_all.grp,h2o_data_all.other_name,h2o_data_all.other_desc,h2o_data_all.thermal,h2o_data_all.vrange,h2o_data_all.vpeak,h2o_data_all.peak,h2o_data_all.fwhm,h2o_data_all.int,h2o_data_all.rms,h2o_data_all.units,h2o_data_all.units_rms,h2o_data_all.date_txt,h2o_data_all.telescope_ref,h2o_data_all.beam,h2o_data_all.beam_maj,h2o_data_all.beam_min,h2o_data_all.beam_pa,h2o_data_all.ref,h2o_data_all.list_ref,h2o_data_all.ascii,h2o_data_all.image,h2o_data_all.descr,h2o_data_all.id,h2o_data_all.mjy_flag,h2o_data_all.rms_mjy_flag,h2o_data_all.dist,h2o_data_all.date_txt,line_det FROM h2o_data_all LEFT JOIN all_objects_withmet ON h2o_data_all.grp=all_objects_withmet.group_name WHERE ref ilike 'TOF95' AND detected=true AND hide=false ORDER BY detected DESC,id
