Intersect

intersect.sql

-- this seems slow

SELECT listing_id FROM tags WHERE name = 'game_hon'
INTERSECT
SELECT listing_id FROM tags WHERE name = 'west'
INTERSECT
SELECT listing_id FROM tags WHERE name = 'ap'
INTERSECT
(
    -- Is there a more efficient way to store this?
    SELECT listing_id FROM range_min WHERE name = 'mmr' AND value >= ${min} AND value <= ${max}
    UNION
    SELECT listing_id FROM range_max WHERE name = 'mmr' AND value >= ${min} AND value <= ${max}
)

intersect2.sql

SELECT listing_id
FROM tag a
INNER JOIN tag b USING (listing_id)
WHERE a.name = 'beer' AND b.name = 'airconditioning'