MySql Not accessing parent in subquery?

Move the check of t1. Media_id=m. Id to the where clause and it works (for me, anyway).

Move the check of t1. Media_id=m. Id to the where clause and it works (for me, anyway): select m.Id from media m join tag_name as n0 on n0.

Title = @a0 join media_tag as t0 on t0. Media_id=m.Id AND t0. Tag_id = n0.

Id where 1 AND not (select 1 from tag_name as n1 join media_tag as t1 on t1. Tag_id = n1. Id where t1.

Media_id=m.Id AND n1. Title = @a1) order by m. Id desc.

That solved it! I could swear syntax like this is valid in sqlite. If so then I am liking how relaxed/easy sqlite is and hope I don't run into too many problems with mysql – acidzombie24 Sep 27 '10 at 6:42.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.