`whenYear` >='-3000'
AND `whenYear` <='3000'
AND
( `whoCharName` = 'The seat of action between the British and American forces or An authentic plan of the western part of Long Island with the engagement of the 27th August 1776 between the King[]s forces andthe Americans : containing also Staten Island and the environ ' or `whoRel` = 'The seat of action between the British and American forces or An authentic plan of the western part of Long Island with the engagement of the 27th August 1776 between the King[]s forces andthe Americans : containing also Staten Island and the environ')
ORDER BY `whenYear` ASC, `whenMonth` ASC , `whenDay` ASC,`eventSig` DESC
LIMIT
0
,
100