SELECT
    *
FROM
    classroom
WHERE
    hoikuen_id IN(%s)
AND delete_flag != 1
;