Task: Text to Code
Input (English): SQL: SELECT DISTINCT product_id FROM Order_Items WHERE order_id BETWEEN "1976-01-01" AND "1975-01-01"
Feedback: Use date order placed in place of order id .
Output (English): SELECT DISTINCT T2.product_id FROM orders AS T1 JOIN order_items AS T2 ON T1.order_id = T2.order_id WHERE T1.date_order_placed >= "1975-01-01" AND T1.date_order_placed <= "1976-01-01"