List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| "SHOW TABLES LIKE '{$as_table_name}'" | 1 |
|
| "INSERT {$wpdb->actionscheduler_logs} (action_id, message, log_date_gmt, log_date_local) VALUES " | 1 |
|
| "UPDATE {$wpdb->posts} SET post_password = %s, post_modified_gmt = %s, post_modified = %s" | 1 |
|
| "SELECT COUNT(DISTINCT post_password) FROM {$wpdb->posts} WHERE post_password != '' AND post_type = %s AND post_status IN ('in-progress','pending')" | 1 |
|
| 'SELECT p.ID ' | 1 |
|
| 'SELECT count(p.ID)' | 1 |
|
| "SELECT p.ID FROM {$wpdb->posts} p" | 1 |
|
| "SELECT comment_approved, COUNT( * ) AS num_comments FROM {$wpdb->comments} WHERE comment_type NOT IN('order_note','action_log') GROUP BY comment_approved" | 1 |
|
| "SELECT * FROM {$wpdb->actionscheduler_logs} WHERE action_id=%d" | 1 |
|
| "UPDATE {$wpdb->posts} SET post_password = '' WHERE ID IN ($action_id_string) AND post_password = %s" | 1 |
|
| "SELECT * FROM {$wpdb->actionscheduler_logs} WHERE log_id=%d" | 1 |
|
| "SELECT COUNT({$this->ID}) FROM {$this->table_name} {$where}" | 1 |
|
| "SELECT $columns FROM {$this->table_name} {$where} {$order} {$limit} {$offset}" | 1 |
|
| "DELETE FROM {$this->table_name} WHERE {$this->ID} IN $ids_sql" | 1 |
|
| " SELECT items_table.order_id AS order_id, items_meta_table.meta_value AS product_id FROM {$items_table} AS items_table JOIN {$meta_table} AS items_meta_table ON items_table.order_item_id = items_meta_table.order_item_id WHERE items_table.order_id IN ({$order_ids}) AND ( ( items_meta_table.meta_key = '_product_id' AND items_meta_table.meta_value IN ({$product_ids}) ) OR ( items_meta_table.meta_key = '_variation_id' AND items_meta_table.meta_value IN ({$product_ids}) ) ) " | 1 |
|
| 'Select User' | 1 |
|
| 'Delete note' | 1 |
|
| "SELECT ID FROM {$wpdb->posts} WHERE post_type = %s AND post_password = %s" | 1 |
|
| "UPDATE {$wpdb->posts} SET post_password = '' WHERE ID = %d AND post_type = %s" | 1 |
|
| "SELECT ID FROM {$wpdb->posts} WHERE post_type = 'scheduled-action'" | 1 |
|
| "SELECT a.status, count(a.status) as 'count'" | 1 |
|
| "UPDATE {$wpdb->actionscheduler_actions} SET attempts = attempts+1, status=%s, last_attempt_gmt = %s, last_attempt_local = %s WHERE action_id = %d" | 1 |
|
| "SELECT action_id FROM {$wpdb->actionscheduler_actions} WHERE claim_id=%d" | 1 |
|
| "SELECT claim_id FROM {$wpdb->actionscheduler_actions} WHERE action_id=%d" | 1 |
|
| "SELECT COUNT(DISTINCT claim_id) FROM {$wpdb->actionscheduler_actions} WHERE claim_id != 0 AND status IN ( %s, %s)" | 1 |
|
| "UPDATE {$wpdb->actionscheduler_actions} SET claim_id=%d, last_attempt_gmt=%s, last_attempt_local=%s" | 1 |
|
| "SELECT * FROM {$wpdb->actionscheduler_actions} WHERE action_id=%d" | 1 |
|
| "UPDATE {$wpdb->actionscheduler_actions} SET status = %s WHERE action_id IN {$query_in}" | 1 |
|
| 'SELECT a.action_id' | 1 |
|
| "UPDATE {$wpdb->posts} SET post_status = %s WHERE ID = %d AND post_type = %s" | 1 |
|
| 'SELECT count(a.action_id)' | 1 |
|
| "SELECT a.action_id FROM {$wpdb->actionscheduler_actions} a" | 1 |
|
| "SELECT a.*, g.slug AS `group` FROM {$wpdb->actionscheduler_actions} a LEFT JOIN {$wpdb->actionscheduler_groups} g ON a.group_id=g.group_id WHERE a.action_id=%d" | 1 |
|
| "SELECT group_id FROM {$wpdb->actionscheduler_groups} WHERE slug=%s" | 1 |
|
| "SELECT MAX(ID) FROM $wpdb->posts" | 1 |
|
| "UPDATE {$wpdb->posts} SET menu_order = menu_order+1, post_status=%s, post_modified_gmt = %s, post_modified = %s WHERE ID = %d AND post_type = %s" | 1 |
|
| "SELECT {$column_name} FROM {$wpdb->posts} WHERE ID=%d AND post_type=%s" | 1 |
|
| 'Update expiration date to plan length' | 1 |
|
| 'Update start date to plan start access date' | 1 |
|
| 'Delete User Membership' | 1 |
|
| " SELECT p.ID FROM {$wpdb->posts} p WHERE p.post_type = 'product_variation' AND p.post_parent IN ({$parents}) " | 1 |
|
| " SELECT * FROM $wpdb->postmeta WHERE post_id = %d " | 1 |
|
| " SELECT object_id FROM $wpdb->term_relationships LEFT JOIN $wpdb->term_taxonomy ON $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id WHERE term_id IN ($placeholder) " | 1 |
|
| " SELECT object_id FROM $wpdb->term_relationships LEFT JOIN $wpdb->term_taxonomy ON $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id WHERE $wpdb->term_taxonomy.taxonomy IN ($term_taxonomies) " | 1 |
|
| " SELECT sub_t.term_id FROM $wpdb->terms AS sub_t INNER JOIN $wpdb->term_taxonomy AS sub_tt ON sub_t.term_id = sub_tt.term_id WHERE sub_tt.taxonomy IN ($taxonomies) " | 1 |
|
| " SELECT object_id FROM $wpdb->term_relationships LEFT JOIN $wpdb->posts ON $wpdb->posts.ID = $wpdb->term_relationships.object_id LEFT JOIN $wpdb->term_taxonomy ON $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id WHERE CASE $case END AND term_id IN ($taxonomy_terms) " | 1 |
|
| " SELECT object_id FROM $wpdb->term_relationships LEFT JOIN $wpdb->posts ON $wpdb->posts.ID = $wpdb->term_relationships.object_id LEFT JOIN $wpdb->term_taxonomy ON $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id WHERE CASE $case END AND $wpdb->term_taxonomy.taxonomy IN ($taxonomies) " | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE post_type IN ($post_types)" | 1 |
|
| " SELECT p.ID, p.post_type FROM $wpdb->posts p LEFT JOIN $wpdb->postmeta pm ON p.ID = pm.post_id WHERE pm.meta_key = '_wc_memberships_force_public' AND pm.meta_value = 'yes' " | 1 |
|
| "SELECT user_id FROM $table WHERE group_id=%d" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE post_parent = %d" | 1 |
|
| " SELECT posts_meta.meta_value FROM {$wpdb->prefix}postmeta AS posts_meta WHERE posts_meta.post_id IN ({$order_ids}) AND posts_meta.meta_key = '_customer_user' " | 1 |
|
| " SELECT DISTINCT posts.ID FROM {$wpdb->prefix}woocommerce_order_itemmeta AS order_item_meta, {$wpdb->prefix}woocommerce_order_items AS order_items, {$wpdb->prefix}posts AS posts WHERE order_items.order_item_id = order_item_meta.order_item_id AND order_items.order_id = posts.ID AND ( ( order_item_meta.meta_key LIKE '_product_id' AND order_item_meta.meta_value IN ({$product_ids}) ) OR ( order_item_meta.meta_key LIKE '_variation_id' AND order_item_meta.meta_value IN ({$product_ids}) ) ) " | 1 |
|
| " SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_post_ID in ( SELECT ID FROM $wpdb->posts WHERE post_type = 'wc_user_membership' ) " | 1 |
|
| 'Select plans whose members should not be offered this rate.' | 1 |
|
| 'Select plans whose members should be offered free shipping.' | 1 |
|
| " SELECT ID FROM $wpdb->posts WHERE post_parent IN $parents " | 1 |
|
| " SELECT p.ID FROM $wpdb->posts p LEFT JOIN $wpdb->postmeta pm ON p.ID = pm.post_id WHERE p.post_type = 'product' AND pm.meta_key = '_wc_memberships_exclude_discounts' AND pm.meta_value = 'yes' " | 1 |
|
| "SELECT group_id, name FROM $group_table ORDER BY group_id" | 1 |
|
| "SELECT status FROM {$wpdb->actionscheduler_actions} WHERE action_id=%d" | 1 |
|
| 'Select which membership plans does purchasing this product grant access to.' | 1 |
|
| 'Delete with subscription' | 1 |
|
| 'Select a page…' | 1 |
|
| 'Show excerpts' | 1 |
|
| 'Select the page to redirect non-members to - should contain the [wcm_content_restricted] shortcode.' | 1 |
|
| 'Delete all matching memberships when %1$susers request to erase their personal data%2$s.' | 1 |
|
| 'Select when & where to display login reminder notice for guests if products in cart have member discounts.' | 1 |
|
| 'Show on both cart & checkout page' | 1 |
|
| 'Show on checkout page' | 1 |
|
| 'Show on cart page' | 1 |
|
| 'Update existing records if a matching user membership is found' | 1 |
|
| "SELECT %d, '$meta_key', '$meta_value'" | 1 |
|
| "INSERT INTO $wpdb->postmeta (post_id, meta_key, meta_value) " | 1 |
|
| " SELECT meta_key, meta_value FROM $wpdb->postmeta WHERE post_id=%d " | 1 |
|
| 'Delete this membership permanently' | 1 |
|
| 'Delete User Membership with Subscription' | 1 |
|
| "SELECT * FROM $wpdb->posts WHERE ID=%d" | 2 |
|
| 'Delete this membership permanently and the subscription associated with it' | 2 |
|
| 'Delete Selected' | 3 |
|
| 'Select all' | 3 |
|