SELECT * FROM ((
SELECT
broker_profile.usr_id as broker_id, brokerage_firm.firm_name,
building.building_id, building.bldg_type_id, building.hood_id, hood.hood_name, building.name, building.street, building.address, usr.first_name, usr.last_name,
broker_building_reviews.date_added, broker_building_reviews.about_building as bedrooms, broker_building_reviews.broker_id as price, 'BR' as type
FROM broker_building_reviews,broker_profile,brokerage_firm,building,usr,hood
WHERE
building.hood_id = hood.hood_id AND
broker_building_reviews.building_id = building.building_id AND
broker_building_reviews.broker_id = broker_profile.usr_id AND
broker_profile.brokerage_id = brokerage_firm.brokerage_id AND
usr.usr_id = broker_profile.usr_id
)
UNION ALL
(
SELECT
broker_profile.usr_id as broker_id, brokerage_firm.firm_name,
building.building_id, building.bldg_type_id, building.hood_id, hood.hood_name, building.name, building.street, building.address, usr.first_name, usr.last_name,
broker_apartment_reviews.date_added, bedroom.bedroom as bedrooms, broker_apartment_reviews.price as price, 'AR' as type
FROM broker_apartment_reviews,broker_profile,brokerage_firm,building,bedroom,usr,hood
WHERE
building.hood_id = hood.hood_id AND
broker_apartment_reviews.building_id = building.building_id AND
broker_apartment_reviews.broker_id = broker_profile.usr_id AND
broker_profile.brokerage_id = brokerage_firm.brokerage_id AND
usr.usr_id = broker_profile.usr_id AND
broker_apartment_reviews.bedroom_id = bedroom.bedroom_id
)
UNION ALL
(
SELECT
broker_profile.usr_id as broker_id, brokerage_firm.firm_name,
building.building_id, building.bldg_type_id, building.hood_id, hood.hood_name, building.name, building.street, building.address, usr.first_name, usr.last_name,
broker_deals_desc.date_closed as date_added, bedroom.bedroom as bedrooms, broker_deals_desc.sales_price as price, 'BD' as type
FROM
broker_deals_desc, broker_profile, brokerage_firm, building, bedroom, usr, hood
WHERE
building.hood_id = hood.hood_id AND
broker_deals_desc.building_id = building.building_id AND
broker_deals_desc.broker_id = broker_profile.usr_id AND
broker_profile.brokerage_id = brokerage_firm.brokerage_id AND
usr.usr_id = broker_profile.usr_id AND
broker_deals_desc.bedroom_id = bedroom.bedroom_id
)
UNION ALL
(
SELECT
broker_profile.usr_id as broker_id, brokerage_firm.firm_name,
building.building_id, building.bldg_type_id, building.hood_id, hood.hood_name, building.name, building.street, building.address, usr.first_name, usr.last_name,
usr_deals.accepted as date_added, NULL as bedrooms, usr_deals.price as price, 'CD' as type
FROM
usr_deals, broker_profile, brokerage_firm, building, usr, hood
WHERE
building.hood_id = hood.hood_id AND
usr_deals.building_id = building.building_id AND
usr_deals.agent_id = broker_profile.usr_id AND
broker_profile.brokerage_id = brokerage_firm.brokerage_id AND
usr.usr_id = broker_profile.usr_id
)
) A