The Red Rose Cafe is a Dutch song written by Pierre Kartner, also known as Vader (Father) Abraham. He also wrote the Smurf song.

http://andrerieufans.com/music_achieve/the_red_rose_cafe.htm

You can find the words in multiple languages on http://www.andrerieufans.com

The first link points directly to the page.

If you have any other translations of the song, please feel free to send them to me.

Kindest Wishes for All

Sally@AndreRieuFans.com