Display data from paper

Select data type:

LEW87 - OH/IR stars without OH masers - Nondetection statistics

Short title: Lewis et al. (1987)
Authors: Lewis, B. M. Eder, J. Terzian, Yervant
Journal: Astronomical Journal (ISSN 0004-6256), vol. 94, Oct. 1987, p. 1025-1034. Research supported by the National Astronomy and Ionosphere Center.
Bibcode:

Non-detection table: Show non-detection table
Detection table: Show detection table (0 detection) Non-detection table: Show non-detection table (117 non-detection)

Abstract
Potential OH/IR stars are readily recognized from their far-infrared colors. These are confirmed as OH/IR stars by detecting their 1612 MHz masers. Color selection from the sources listed in the IRAS Point Source Catalog therefore provides an efficient means for identifying new objects. However, this approach is not so efficient with weak sources (S₂₅ < 2 Jy). Color-selected sources with S₂₅ _> 2 Jy that are not associated with OH masers have the same color-color range, the same IR flux range, and a similar galactic distribution to the detections. These sources are explicable as normal OH/IR stars in which the OH maser is being suppressed. This would occur when a star with a circumstellar envelope also has a companion star that is able to disrupt the velocity coherence of the normal masing shell. The detection to nondetection ratio then provides a tool for studying the duplicity of these stars over the whole Galaxy.	Comments: Velocity resolution: 0.91 km/s Upper limit for non-detections: 0.025 Jy (3σ)

Abstract

Potential OH/IR stars are readily recognized from their far-infrared colors. These are confirmed as OH/IR stars by detecting their 1612 MHz masers. Color selection from the sources listed in the IRAS Point Source Catalog therefore provides an efficient means for identifying new objects. However, this approach is not so efficient with weak sources (S₂₅ < 2 Jy). Color-selected sources with S₂₅ _> 2 Jy that are not associated with OH masers have the same color-color range, the same IR flux range, and a similar galactic distribution to the detections. These sources are explicable as normal OH/IR stars in which the OH maser is being suppressed. This would occur when a star with a circumstellar envelope also has a companion star that is able to disrupt the velocity coherence of the normal masing shell. The detection to nondetection ratio then provides a tool for studying the duplicity of these stars over the whole Galaxy.

Comments:
Velocity resolution: 0.91 km/s
Upper limit for non-detections: 0.025 Jy (3σ)

Input tables: Table II
Download as: Table (CSV)
View paper data

Non-detection table from Lewis et al. (1987)

Export table to csv

Hide / Show individual components

ID	Obs. RA	Obs. Dec	l	b	Group id	Source name	F_peak	List	Detection	Ref.
	(J2000)	(J2000)	(deg.)	(deg.)			(Jy)		Yes/No
