6dFGS Database - SQL Query

Examples of SQL query box text are given here

Please select your desired options, enter your SQL query (replacing the example query) and then click "Execute SQL".

Data Format:	HTML table summary (select number of rows returned below)     CSV File (downloadable, all rows written to CSV file, with HTML table summary on-screen)
CSV Compression:	(none) GZIP
Other Options:	NROWS, Maximum no. of rows to return in HTML table summary (limited to 10,000)     Output RA & DEC as decimal degrees (default is sexagesimal)
TAR saveset:	no yes if yes enter email address below and ensure format=CSV and that targetname is a selected parameter
Email:	only required if requesting a TAR file
SQL Query:	SELECT target.TARGETNAME, target.BMAG, target.RMAG, target.BMAG-target.RMAG AS colour, spectra.Z_helio, twomass.K FROM target INNER JOIN spectra ON target.TARGETID = spectra.TARGETID INNER JOIN twomass ON target.TARGETID = twomass.TARGETID WHERE (target.BMAG - target.RMAG > 1.2) AND (spectra.QUALITY >= 3) AND (twomass.K > 12)