Okay, there are two things on your mind. One is the subjunctive and the other is the past tense of the first verb.
Whatever you read about "wish I was here" vs. "wish I were here" is probably fine to apply to this slightly different case. It's not really very different.
My answer to the was/were question is that strictly speaking, "were" is better than "was"; but I'm in the minority. Not many people use "were."
Here's a context for the "wished" version:
As a young man, I spent several years undecided about my life's work. I earned my bread as a bored minion in a legal firm. My work left me plenty of time for daydreaming. Some days, I wished I were a painter. Others, I coveted my boss's corner office with a window, and imagined myself working my way up the corporate ladder and being offered the operations manager position.
"Wished" + the subjunctive work here because we're describing wishful, wistful, unrealistic feelings experienced in the past.