Which one is correct and why?"where are the chandeliers made in? or where is the chandeliers made in?"

Neither. The correct sentence should read: Where are the chandeliers made? Adding the word in is incorrect, a dangling particple, I believe.