SELECT t1.product FROM product AS t1 JOIN store_product AS t2 ON t1.product_id  =  t2.product_id JOIN store AS t3 ON t2.store_id  =  t3.store_id WHERE t3.store_name  =  "Miramichi"
What products are available at store named "Miramichi"?
SELECT t1.product FROM product AS t1 JOIN store_product AS t2 ON t1.product_id = t2.product_id JOIN store AS t3 ON t2.store_id = t3.store_id WHERE t3.store_name = `` Miramichi ''
select t1 . product from product as t1 join store_product as t2 on t1 . product_id = t2 . product_id join store as t3 on t2 . store_id = t3 . store_id where t3 . store_name = value
What products are available at store named `` Miramichi '' ?