SELECT startshift, endshift, starttime, endtime, `NAME`
from shifts
JOIN people on shifts.PPLID=people.id
JOIN shift_breaks on shifts.PPLID=BREAKID
where PPLID="0"
ORDER BY STARTSHIFT

SELECT startshift, endshift, starttime, endtime, `NAME`
from shifts
JOIN people on shifts.PPLID=people.id
INNER JOIN shift_breaks on shifts.PPLID=BREAKID
    and (convert(date,startshift) = (convert(date,starttime))
    and (convert(date,startshift) = (convert(date,endtime))
where PPLID="0"
ORDER BY STARTSHIFT