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"
Give me a list of distinct product ids from orders placed between 1975-01-01 and 1976-01-01?
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 ''
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 > = value and t1 . date_order_placed < = value
Give me a list of distinct product ids from orders placed between 1975-01-01 and 1976-01-01 ?