SELECT TOP 80000 gaia_source.designation,gaia_source.source_id,gaia_source.ra,gaia_source.dec,gaia_source.parallax,gaia_source.parallax_over_error,gaia_source.pmra,gaia_source.pmra_error,gaia_source.pmdec,gaia_source.pmdec_error,gaia_source.phot_g_mean_mag,gaia_source.bp_rp,gaia_source.radial_velocity,gaia_source.radial_velocity_error,'m54' AS target_id,283.763875 AS target_ra,-30.479861 AS target_dec,.0530 AS target_parallax,-2.7300 AS target_pm_ra,-1.3800 AS target_pm_dec,142.3000 AS target_radial_velocity,2000 AS epoch,
DISTANCE(POINT('ICRS' , gaiadr3.gaia_source.ra, gaiadr3.gaia_source.dec), 
POINT('ICRS',
				COORD1(EPOCH_PROP_POS(283.763875, -30.479861, .0530, -2.7300, -1.3800, 142.3000, 2000, 2016.0)),
				COORD2(EPOCH_PROP_POS(283.763875, -30.479861, .0530, -2.7300, -1.3800, 142.3000, 2000, 2016.0)))) AS "target_separation (deg)"
FROM gaiadr3.gaia_source 
WHERE 
CONTAINS(
	POINT('ICRS',gaiadr3.gaia_source.ra,gaiadr3.gaia_source.dec),
	CIRCLE(
		'ICRS',
		COORD1(EPOCH_PROP_POS(283.763875,-30.479861,.0530,-2.7300,-1.3800,142.3000,2000,2016.0)),
		COORD2(EPOCH_PROP_POS(283.763875,-30.479861,.0530,-2.7300,-1.3800,142.3000,2000,2016.0)),
		5.0)
)=1  AND  (gaiadr3.gaia_source.phot_g_mean_mag<=18) 
   and (gaiadr3.gaia_source.pmra > -2.7) and (gaiadr3.gaia_source.pmra < -2.3) and (gaiadr3.gaia_source.pmdec > -1.5) and (gaiadr3.gaia_source.pmdec < -1.1)