A thought: Free-DC Triple Crown

[gopher_yarrowzoo]

I'm seriously doubting that anyone can achieve this. No-one has right now.




mysql> select a.cpid from boinc_milestone_makers a where (a.mtype = 'boks' and a.projrank <=10) and exists (select 1 from boinc_milestone_makers b where b.mtype = 'teraboks' and b.projrank <=10 and a.cpid = b.cpid) and exists (select 1 from boinc_milestone_makers c where c.mtype = 'trigggls' and c.projrank <=10 and a.cpid = c.cpid);
Empty set (0.00 sec)

If we expand it out a little to top10 in Boks but top100 in the other 2 then we get results.


mysql> select a.cpid from boinc_milestone_makers a where (a.mtype = 'boks' and a.projrank <=10) and exists (select 1 from boinc_milestone_makers b where b.mtype = 'teraboks' and b.projrank <=100 and a.cpid = b.cpid) and exists (select 1 from boinc_milestone_makers c where c.mtype = 'trigggls' and c.projrank <=100 and a.cpid = c.cpid);
+----------------------------------+
| cpid |
+----------------------------------+
| 3a045e428e45f087f7cc832bdb4791ff |
| 4b0a4762e72ff7dfbc6384b64aba4722 |
+----------------------------------+
2 rows in set (0.00 sec)


I know a Triple Crown should be difficult, but not impossible right?

It's meant to be HARD to get... although we could find out the rules they use in the races and modify them
Take a hard one to begin with, then add an easier one and then let everyone (even those who don't got the first two to race the third)