`whenYear` >='-3000'
AND `whenYear` <='3000'
AND
( `whoCharName` = 'The charge of the first Iowa regiment with General Lyon at its head at the Battle of Wilsons Creek near Springfield Missouri August 10 1861 ' or `whoRel` = 'The charge of the first Iowa regiment with General Lyon at its head at the Battle of Wilsons Creek near Springfield Missouri August 10 1861')
ORDER BY `whenYear` ASC, `whenMonth` ASC , `whenDay` ASC,`eventSig` DESC
LIMIT
0
,
100