Untitled

SELECT date, product_id AS productId, quantity, sale_id AS saleId
    FROM sales_products 
    INNER JOIN sales 
    ON sales_products.sale_id = sales.id 
    ORDER BY sale_id ASC, product_id ASC`



SELECT date, product_id AS productId, quantity, sale_id AS saleId
    FROM sales_products
    INNER JOIN sales
    ON sales_products.sale_id = sales.id
    WHERE sale_id = ?