[CAM01, CAM03, CAM04, SWS01, SWS02, SWS06, SWS07, LWS01, LWS02, LWS03, LWS04, PHT03, PHT04, PHT05, PHT17, PHT18, PHT19, PHT22, PHT25, PHT32, PHT37, PHT38, PHT39, PHT40]

doQuery

ADQL

VOTABLE_PLAIN

RUN

SELECT DISTINCT ( ida.observations.obsno ) ,ida.observations.tdt_char, ida.observations.obsno, ida.observations.obsno_char, ida.observations.instid, ida.observations.instrument_mode, ida.observations.ra, ida.observations.dec, ida.observations.target, ida.observations.start_time, ida.observations.end_time, ida.observations.hpdp_available, ida.observations.default_vo_product, ida.observations.bp_valid, ida.observations.object_type, ida.observations.propid, ida.observations.obsid, ida.observations.ott, ida.observations.wavelengths, ida.observations.num_publications FROM ida.observations WHERE (ida.observations.display = 1) AND ( (ida.observations.instrument_mode = 'CAM01') OR (ida.observations.instrument_mode = 'CAM03') OR (ida.observations.instrument_mode = 'CAM04') OR (ida.observations.instrument_mode = 'SWS01') OR (ida.observations.instrument_mode = 'SWS02') OR (ida.observations.instrument_mode = 'SWS06') OR (ida.observations.instrument_mode = 'SWS07') OR (ida.observations.instrument_mode = 'LWS01') OR (ida.observations.instrument_mode = 'LWS02') OR (ida.observations.instrument_mode = 'LWS03') OR (ida.observations.instrument_mode = 'LWS04') OR (ida.observations.instrument_mode = 'PHT03') OR (ida.observations.instrument_mode = 'PHT04') OR (ida.observations.instrument_mode = 'PHT05') OR (ida.observations.instrument_mode = 'PHT17') OR (ida.observations.instrument_mode = 'PHT18') OR (ida.observations.instrument_mode = 'PHT19') OR (ida.observations.instrument_mode = 'PHT22') OR (ida.observations.instrument_mode = 'PHT25') OR (ida.observations.instrument_mode = 'PHT32') OR (ida.observations.instrument_mode = 'PHT37') OR (ida.observations.instrument_mode = 'PHT38') OR (ida.observations.instrument_mode = 'PHT39') OR (ida.observations.instrument_mode = 'PHT40') ) ORDER BY ida.observations.obsno_char ASC

doQuery

ADQL

VOTABLE_PLAIN

RUN

SELECT DISTINCT ( ida.publications.code ) ,ida.publications.code, ida.publications.title, ida.publications.authors, ida.publications.num_observations, ida.publications.journal, ida.publications.year FROM ida.publications INNER JOIN ida.publications_observations ON ida.publications.code=ida.publications_observations.code INNER JOIN ida.observations ON ida.publications_observations.obsno=ida.observations.obsno WHERE ( (ida.observations.instrument_mode = 'CAM01') OR (ida.observations.instrument_mode = 'CAM03') OR (ida.observations.instrument_mode = 'CAM04') OR (ida.observations.instrument_mode = 'SWS01') OR (ida.observations.instrument_mode = 'SWS02') OR (ida.observations.instrument_mode = 'SWS06') OR (ida.observations.instrument_mode = 'SWS07') OR (ida.observations.instrument_mode = 'LWS01') OR (ida.observations.instrument_mode = 'LWS02') OR (ida.observations.instrument_mode = 'LWS03') OR (ida.observations.instrument_mode = 'LWS04') OR (ida.observations.instrument_mode = 'PHT03') OR (ida.observations.instrument_mode = 'PHT04') OR (ida.observations.instrument_mode = 'PHT05') OR (ida.observations.instrument_mode = 'PHT17') OR (ida.observations.instrument_mode = 'PHT18') OR (ida.observations.instrument_mode = 'PHT19') OR (ida.observations.instrument_mode = 'PHT22') OR (ida.observations.instrument_mode = 'PHT25') OR (ida.observations.instrument_mode = 'PHT32') OR (ida.observations.instrument_mode = 'PHT37') OR (ida.observations.instrument_mode = 'PHT38') OR (ida.observations.instrument_mode = 'PHT39') OR (ida.observations.instrument_mode = 'PHT40') ) ORDER BY ida.publications.code DESC