WHERE clause null? don't understand
select t1.* from mytable t1
    left join mytable t2
    on t1.parentid = t2.parentid and t1.rating < t2.rating
    join mytable parents
    on parents.id = t1.parentid
    where t2.rating is null AND parents.name like '%mike%'