SELECT * FROM (SELECT A.*, rownum as row_number FROM ((
SELECT
table_profile.usr_id as table_id, table_firm.firm_name,
building.building_id, building.bldg_type_id, hood.hood_name, building.name, building.street, building.address, usr.first_name, usr.last_name,
to_char(table_building_reviews.date_added, 'MM-DD-YYYY') as date_added, table_building_reviews.about_building as bedrooms, table_building_reviews.table_id as price, 'BR' as type
FROM
table_building_reviews,
table_profile,
table_firm,
building,
usr,
hood
WHERE
building.hood_id = hood.hood_id AND
table_building_reviews.building_id = building.building_id AND
table_building_reviews.table_id = table_profile.usr_id AND
table_profile.table_id = table_firm.table_id AND
usr.usr_id = table_profile.usr_id AND (building.hood_id = '1' OR building.hood_id = '8' OR building.hood_id = '36' OR building.hood_id = '2' OR building.hood_id = '4' OR building.hood_id = '5' OR building.hood_id = '6' OR building.hood_id = '3' OR building.hood_id = '34' OR building.hood_id = '7' OR building.hood_id = '9' OR building.hood_id = '10' OR building.hood_id = '11' OR building.hood_id = '35' OR building.hood_id = '38' OR building.hood_id = '37' OR building.hood_id = '13' OR building.hood_id = '41' OR building.hood_id = '42' OR building.hood_id = '14' OR building.hood_id = '15' OR building.hood_id = '16' OR building.hood_id = '17' OR building.hood_id = '12' OR building.hood_id = '18' OR building.hood_id = '19' OR building.hood_id = '20' OR building.hood_id = '21' OR building.hood_id = '22' OR building.hood_id = '25' OR building.hood_id = '27' OR building.hood_id = '39' OR building.hood_id = '23' OR building.hood_id = '24' OR building.hood_id = '28' OR building.hood_id = '29' OR building.hood_id = '31' OR building.hood_id = '30' OR building.hood_id = '32' OR building.hood_id = '40' OR building.hood_id = '33' OR building.hood_id = '26') AND (building.bldg_type_id = '2' OR building.bldg_type_id = '3' OR building.bldg_type_id = '7')
) UNION ALL (
SELECT
table_profile.usr_id as table_id, table_firm.firm_name,
building.building_id, building.bldg_type_id, hood.hood_name, building.name, building.street, building.address, usr.first_name, usr.last_name,
to_char(table_apartment_reviews.date_added, 'MM-DD-YYYY') as date_added, bedroom.bedroom as bedrooms, table_apartment_reviews.price as price, 'AR' as type
FROM
table_apartment_reviews,
table_profile,
table_firm,
building,
bedroom,
usr,
hood
WHERE
building.hood_id = hood.hood_id AND
table_apartment_reviews.building_id = building.building_id AND
table_apartment_reviews.table_id = table_profile.usr_id AND
table_profile.table_id = table_firm.table_id AND
usr.usr_id = table_profile.usr_id AND
table_apartment_reviews.bedroom_id = bedroom.bedroom_id AND (building.hood_id = '1' OR building.hood_id = '8' OR building.hood_id = '36' OR building.hood_id = '2' OR building.hood_id = '4' OR building.hood_id = '5' OR building.hood_id = '6' OR building.hood_id = '3' OR building.hood_id = '34' OR building.hood_id = '7' OR building.hood_id = '9' OR building.hood_id = '10' OR building.hood_id = '11' OR building.hood_id = '35' OR building.hood_id = '38' OR building.hood_id = '37' OR building.hood_id = '13' OR building.hood_id = '41' OR building.hood_id = '42' OR building.hood_id = '14' OR building.hood_id = '15' OR building.hood_id = '16' OR building.hood_id = '17' OR building.hood_id = '12' OR building.hood_id = '18' OR building.hood_id = '19' OR building.hood_id = '20' OR building.hood_id = '21' OR building.hood_id = '22' OR building.hood_id = '25' OR building.hood_id = '27' OR building.hood_id = '39' OR building.hood_id = '23' OR building.hood_id = '24' OR building.hood_id = '28' OR building.hood_id = '29' OR building.hood_id = '31' OR building.hood_id = '30' OR building.hood_id = '32' OR building.hood_id = '40' OR building.hood_id = '33' OR building.hood_id = '26') AND (building.bldg_type_id = '2' OR building.bldg_type_id = '3' OR building.bldg_type_id = '7')
) UNION ALL (
SELECT
table_profile.usr_id as table_id, table_firm.firm_name,
building.building_id, building.bldg_type_id, hood.hood_name, building.name, building.street, building.address, usr.first_name, usr.last_name,
to_char(table_deals_desc.date_closed, 'MM-DD-YYYY') as date_added, bedroom.bedroom as bedrooms, table_deals_desc.sales_price as price, 'BD' as type
FROM
table_deals_desc,
table_profile,
table_firm,
building,
bedroom,
usr,
hood
WHERE
building.hood_id = hood.hood_id AND
table_deals_desc.building_id = building.building_id AND
table_deals_desc.table_id = table_profile.usr_id AND
table_profile.table_id = table_firm.table_id AND
usr.usr_id = table_profile.usr_id AND
table_deals_desc.bedroom_id = bedroom.bedroom_id AND (building.hood_id = '1' OR building.hood_id = '8' OR building.hood_id = '36' OR building.hood_id = '2' OR building.hood_id = '4' OR building.hood_id = '5' OR building.hood_id = '6' OR building.hood_id = '3' OR building.hood_id = '34' OR building.hood_id = '7' OR building.hood_id = '9' OR building.hood_id = '10' OR building.hood_id = '11' OR building.hood_id = '35' OR building.hood_id = '38' OR building.hood_id = '37' OR building.hood_id = '13' OR building.hood_id = '41' OR building.hood_id = '42' OR building.hood_id = '14' OR building.hood_id = '15' OR building.hood_id = '16' OR building.hood_id = '17' OR building.hood_id = '12' OR building.hood_id = '18' OR building.hood_id = '19' OR building.hood_id = '20' OR building.hood_id = '21' OR building.hood_id = '22' OR building.hood_id = '25' OR building.hood_id = '27' OR building.hood_id = '39' OR building.hood_id = '23' OR building.hood_id = '24' OR building.hood_id = '28' OR building.hood_id = '29' OR building.hood_id = '31' OR building.hood_id = '30' OR building.hood_id = '32' OR building.hood_id = '40' OR building.hood_id = '33' OR building.hood_id = '26') AND (building.bldg_type_id = '2' OR building.bldg_type_id = '3' OR building.bldg_type_id = '7')
) UNION ALL (
SELECT
table_profile.usr_id as table_id, table_firm.firm_name,
building.building_id, building.bldg_type_id, hood.hood_name, building.name, building.street, building.address, usr.first_name, usr.last_name,
to_char(usr_deals.accepted, 'MM-DD-YYYY') as date_added, NULL as bedrooms, usr_deals.price as price, 'CD' as type
FROM
usr_deals,
table_profile,
table_firm,
building,
usr,
hood
WHERE
building.hood_id = hood.hood_id AND
usr_deals.building_id = building.building_id AND
usr_deals.agent_id = table_profile.usr_id AND
table_profile.table_id = table_firm.table_id AND
usr.usr_id = table_profile.usr_id AND (building.hood_id = '1' OR building.hood_id = '8' OR building.hood_id = '36' OR building.hood_id = '2' OR building.hood_id = '4' OR building.hood_id = '5' OR building.hood_id = '6' OR building.hood_id = '3' OR building.hood_id = '34' OR building.hood_id = '7' OR building.hood_id = '9' OR building.hood_id = '10' OR building.hood_id = '11' OR building.hood_id = '35' OR building.hood_id = '38' OR building.hood_id = '37' OR building.hood_id = '13' OR building.hood_id = '41' OR building.hood_id = '42' OR building.hood_id = '14' OR building.hood_id = '15' OR building.hood_id = '16' OR building.hood_id = '17' OR building.hood_id = '12' OR building.hood_id = '18' OR building.hood_id = '19' OR building.hood_id = '20' OR building.hood_id = '21' OR building.hood_id = '22' OR building.hood_id = '25' OR building.hood_id = '27' OR building.hood_id = '39' OR building.hood_id = '23' OR building.hood_id = '24' OR building.hood_id = '28' OR building.hood_id = '29' OR building.hood_id = '31' OR building.hood_id = '30' OR building.hood_id = '32' OR building.hood_id = '40' OR building.hood_id = '33' OR building.hood_id = '26') AND (building.bldg_type_id = '2' OR building.bldg_type_id = '3' OR building.bldg_type_id = '7')
)) A ORDER BY A.DATE_ADDED DESC ) WHERE row_number >= 100 AND row_number <= 200