SELECT g.ra, g.dec, g.parallax, g.parallax_error, g.phot_g_mean_mag, s.sdssdr9_oid, sv.g_mag, sv.g_mag_error, sv.i_mag, sv.i_mag_error FROM gaiadr1.gaia_source as g JOIN gaiadr1.sdss_dr9_best_neighbour as s ON g.source_id = s.source_id JOIN gaiadr1.sdssdr9_original_valid as sv ON s.sdssdr9_oid = sv.sdssdr9_oid WHERE g.ra > 120 and g.ra < 180 and g.dec > 0 and g.dec < 50 and g.parallax > 0 and g.parallax_error > 0 and g.parallax > (10.0*g.parallax_error) and g.phot_g_mean_flux > 20.0*g.phot_g_mean_flux_error