1	14 15 40.3	+19 11 33	15.0785	69.1135	G15.079+69.114	IRAS 14133+1925	0.025	ENG15	-OH	LEW87
2	14 24 11.2	+25 42 15	34.2779	69.2144	G34.278+69.213	IRAS 14219+2555	0.025	ENG15	+H₂O -CH₃OH I +OH +SiO	LEW87
3	14 39 15.4	+32 32 22	52.5309	66.0694	G52.531+66.068	IRAS 14371+3245	0.025	ENG15	-H₂O -OH	LEW87
4	15 32 24.1	+03 38 30	8.6508	44.9872	G8.652+44.984	IRAS 15298+0348	0.025	ENG15	+H₂O -OH +SiO	LEW87
5	15 35 36.6	+25 45 09	40.3436	53.3881	G40.344+53.388	IRAS 15334+2555	0.025	ENG15	-OH -SiO	LEW87
6	15 44 06	+02 23 26	9.5749	41.8817	G9.575+41.881	IRAS 15415+0232	0.025	ENG15	-OH -SiO	LEW87
7	15 48 35.3	+28 09 22	45.0494	50.9749	G45.050+50.978	IRAS 15465+2818	0.025	ENG15	-H₂O -OH	LEW87
8	15 50 41.4	+15 08 02	26.2333	46.7622	G26.234+46.761	IRAS 15483+1517	0.025	ENG15	+H₂O -OH +SiO	LEW87
9	15 58 30.7	+36 01 18	57.6117	49.5699	G57.612+49.570	IRAS 15566+3609	0.025	ENG15	-OH +SiO	LEW87
10	16 12 29.8	+24 53 56	41.9185	45.0737	G41.919+45.074	IRAS 16103+2501	0.025	ENG15	-OH +SiO	LEW87
11	16 23 5.1	+30 51 01	50.7647	43.9946	G50.765+43.995	IRAS 16211+3057	0.025	ENG15	+H₂O -OH -SiO	LEW87
12	16 35 31.9	+03 59 41	19.8516	31.8657	G19.852+31.865	IRAS 16330+0405	0.025	ENG15	-OH -SiO	LEW87
13	16 38 51.6	+14 03 58	31.1314	35.6502	G31.132+35.649	IRAS 16365+1409	0.025	ENG15	-OH +SiO	LEW87
14	16 41 58.7	+32 55 29	54.4021	40.3717	G54.402+40.371	IRAS 16400+3301	0.025	ENG15	-OH -SiO	LEW87
15	17 00 47.6	+02 08 18	21.5403	25.4609	G21.540+25.461	IRAS 16582+0212	0.025	ENG15	-OH	LEW87
16	17 12 27.9	+10 35 06	31.3843	26.7392	G31.384+26.739	IRAS 17101+1038	0.025	ENG15	-OH	LEW87
17	17 13 50	+07 13 31	28.1897	24.9675	G28.190+24.968	IRAS 17114+0716	0.025	ENG15	-OH	LEW87
18	17 14 39.8	+11 04 07	32.1299	26.4549	G32.130+26.455	IRAS 17123+1107	0.025	ENG15	+H₂O -OH -SiO	LEW87
19	17 20 18.8	+18 03 24	39.9551	27.9680	G39.955+27.968	IRAS 17181+1806	0.025	ENG15	-OH	LEW87
20	17 23 56.5	+08 57 14	31.1014	23.4850	G31.101+23.485	IRAS 17215+0859	0.025	ENG15	-OH	LEW87
21	17 31 54.9	+17 45 20	40.7977	25.2958	G40.798+25.296	IRAS 17297+1747	0.025	ENG15	-H₂O -OH	LEW87
22	17 34 16.5	+00 52 36	24.6719	17.5153	G24.672+17.515	IRAS 17317+0054	0.025	ENG15	-OH -SiO	LEW87
23	17 38 28.1	+04 39 41	28.7062	18.3448	G28.706+18.346	IRAS 17359+0441	0.025	ENG15	-OH +SiO	LEW87
24	17 40 30.2	+01 56 25	26.4190	16.6406	G26.419+16.640	IRAS 17379+0157	0.025	ENG15	-OH -SiO	LEW87
25	18 01 6.7	+00 41 44	27.7494	11.5011	G27.749+11.501	IRAS 17585+0041	0.025	ENG15	-OH	LEW87
26	18 01 49.5	+08 27 01	34.9421	14.8384	G34.942+14.838	IRAS 17594+0826	0.025	ENG15	+H₂O -OH +SiO	LEW87
27	18 08 20	+24 10 42	50.6744	19.7896	G50.674+19.790	IRAS 18062+2410	0.025	ENG15	-OH	LEW87
28	18 20 8.7	+25 51 36	53.3769	17.9327	G53.377+17.933	IRAS 18181+2550	0.025	ENG15	-OH	LEW87
29	18 23 10.6	+01 30 18	31.0445	6.9733	G31.044+6.973	IRAS 18206+0128	0.025	ENG15	-OH	LEW87
30	18 24 3.8	+06 36 26	35.7431	9.0800	G35.743+9.080	IRAS 18216+0634	0.025	ENG15	-H₂O +OH -SiO	LEW87
31	18 30 15.9	+21 51 57	50.4914	14.2422	G50.492+14.242	IRAS 18281+2149	0.025	ENG15	-H₂O -OH -SiO	LEW87
32	18 35 46.2	+05 35 51	36.1490	6.0262	G36.149+6.026	IRAS 18333+0533	0.025	ENG15	-H₂O -CH₃OH II -OH	LEW87
33	18 41 34	+13 31 53	43.9512	8.2763	G43.951+8.276	IRAS 18392+1328	0.025	ENG15	-OH -SiO	LEW87
34	18 42 29.6	+01 42 45	33.4375	2.7706	G33.437+2.771	IRAS 18399+0139	0.025	ENG15	-OH	LEW87
35	18 43 36.4	+03 46 39	35.4061	3.4616	G35.406+3.462	IRAS 18411+0343	0.025	ENG15	-OH	LEW87
36	18 44 12.7	+02 08 15	34.0119	2.5817	G34.012+2.582	IRAS 18416+0205	0.025	ENG15	-OH	LEW87
37	18 47 32.2	+00 46 17	33.1738	1.2197	G33.174+1.219	IRAS 18449+0042	0.025	ENG15	-OH -SiO	LEW87
38	18 49 39	+00 18 52	33.0080	0.5412	G33.008+0.541	IRAS 18470+0015	0.025	ENG15	-H₂O -CH₃OH I +OH	LEW87
39	18 51 42.7	+09 54 57	41.8056	4.4434	G41.806+4.443	IRAS 18493+0951	0.025	ENG15	-OH	LEW87
40	18 54 47.3	+00 25 25	33.6909	-0.5523	G33.691-0.553	IRAS 18522+0021	0.025	ENG15	+H₂O -OH +SiO	LEW87
41	18 55 4.2	+09 49 37	42.1007	3.6653	G42.101+3.665	IRAS 18526+0945	0.025	ENG15	-OH -SiO	LEW87
42	18 55 3.5	+15 47 14	47.4450	6.3458	G47.445+6.346	IRAS 18528+1543	0.025	ENG15	-OH +SiO	LEW87
43	18 57 5.3	+12 58 29	45.1404	4.6459	G45.140+4.646	IRAS 18547+1254	0.025	ENG15	-OH +SiO	LEW87
44	18 58 14.3	+00 07 27	33.8178	-1.4564	G33.818-1.456	IRAS 18556+0003	0.025	ENG15	-OH	LEW87
45	19 00 15	+09 56 00	42.7757	2.5769	G42.776+2.577	IRAS 18578+0951	0.025	ENG15	-CH₃OH II -OH -SiO	LEW87
46	19 02 56.2	+06 32 24	40.0601	0.4349	G40.060+0.435	IRAS 19004+0627	0.025	ENG15	-OH	LEW87
47	19 03 31.5	+08 57 20	42.2745	1.4118	G42.274+1.412	IRAS 19011+0852	0.025	ENG15	-OH -SiO	LEW87
48	19 03 44.3	+06 34 12	40.1780	0.2717	G40.178+0.272	IRAS 19013+0629	0.025	ENG15	-H₂O -OH	LEW87
49	19 03 52.6	+13 01 21	45.9344	3.1936	G45.934+3.194	IRAS 19015+1256	0.025	ENG15	-H₂O -CH₃OH I -OH	LEW87
50	19 06 11.5	+08 29 07	42.1588	0.6105	G42.159+0.610	IRAS 19037+0824	0.025	ENG15	+H₂O -CH₃OH II +OH	LEW87
51	19 06 58.6	+15 43 58	48.6939	3.7615	G48.694+3.761	IRAS 19047+1539	0.025	ENG15	-H₂O -OH +SiO	LEW87
52	19 08 7.2	+10 07 42	43.8367	0.9437	G43.837+0.944	IRAS 19057+1002	0.025	ENG15	-OH -SiO	LEW87
53	19 08 52.1	+14 49 07	48.0887	2.9376	G48.089+2.938	IRAS 19065+1444	0.025	ENG15	-OH +SiO	LEW87
54	19 09 16.1	+13 40 24	47.1148	2.3256	G47.115+2.326	IRAS 19069+1335	0.025	ENG15	-CH₃OH II -OH -SiO	LEW87
55	19 09 38.3	+06 30 05	40.7909	-1.0612	G40.791-1.061	IRAS 19071+0625	0.025	ENG15	-H₂O -OH +SiO	LEW87
56	19 09 59.9	+04 37 06	39.1604	-2.0085	G39.161-2.009	IRAS 19075+0432	0.025	ENG15	-H₂O -CH₃OH I -CH₃OH II -OH	LEW87
57	19 09 57	+10 45 53	44.6089	0.8377	G44.609+0.838	IRAS 19075+1040	0.025	ENG15	-OH	LEW87
58	19 11 7.9	+10 11 30	44.2348	0.3154	G44.241+0.309	IRAS 19087+1006	0.025	ENG15	-H₂O -CH₃OH II -OH -SiO	LEW87
59	19 11 11	+15 47 13	49.2067	2.8867	G49.207+2.886	IRAS 19089+1542	0.025	ENG15	-H₂O -CH₃OH I -OH -SiO	LEW87
60	19 11 19.1	+15 32 31	49.0039	2.7451	G49.004+2.745	IRAS 19090+1527	0.025	ENG15	-OH	LEW87
61	19 12 31	+14 01 35	47.7921	1.7887	G47.792+1.789	IRAS 19102+1356	0.025	ENG15	-OH -SiO	LEW87
62	19 13 18.8	+15 39 37	49.3308	2.3735	G49.331+2.374	IRAS 19110+1534	0.025	ENG15	-OH	LEW87
63	19 14 25.2	+15 04 55	48.9415	1.8693	G48.942+1.869	IRAS 19121+1459	0.025	ENG15	-OH	LEW87
64	19 14 59.4	+17 22 42	51.0416	2.8122	G51.042+2.812	IRAS 19127+1717	0.025	ENG15	-H₂O +OH -SiO	LEW87
65	19 15 35.3	+21 36 33	54.8681	4.6401	G54.868+4.640	IRAS 19134+2131	0.025	ENG15	+H₂O -CH₃OH I -CH₃OH II -OH -SiO	LEW87
66	19 15 47.1	+21 00 31	54.3545	4.3229	G54.355+4.323	IRAS 19136+2055	0.025	ENG15	-OH -SiO	LEW87
67	19 16 22.5	+13 18 40	47.5936	0.6265	G47.594+0.626	IRAS 19140+1313	0.025	ENG15	-OH -SiO	LEW87
68	19 19 32.1	+11 24 48	46.2765	-0.9427	G46.276-0.943	IRAS 19171+1119	0.025	ENG15	-OH -SiO	LEW87
69	19 19 52.2	+21 34 03	55.2928	3.7384	G55.293+3.738	IRAS 19177+2128	0.025	ENG15	-CH₃OH II -OH	LEW87
70	19 20 30.1	+13 51 56	48.5528	-0.0004	G48.553-0.000	IRAS 19181+1346	0.025	ENG15	-OH	LEW87
71	19 20 22.8	+16 23 33	50.7703	1.2119	G50.770+1.212	IRAS 19181+1617	0.025	ENG15	-OH	LEW87
72	19 22 25.4	+20 15 33	54.4139	2.5995	G54.414+2.599	IRAS 19202+2009	0.025	ENG15	+OH -SiO	LEW87
73	19 23 17.8	+04 14 04	40.3577	-5.1241	G40.358-5.124	IRAS 19208+0408	0.025	ENG15	-OH	LEW87
74	19 24 27.6	+30 19 30	63.5659	6.8876	G63.565+6.889	IRAS 19225+3013	0.025	ENG15	-OH	LEW87
75	19 25 0.1	+17 06 54	51.9293	0.5770	G51.929+0.577	IRAS 19227+1700	0.025	ENG15	-H₂O +OH -SiO	LEW87
76	19 25 10.7	+14 09 13	49.3421	-0.8646	G49.342-0.865	IRAS 19228+1403	0.025	ENG15	-OH -SiO	LEW87
77	19 25 40.8	+16 33 04	51.5099	0.1666	G51.510+0.167	IRAS 19234+1627	0.025	ENG15	-OH	LEW87
78	19 25 50.5	+36 21 30	69.1203	9.3889	G69.120+9.389	IRAS 19240+3615	0.025	ENG15	-H₂O +OH +SiO	LEW87
79	19 30 14.3	+23 14 59	57.9105	2.4196	G57.911+2.420	IRAS 19281+2308	0.025	ENG15	-OH -SiO	LEW87
80	19 33 16.7	+17 52 03	53.5348	-0.7954	G53.535-0.795	IRAS 19310+1745	0.025	ENG15	-H₂O -CH₃OH I -OH -SiO	LEW87
81	19 34 44.5	+17 32 15	53.4149	-1.2601	G53.415-1.260	IRAS 19325+1725	0.025	ENG15	-OH -SiO	LEW87
82	19 35 18.1	+17 12 59	53.1990	-1.5328	G53.199-1.533	IRAS 19330+1706	0.025	ENG15	-OH	LEW87
83	19 36 9.2	+15 28 44	51.7788	-2.5557	G51.779-2.556	IRAS 19338+1522	0.025	ENG15	-OH -SiO	LEW87
84	19 36 37.3	+21 21 12	56.9641	0.2104	G56.964+0.210	IRAS 19344+2114	0.025	ENG15	-OH +SiO	LEW87
85	19 37 13.5	+17 03 49	53.2894	-2.0086	G53.290-2.009	IRAS 19349+1657	0.025	ENG15	+H₂O -OH +SiO	LEW87
86	19 39 35.3	+24 06 25	59.6996	0.9638	G59.700+0.964	IRAS 19374+2359	0.025	ENG15	+H₂O -CH₃OH I -OH	LEW87
87	19 41 13.6	+24 13 11	59.9821	0.6944	G59.982+0.694	IRAS 19391+2406	0.025	ENG15	-OH	LEW87
88	19 43 19.7	+26 26 46	62.1512	1.3863	G62.151+1.386	IRAS 19412+2619	0.025	ENG15	-OH -SiO	LEW87
89	19 44 11.9	+25 14 51	61.2094	0.6194	G61.209+0.619	IRAS 19421+2507	0.025	ENG15	-OH -SiO	LEW87
90	19 46 13.9	+09 41 13	47.9085	-7.5290	G47.909-7.529	IRAS 19438+0933	0.025	ENG15	-CH₃OH II -OH -SiO	LEW87
91	19 47 24.2	+29 28 12	65.2211	2.1200	G65.221+2.120	IRAS 19454+2920	0.025	ENG15	-OH	LEW87
92	19 48 10.1	+08 39 54	47.2444	-8.4457	G47.245-8.446	IRAS 19457+0832	0.025	ENG15	-OH -SiO	LEW87
93	19 49 54.4	+24 08 51	60.9120	-1.0547	G60.912-1.055	IRAS 19477+2401	0.025	ENG15	-H₂O +OH	LEW87
94	19 50 7.9	+25 11 55	61.8433	-0.5644	G61.843-0.564	IRAS 19480+2504	0.025	ENG15	-OH	LEW87
95	19 50 48.1	+22 23 14	59.5002	-2.1267	G59.500-2.127	IRAS 19486+2215	0.025	ENG15	-OH	LEW87
96	19 52 59.2	+29 38 40	65.9887	1.1630	G65.989+1.163	IRAS 19509+2930	0.025	ENG15	-OH -SiO	LEW87
97	19 56 28.8	+23 16 15	60.9315	-2.7959	G60.931-2.796	IRAS 19543+2308	0.025	ENG15	-OH	LEW87
98	19 56 47.8	+30 43 58	67.3461	1.0202	G67.346+1.020	IRAS 19548+3035	0.025	ENG15	-OH	LEW87
99	19 57 48.2	+33 41 20	69.9823	2.3770	G69.982+2.377	IRAS 19558+3333	0.025	ENG15	-CH₃OH II -OH -SiO	LEW87
100	20 02 26.3	+30 04 19	67.4228	-0.3620	G67.423-0.362	IRAS 20004+2955	0.025	ENG15	-OH -SiO	LEW87
101	20 05 29.6	+32 51 35	70.1282	0.5743	G70.128+0.574	IRAS 20035+3242	0.025	ENG15	-H₂O -CH₃OH I -OH	LEW87
102	20 06 10.5	+33 07 51	70.4337	0.5994	G70.434+0.599	IRAS 20042+3259	0.025	ENG15	-H₂O -CH₃OH I -OH	LEW87
103	20 07 12.1	+33 01 55	70.4663	0.3649	G70.466+0.365	IRAS 20052+3253	0.025	ENG15	-OH	LEW87
104	20 07 54.7	+18 42 56	58.4414	-7.4561	G58.441-7.456	IRAS 20056+1834	0.025	ENG15	-OH -SiO	LEW87
105	20 10 33.5	+27 59 36	66.6245	-2.9761	G66.625-2.976	IRAS 20084+2750	0.025	ENG15	-OH +SiO	LEW87
106	20 12 22.5	+31 02 56	69.4005	-1.6347	G69.400-1.635	IRAS 20103+3053	0.025	ENG15	-OH	LEW87
107	20 16 00	+13 18 55	54.8396	-11.9662	G54.840-11.966	IRAS 20136+1309	0.025	ENG15	+OH -SiO	LEW87
108	20 21 3.2	+32 29 20	71.6263	-2.3608	G71.622-2.363	IRAS 20190+3219	0.025	ENG15	-OH	LEW87
109	20 21 51.9	+27 17 42	67.4348	-5.4468	G67.435-5.447	IRAS 20197+2708	0.025	ENG15	-OH	LEW87
110	20 24 1.1	+34 14 39	73.4222	-1.8674	G73.422-1.867	IRAS 20220+3404	0.025	ENG15	-OH +SiO	LEW87
111	20 51 52.4	+29 07 50	72.8869	-9.6723	G72.887-9.672	IRAS 20497+2856	0.025	ENG15	-OH	LEW87
112	20 53 48.1	+26 59 27	71.4570	-11.3405	G71.457-11.341	IRAS 20516+2648	0.025	ENG15	-OH	LEW87
113	20 56 14.8	+36 43 17	79.3930	-5.5622	G79.393-5.562	IRAS 20542+3631	0.025	ENG15	-OH	LEW87
114	21 02 6.9	+18 10 36	65.5316	-18.3119	G65.532-18.312	IRAS 20598+1758	0.025	ENG15	-H₂O -OH	LEW87
115	22 06 0.2	+35 30 09	88.8641	-16.2015	G88.864-16.202	IRAS 22038+3515	0.025	ENG15	-OH	LEW87
116	23 07 35.7	+23 46 53	94.3097	-33.2550	G94.310-33.255	IRAS 23051+2330	0.025	ENG15	-OH	LEW87
117	23 19 11.6	+17 11 28	93.5218	-40.3543	G93.523-40.354	IRAS 23166+1655	0.025	ENG15	+H₂O -CH₃OH II -OH +SiO	LEW87

Distribution of sources in all sky (l,b)

Distribution of sources in all sky using Aladin

Tip: Click on some source to get more informaiton

Distribution of sources in IRAS color-color diagram

Tip: Use "Box select" or "Lasso select" to display colour-selected sources in Aladin all-sky view

Tip: Click on some source to look at the different surveys. You must select some surveys in previous page at "View images"

Original color diagram is taken form van der Veen & Habing (1987)

Type	Description
I	Oxygen-rich non-variable stars without circumstellar shells
II	Variable stars with "young" O-rich circumstellar shells
IIIa	Variable stars with more evolved O-rich circumstellar shells
IIIb	Variable stars with thick O-rich circumstellar shells
IV	Variable stars with very thick O-rich circumstellar shells
V	Planetary nebulae and non- variable stars with very cool circumstellar shells
VIa	Variable stars with relatively cold dust at large distances; a significant part of the stars is carbon-rich
VIb	Variable stars with relatively hot dust close to the star and relatively cold dust at large distances; Some of the objects have proven to be O-rich
VII	Variable stars with more evolved C-rich circumstellar shells
VIII	Different sort of objects

Distribution of the detection velocities versus galactic longitude from LEW87

Tip: Use "Box select" or "Lasso select" to display velocity-selected sources in Aladin all-sky view

