`whenYear` >='-3000'
AND `whenYear` <='3000'
AND
( `eventId` = '-1829845 ' )
ORDER BY `whenYear` ASC, `whenMonth` ASC , `whenDay` ASC,`eventSig` DESC
LIMIT
0
,
100

John Burke
Q.O
in 1878

in 1878
Group of British Officers (Q.O) [Queen&aposs Own] Guides
-1829845