News for hackers. Stuff that matters.
Re:The girl with the ANSI tattoo by sp332 on Thursday May 31, 2012 @10:14AM (#4048101)
Shocked moviegoers will have been left wondering why a genius-level hacker would outer-join to the Victims and Keywords tables only to use literal-text filter predicates that defeat the outer joins

Any excuse for this? :)

Re:The girl with the ANSI tattoo by HarrisonFisk on Thursday May 31, 2012 @05:09PM (#4050376)
The MySQL optimizer will actually notice and remove the outer join aspect automatically. So I have often done this out of pure laziness if I start with an outer join, but really end up needing an inner join.
Re:The girl with the ANSI tattoo by huggyface on Thursday May 31, 2012 @10:31AM (#4048172)
Realistically that they started the query with keywords optional, then moved to them being required (which, it should be noted, a good query planner would effective make an inner join). On the scale of evils of SQL, it lies somewhere around "friendly benign".