mysql select

[testbot]

what is the lastpost in thread table format?

i need to select threads from the past 48 hours and where the lastpost is > 7 days

i'm not sure the best way to do this. i have the following so far.

$check=$vbulletin->db->query_read("
			SELECT * from `" . TABLE_PREFIX . "thread` 
			WHERE `forumid` IN($from)
			AND `lastpost` <= (TIMENOW - 7 DAYS)
			AND `dateline` <= (TIMENOW - 2 days)");

you can see the last two lines of the sql query need to be corrected.

thanks for your help!