Select Top 10 J_ID, J_State, J_Subject, J_Kind1, J_Theme, J_Contents, J_KindCode, J_Addr1, J_Addr2, J_Addr3, J_Kind2, J_Meter, J_Area1, J_Profit, J_Price, J_Money, J_Keymoney, J_Rent, J_Premium, J_MCost, J_ProfitYesNo, J_PriceYesNo, J_premium, J_Floor, J_Floor_all, J_Picture, J_Pic1, J_Pic2, J_con, J_hit, b.M_level from BIZ_JUMPO_REAL a join BIZ_MEMBER b on b.m_member = 1 and b.m_id = a.j_con where J_View = 1 and b.m_regyn = 1 and b.M_Site_cumedia = 'cumedia' order by newid()
-