You must join two tables (I think You want to select records from lots not from status:
1)

***********
event1val = 19432 && id of first eventlevel
event2val = 19412 && id of second event level

select status.date, status.name, ;
status.status_id, status.stats_id, lots.lots_id ;
from lots, status ;
where lots.lots_id = status.lots_id ;             && and status.lots_id = lots.lots_id ;
AND status.stats_id == event1val ;

GROUP BY lots_id 
into CURSOR showme
************

2)

***********
event1val = 19432 && id of first eventlevel
event2val = 19412 && id of second event level

select status.date, status.name, ;
status.status_id, status.stats_id, lots.lots_id ;
from lots;
LEFT JOIN Status ON Lots.Lots_Id == status.lots_id; 
where status.stats_id == event1val ;
GROUP BY Lots.lots_id 
into CURSOR showme
************

(never tested)