Skip to content

Instantly share code, notes, and snippets.

@antonkorotkov

antonkorotkov/gist:9b41d70cb41242a4c81b

Last active November 30, 2015 09:53
Show Gist options
  • Save antonkorotkov/9b41d70cb41242a4c81b to your computer and use it in GitHub Desktop.
Save antonkorotkov/9b41d70cb41242a4c81b to your computer and use it in GitHub Desktop.
Download ZIP
expiration.sql
Raw
gistfile1.sql
select distinct(`wp_posts`.`ID`),`wp_posts`.`post_title`, `wp_users`.`user_email`, `wp_users`.`display_name`, `wp_woocommerce_downloadable_product_permissions`.`access_expires` from `wp_woocommerce_downloadable_product_permissions`,`wp_users`,`wp_posts` where `access_expires` = DATE_SUB(CURDATE(), INTERVAL -205 DAY) and `wp_woocommerce_downloadable_product_permissions`.`user_id` = `wp_users`.`ID` and `wp_posts`.`ID` = `wp_woocommerce_downloadable_product_permissions`.`product_id`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment