SQL: select group_name,gc_flag,source_name,l,b,all_objects_withmet.ra,all_objects_withmet.dec,vmean,line_det,peak_22,rms_22,peak_6,rms_6,peak_12,rms_12,peak_95,rms_95,peak_84,rms_84,peak_44,rms_44,peak_36,rms_36,peak_1612,peak_1665,peak_1667,peak_1720,type,refs,type,simbad_types from all_objects_withmet LEFT JOIN object_categories ON all_objects_withmet.group_name = object_categories.group_name_cat AND object_categories.tbl_cat = 'all_objects_withmet' LEFT JOIN assoc ON all_objects_withmet.group_name = assoc.grp AND assoc.tbl = 'all_objects_withmet' WHERE ( refs ilike '%MCC18C%') ORDER BY l,b