SELECT nome, idade
FROM other_table
WHERE myid = `from`, myid = `to`(SELECT `from`, `to`, COUNT(*) AS num_clicks
FROM my_rank
WHERE my_rank_data >= NOW() - INTERVAL 1 DAY
GROUP BY `from`, `to`
ORDER BY num_clicks DESC LIMIT 20);