Examples

DR1: Master catalogue

Get Master table of the DR1 galaxies

SELECT * FROM dr1.Master

DR1: get PPAK cubes filtered

Retrieve DR1 PPAK fits files for all the late type galaxies (morphological T-type greater than 0) at the redshift less than 0.030 and belonging to the voids 482 or 487

SELECT galaxy, file FROM dr1.PPAK_cubes
WHERE galaxy IN (
  SELECT galaxy FROM dr1.Master
  WHERE morphology > 0 
  AND redshift <= 0.030 
  AND void IN (482,487)
)

DR1: get a selection of PPAK Footprint and Moment0 images

Get DR1 PPAK Footprint and Moment0 images of the selected galaxies

SELECT galaxy, img_footprint AS Footprint_Image , img_moment AS Moment0_Image 
FROM dr1.PPAK_images
WHERE galaxy IN (52731,52732,52733,52734,52735)

DR1: Morphological data from galaxies of a given void

Get morphological data from galaxies from a given void. Customize: Change void id to the wanted. Wanted table can also be changed,instead of Morphology.

SELECT mor.* 
FROM dr1.Master m, dr1.Morpho mor
WHERE m.galaxy = mor.galaxy AND m.void = 439

DR2: get PPAK cubes, images and additional data columns of two galaxies

SELECT m.galaxy, m.ra, m.dec, m.redshift, m.M_star, c.file, i.img_footprint, i.img_moment 
FROM dr2.Master as m, dr2.PPAK_images as i, dr2.PPAK_cubes as c 
WHERE m.galaxy = i.galaxy AND m.galaxy = c.galaxy AND m.galaxy IN (34100,34101)