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?