Tip: Click on some source to look at the different surveys. You must select some surveys in previous page at "View images"

Longitude-Velocity Map is taken form Dame, Hartmann & Thaddeus (2001)

Distribution of sources from LEW87 in (l,b) histograms

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(oh_data_all.ra_hms) as ra_hms,MAX(oh_data_all.dec_dms) as dec_dms,MAX(oh_data_all.source_name) as source_name,MAX(oh_data_all.ra) as ra,MAX(oh_data_all.dec) as dec,MAX(oh_data_all.l) as l,MAX(oh_data_all.b) as b,MAX(oh_data_all.grp) as grp,MAX(oh_data_all.other_name) as other_name,MAX(oh_data_all.other_desc) as other_desc,BOOL_OR(thermal) as thermal,MAX(oh_data_all.freq) as freq,MAX(oh_data_all.vrange) as vrange,MAX(oh_data_all.vpeak) as vpeak,MAX(oh_data_all.peak) as peak,MAX(oh_data_all.fwhm) as fwhm,MAX(oh_data_all.int) as int,MAX(oh_data_all.rms) as rms,MAX(oh_data_all.units) as units,MAX(oh_data_all.units_rms) as units_rms,MAX(oh_data_all.date_txt) as date_txt,MAX(oh_data_all.telescope_ref) as telescope_ref,MAX(oh_data_all.beam) as beam,MAX(oh_data_all.beam_maj) as beam_maj,MAX(oh_data_all.beam_min) as beam_min,MAX(oh_data_all.beam_pa) as beam_pa,MAX(oh_data_all.ref) as ref,MAX(oh_data_all.list_ref) as list_ref,MAX(oh_data_all.ascii) as ascii,MAX(oh_data_all.image) as image,MAX(oh_data_all.descr) as descr,MAX(oh_data_all.id) as id,BOOL_OR(mjy_flag) as mjy_flag,BOOL_OR(rms_mjy_flag) as rms_mjy_flag,MAX(oh_data_all.dist) as dist,MAX(oh_data_all.date_txt) as date_txt,MAX(line_det) as line_det FROM oh_data_all  LEFT JOIN all_objects_withmet ON oh_data_all.grp=all_objects_withmet.group_name  WHERE ref ilike 'LEW87' AND detected=true AND hide=false GROUP BY ref

select oh_data_all.ra_hms,oh_data_all.dec_dms,oh_data_all.source_name,oh_data_all.ra,oh_data_all.dec,oh_data_all.l,oh_data_all.b,oh_data_all.grp,oh_data_all.other_name,oh_data_all.other_desc,oh_data_all.thermal,oh_data_all.freq,oh_data_all.vrange,oh_data_all.vpeak,oh_data_all.peak,oh_data_all.fwhm,oh_data_all.int,oh_data_all.rms,oh_data_all.units,oh_data_all.units_rms,oh_data_all.date_txt,oh_data_all.telescope_ref,oh_data_all.beam,oh_data_all.beam_maj,oh_data_all.beam_min,oh_data_all.beam_pa,oh_data_all.ref,oh_data_all.list_ref,oh_data_all.ascii,oh_data_all.image,oh_data_all.descr,oh_data_all.id,oh_data_all.mjy_flag,oh_data_all.rms_mjy_flag,oh_data_all.dist,oh_data_all.date_txt,line_det FROM oh_data_all   LEFT JOIN all_objects_withmet ON oh_data_all.grp=all_objects_withmet.group_name  WHERE ref ilike 'LEW87' AND detected=true AND hide=false ORDER BY detected DESC,id