Select top 10 * From (select top 10 ID,Province,Name,Price,AddTime,SupplyType,NativeProperty,'huiji' as asd from GolfNative Where NativeProperty='二手' And IsDel=0 and Province in ('广东') Order By AddTime Desc union select top 10 ID,City as Province,Name,Price,AddTime,SupplyType,CardProperty as NativeProperty,'qiuka' as asd from GolfCard Where IsDel=0 and CardProperty='二手' and City in ('广东') Order By AddTime Desc) as tt Order By tt.AddTime Desc Select top 10 * From (select top 10 ID,Province,Name,Price,AddTime,SupplyType,NativeProperty,'huiji' as asd from GolfNative Where NativeProperty='二手' And IsDel=0 and Province in ('广东') Order By AddTime Desc union select top 10 ID,City as Province,Name,Price,AddTime,SupplyType,CardProperty as NativeProperty,'qiuka' as asd from GolfCard Where IsDel=0 and CardProperty='二手' and City in ('广东') Order By AddTime Desc) as tt Order By tt.AddTime Desc Select top 10 * From (select top 10 ID,Province,Name,Price,AddTime,SupplyType,NativeProperty,'huiji' as asd from GolfNative Where NativeProperty='二手' And IsDel=0 and Province in ('广东') Order By AddTime Desc union select top 10 ID,City as Province,Name,Price,AddTime,SupplyType,CardProperty as NativeProperty,'qiuka' as asd from GolfCard Where IsDel=0 and CardProperty='二手' and City in ('广东') Order By AddTime Desc) as tt Order By tt.AddTime Desc Select top 10 * From (select top 10 ID,Province,Name,Price,AddTime,SupplyType,NativeProperty,'huiji' as asd from GolfNative Where NativeProperty='二手' And IsDel=0 and Province in ('广东') Order By AddTime Desc union select top 10 ID,City as Province,Name,Price,AddTime,SupplyType,CardProperty as NativeProperty,'qiuka' as asd from GolfCard Where IsDel=0 and CardProperty='二手' and City in ('广东') Order By AddTime Desc) as tt Order By tt.AddTime Desc Select top 10 * From (select top 10 ID,Province,Name,Price,AddTime,SupplyType,NativeProperty,'huiji' as asd from GolfNative Where NativeProperty='二手' And IsDel=0 and Province in ('广东') Order By AddTime Desc union select top 10 ID,City as Province,Name,Price,AddTime,SupplyType,CardProperty as NativeProperty,'qiuka' as asd from GolfCard Where IsDel=0 and CardProperty='二手' and City in ('广东') Order By AddTime Desc) as tt Order By tt.AddTime Desc Select top 10 * From (select top 10 ID,Province,Name,Price,AddTime,SupplyType,NativeProperty,'huiji' as asd from GolfNative Where NativeProperty='二手' And IsDel=0 and Province in ('广东') Order By AddTime Desc union select top 10 ID,City as Province,Name,Price,AddTime,SupplyType,CardProperty as NativeProperty,'qiuka' as asd from GolfCard Where IsDel=0 and CardProperty='二手' and City in ('广东') Order By AddTime Desc) as tt Order By tt.AddTime Desc Select top 10 * From (select top 10 ID,Province,Name,Price,AddTime,SupplyType,NativeProperty,'huiji' as asd from GolfNative Where NativeProperty='二手' And IsDel=0 and Province in ('广东') Order By AddTime Desc union select top 10 ID,City as Province,Name,Price,AddTime,SupplyType,CardProperty as NativeProperty,'qiuka' as asd from GolfCard Where IsDel=0 and CardProperty='二手' and City in ('广东') Order By AddTime Desc) as tt Order By tt.AddTime Desc Select top 10 * From (select top 10 ID,Province,Name,Price,AddTime,SupplyType,NativeProperty,'huiji' as asd from GolfNative Where NativeProperty='二手' And IsDel=0 and Province in ('广东') Order By AddTime Desc union select top 10 ID,City as Province,Name,Price,AddTime,SupplyType,CardProperty as NativeProperty,'qiuka' as asd from GolfCard Where IsDel=0 and CardProperty='二手' and City in ('广东') Order By AddTime Desc) as tt Order By tt.AddTime Desc Select top 10 * From (select top 10 ID,Province,Name,Price,AddTime,SupplyType,NativeProperty,'huiji' as asd from GolfNative Where NativeProperty='二手' And IsDel=0 and Province in ('广东') Order By AddTime Desc union select top 10 ID,City as Province,Name,Price,AddTime,SupplyType,CardProperty as NativeProperty,'qiuka' as asd from GolfCard Where IsDel=0 and CardProperty='二手' and City in ('广东') Order By AddTime Desc) as tt Order By tt.AddTime Desc Select top 10 * From (select top 10 ID,Province,Name,Price,AddTime,SupplyType,NativeProperty,'huiji' as asd from GolfNative Where NativeProperty='二手' And IsDel=0 and Province in ('广东') Order By AddTime Desc union select top 10 ID,City as Province,Name,Price,AddTime,SupplyType,CardProperty as NativeProperty,'qiuka' as asd from GolfCard Where IsDel=0 and CardProperty='二手' and City in ('广东') Order By AddTime Desc) as tt Order By tt.AddTime Desc