Select top 16 * from (SELECT [Uid],[sourceid],[postcode],[latitude],[longitude],[propertyType],[beds],[displayAddress],[current_price],[current_status],[sale_or_rental],[District] FROM [DATA_EXPORT].[dbo].[RM_REPORT_TODAY] where sale_or_rental=1 union all SELECT [Uid],[sourceid],[postcode],[latitude],[longitude],[property_type],[beds],[displayAddress],[price] as current_price,[listing_status] as current_status ,[sale_or_rental],[District] FROM [DATA_EXPORT].[dbo].[Z_REPORT_TODAY] where sale_or_rental=1) t1 Order By NewID()
CM7 9BJ - 395,000
- Bungalows
- Right Move
B5 6AF - 150,000
- Houses
- Right Move
FY4 2LW - 200,000
- semi_detached
- Zoopla
PE22 0EX - 389,000
- detached_bungalow
- Zoopla
SO41 0LH - 49,000
- Mobile / Park homes
- Right Move
N1 9RT - 40,000
- Garage / Parking
- Right Move