Use secondry index with (join in the same bucket)!

SQL++
,
11

Can you post the full EXPLAIN. @vsr1 was suggesting that it should be a covering index. We need to confirm that in the EXPLAIN.