Дмитрий Телепнев

SELECT product.*, properties.title, values.value
FROM products
JOIN property_values values ON values.product_id = product.id
JOIN properties ON properties.id = values.property_id
WHERE values.property_id IN (......)

WITH peoples AS (
    SELECT * FROM people 
    WHERE people.name LIKE $(regex) 
    LIMIT $(limit)
)
SELECT f.* 
FROM user_friends f
JOIN peoples p.id = f.friend_id
WHERE user_friends.user_id = $(user_id)