What steps will reproduce the problem? 1. Go to Card Search 2. Search for "Serra Angel" 3. Go to the 4E version 4. Hit Menu -> Legality

or:

1. Do a quick search for "Serra Angel" (which takes you to the U version)

What is the expected output? What do you see instead? It says that it is banned in Standard, when it should read Legal. The M12 version of Serra Angel shows the correct legality.

Fundamentally fixed in r136. It passes the standards set above, but the new lookup is slower than the old one, and still needs to be moved off the UI thread

It is quite slow now, I can see, even on my phone. How is it doing the search, SQL-wise? Perhaps there's some way that we can optimize things?

Alex optimized the crap out of this query in R138. It'll be moved off the UI thread in R139 for maximum speed.

This looks pretty close to me. I notice that for something like Serra Angel (4E), it shows that it is Banned in block. Is that because non of the core set cards are in a Block?

Perhaps core set cards should have Block set to N/A or something?

I'm going to change the title of the ticket and set it back to Accepted, until that is fixed. The original issue, though, looks great. That is some sweet SQL!

That is expected behavior.