`whenYear` >='-3000'
AND `whenYear` <='3000'
AND
( `whoCharName` = 'A gentleman of the Bedchamber; two gromes of the Bedchamber; lieutenant of the yeomen of the guard; ensign of the yeomen of the guard;yeoman of his Majesties guard of his body in number one hundred ' or `whoRel` = 'A gentleman of the Bedchamber; two gromes of the Bedchamber; lieutenant of the yeomen of the guard; ensign of the yeomen of the guard;yeoman of his Majesties guard of his body in number one hundred')
ORDER BY `whenYear` ASC, `whenMonth` ASC , `whenDay` ASC,`eventSig` DESC
LIMIT
0
,
100