SELECT top 100000
   p.objid, p.ra, p.dec, p.g, p.Err_g,p.r, p.Err_r, p.i, p.Err_i, p.z, p.Err_z , p.psfMag_g, 
   p.psfMagErr_g,p.psfMag_r, p.psfMagErr_r, p.psfMag_i, p.psfMagErr_i, p.psfMag_z, 
   p.psfMagErr_z, p.extinction_i,p.b as Galactic_latitude , p.l as Galactic_longitude, 
   w.w1mag AS w1, w.w1sigmag as w1_sig, w.w2mag AS w2, w.w2sigmag as w2_sig, 
   s.specobjid , s.z AS zs, s.class, s.zErr
FROM WISE_xmatch AS xm
JOIN photoObjAll AS p ON xm.sdss_objid = p.objid
JOIN WISE_allsky AS w ON xm.wise_cntr = w.cntr
JOIN SpecObjAll AS s ON s.bestobjid = p.objid
WHERE
  s.z >0
AND p.b>22
AND s.class = 'QSO'