php - 高级MySQL : Display only items that have not been updated in 30 days

Question

我试图仅显示过去三十天内未更新的列表。

此查询工作正常，只是它明显缺少三十天更新要求:

$Listings = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."fsrep_listings, ".$wpdb->prefix."fsrep_listings_to_users WHERE ".$wpdb->prefix."fsrep_listings_to_users.ID = ".$Userprofile->ID." AND ".$wpdb->prefix."fsrep_listings.listing_visibility = 1 AND ".$wpdb->prefix."fsrep_listings.listing_id = ".$wpdb->prefix."fsrep_listings_to_users.listing_id");

我已经尝试过，但没有成功:

$Listings = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."fsrep_listings, ".$wpdb->prefix."fsrep_listings_to_users WHERE ".$wpdb->prefix."fsrep_listings_to_users.ID = ".$Userprofile->ID." AND ".$wpdb->prefix."fsrep_listings.listing_visibility = 1 AND ".$wpdb->prefix."fsrep_listings.listing_id = ".$wpdb->prefix."fsrep_listings_to_users.listing_id AND ".$wpdb->prefix."fsrep_listings.listing_last_updated < unix_timestamp(now() - interval 30 day");

如果您需要以下信息，我将使用以下时间戳格式将日期存储在数据库中:2011-02-12 22:23:01。我一定错过了一些相对简单的东西。感谢您的帮助!

Answer 1

我想我明白了:

$Listings = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."fsrep_listings, ".$wpdb->prefix."fsrep_listings_to_users WHERE ".$wpdb->prefix."fsrep_listings_to_users.ID = ".$Userprofile->ID." AND ".$wpdb->prefix."fsrep_listings.listing_visibility = 1 AND ".$wpdb->prefix."fsrep_listings.listing_id = ".$wpdb->prefix."fsrep_listings_to_users.listing_id AND date_format(".$wpdb->prefix."fsrep_listings.listing_last_updated,'%Y%m%d')<date_format(adddate(now(),interval -30 day),'%Y%m%d')");