mysql return duplicate records based on same key used in IN CLAUSE
===

I have the following query

    SELECT P.PRICE, P.PRODUCT_ID FROM PRODUCT P WHERE P.PRODUCT_ID IN (41,41)

I need it to return the product record twice due to limitations with the application code. 

I am not too familiar with SQL so really stuck, I don't want to run single queries for each product