SELECT location.displayname AS Location, cheese.displayname AS Cheese, trap.attraction_bonus AS "Trap AB", base.attraction_bonus AS "Base AB", trinket.attraction_bonus AS "Charm AB", COUNT( 1 ) AS Hunts, fta AS "Is FTA" FROM `huntrecord_lite` hr
INNER JOIN trap ON trap.id = hr.trap_id
INNER JOIN base ON base.id = hr.base_id
INNER JOIN trinket ON trinket.id = hr.trinket_id
INNER JOIN cheese ON cheese.id = hr.cheese_id
INNER JOIN location ON location.id = hr.location_id
WHERE hr.location_id IN (1,3,9,10,11,12,13,14,20,21,28,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,51,52,53,64,68,69,70,75,111,114,273,280,285,286,288,295,296,297,298,299) AND hr.cheese_id IN (3,4,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34) GROUP BY trap.attraction_bonus, base.attraction_bonus, trinket.attraction_bonus, hr.fta, hr.cheese_id, location.displayname ORDER BY location.displayname