SELECT t.id, t.league_id, c.urlpath
FROM team_list t
INNER JOIN category c ON t.category = c.old_name
WHERE t.id IN (6240,3984,23821,6300,6240,23822,6238,23821,6300,5344,4002,5486,5324,5492,5898,6076,6268,6186,6238,6192,6212,5494,6228,6240,6238,6186,23821,6008,26867,23467,5324,5344,23821,5898,5526,6008,5492,6336,6278,6192,23821)SELECT t.id, t.league_id, c.urlpath
FROM team_list t
INNER JOIN category c ON t.category = c.old_name
WHERE t.id IN ()