For your information, using all caps in a sentence is considered to be shouting and rude.
It is, as pointed out to you, caused by item #6.
If the text id's happen to be the auto id numbers then I'd consider changing the data type to long and just joining the tables. Otherwise I'd fix the table design because it's incorrect. There is no way you're going to update any table when the query contains a subquery.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.