DD1 has SN & SEN as a result. We went to an OFSTED Outstanding school (which lots of our friends' children attend happily) and expected to fall in love with it. We were horrified. Talk of 'updating the school hall to look less like the outside of public toilets', etc., etc., with a cursory wave at the "SEN" rooms. DD1 wanting to play in a classroom, and the Head saying 'you can leave her there if she wants to', and then a dismissive "you stay with her & we'll carry on" to DH, when we explained that she can't be left unattended. We were left with no doubt in our minds that she was not wanted and would not thrive.
We then went to the local infant school, which locally has a mediocre reputation (seen as the school to go to if you can't get in at any of the other schools, IYSWIM). They were AMAZING. Took us around individually, talked to DD. Let her play in the classroom, giving her a buddy child and asking 2 teachers to supervise her & stressing that she should not be allowed to leave the classroom. Arranged a meeting with the SENCO the following week, and when DD screamed during it, the Deputy head left her classroom, came to find us, and offered to take DD1 down into her classroom for fruit and milk because it was snack time.