SELECT d.targetid, d.tileid, d.tilelocid, d.z_rr, d.zerr, d.chi2, d.spectype,
d.deltachi2, d.zwarn_mtl, d.z_qn, d.z_qn_conf, d.is_qso_qn, d.ra, d.dec,
d.dchisq, d.ebv, d.flux_g, d.flux_r, d.flux_z, d.flux_ivar_g, d.flux_ivar_r,
d.flux_ivar_z, d.flux_w1, d.flux_w2, d.flux_ivar_w1, d.flux_ivar_w2,
d.mw_transmission_w1, d.mw_transmission_w2, d.maskbits, d.photsys, d.desi_target,
d.bgs_target, d.z_not4clus, g.source_id, g.ra, g.dec, g.l, g.b,
g.phot_bp_mean_mag, g.phot_g_mean_mag, g.phot_rp_mean_mag, g.in_qso_candidates,
z.id, z.targetid, x.id1, x.id2, x.distance
FROM mydb://desi_quasars AS d
INNER JOIN desi_dr1.zpix AS z
ON z.targetid = d.targetid
INNER JOIN desi_dr1.x1p5__zpix__gaia_dr3__gaia_source AS x
ON x.id1 = z.id
INNER JOIN gaia_dr3.gaia_source AS g
ON x.id2 = g.source_id
WHERE x.distance < 1
AND g.phot_bp_mean_mag > 0
using python.