`whenYear` >='-3000'
AND `whenYear` <='3000'
AND
( `whoCharName` = ' movie The Red and the White ' or `whoRel` = ' movie The Red and the White ' or `whereLoc` = ' movie The Red and the White')
AND (`access` ='Public' )
ORDER BY `whenYear` ASC, `whenMonth` ASC , `whenDay` ASC,`eventSig` DESC
LIMIT
0
,
300