SELECT * FROM `team_statistics`
left join team_statistics_details ON team_statistics_details.team_statistic_id=team_statistics.id
where team_statistics_details.type_id IN (86,81,80,83,52,88,34,49,84,87,136,137,138,142,143,144,139,140,145,146)

and team_statistics.team_id=282 and team_statistics.season_id=23690;