SELECT
u1.*,u2.meta
FROM
rets_innovia_retscloud.residential u1
LEFT JOIN
rets_innovia_retscloud.rets_mls_titles u2 ON u1.field_MLSNumber=u2.mls
WHERE u1.field_ListOfficeMLSID = 'NCM9520' AND
( field_Status LIKE 'Active' AND Class NOT LIKE '%Off Market%' )
ORDER BY u1.field_ListPrice desc