df-sql-where.py

propertyTypeHouse = 'House'

dfListingHouseAvailable = spark.sql(f"""
WITH 

LISTING_HOUSE AS (
    SELECT id as listing_id, listing_url, name
    FROM LISTING_META
    WHERE property_type = '{propertyTypeHouse}'
)

SELECT 
    LISTING_CALENDAR.listing_id, 
    listing_url, 
    name as listing_name,
    date,
    available,
    price
    
FROM LISTING_CALENDAR
INNER JOIN LISTING_HOUSE
    ON LISTING_CALENDAR.listing_id = LISTING_HOUSE.listing_id
WHERE LISTING_CALENDAR.available = 't'
""")