Select a stock quantity for 2 distinct shops

SELECT product.id AS product_id,
stock1.quantity AS quantity1,
stock2.quantity AS quantity2
FROM product
LEFT JOIN stock stock1 ON stock1.product_id = product.id AND stock1.shop_id = 1
LEFT JOIN stock stock2 ON stock2.product_id = product.id AND stock2.shop_id = 2