SELECT `listing_title`, `etc` FROM `ad_listing`
WHERE `date_posted` BETWEEN date_sub(now(), INTERVAL 1 WEEK) AND now();

SELECT * FROM cars WHERE model="toyta" and submitted_time > '2012-11-8 20:31:23'