List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| "SELECT blog_id FROM $wpdb->blogs WHERE site_id = %d" | 1 |
|
| ' SELECT option_value, option_name FROM ' . $wpdb->options . ' WHERE option_name IN ( ' . implode(',', array_fill(0, count($option_names), '%s')) . ' ) ' | 1 |
|
| " SELECT `a`.* FROM {$wpdb->postmeta} AS a WHERE `a`.`meta_key` = %s AND NOT EXISTS ( SELECT DISTINCT `post_id` , count( `meta_id` ) AS count FROM {$wpdb->postmeta} AS b WHERE `a`.`post_id` = `b`.`post_id` AND `meta_key` LIKE %s AND `meta_key` <> %s GROUP BY `post_id` ) ;" | 1 |
|
| " SELECT `a`.* FROM {$wpdb->postmeta} AS a WHERE `a`.`meta_key` = %s AND NOT EXISTS ( SELECT DISTINCT `post_id` , count( `meta_id` ) AS count FROM {$wpdb->postmeta} AS b WHERE `a`.`post_id` = `b`.`post_id` AND ( `meta_key` = %s OR `meta_key` = %s ) GROUP BY `post_id` ) ;" | 1 |
|
| "SELECT meta_id FROM {$wpdb->postmeta} WHERE " . implode(' OR ', $query) . ';' | 1 |
|
| "DELETE FROM {$wpdb->postmeta} WHERE meta_id IN( " . implode(',', $meta_ids) . ' )' | 1 |
|
| "SELECT meta_id, meta_value FROM {$wpdb->postmeta} WHERE meta_key = %s" | 1 |
|
| 'DELETE FROM ' . $wpdb->options . ' WHERE option_name LIKE "wpseo_sitemap_%" AND autoload = "yes"' | 1 |
|
| 'UPDATE ' . $wpdb->postmeta . ' SET meta_key = %s WHERE meta_key = "yst_is_cornerstone"' | 1 |
|
| ' SELECT user_id, meta_value FROM ' . $wpdb->usermeta . ' WHERE meta_key = %s AND meta_value LIKE %s ' | 1 |
|
| 'DELETE FROM ' . $wpdb->postmeta . ' WHERE meta_key = "_yst_content_links_processed"' | 1 |
|
| "UPDATE $wpdb->usermeta SET meta_key = 'wpseo_noindex_author' WHERE meta_key = 'wpseo_excludeauthorsitemap'" | 1 |
|
| "UPDATE $wpdb->postmeta SET meta_key = '_yoast_wpseo_is_cornerstone' WHERE meta_key = '_yst_is_cornerstone'" | 1 |
|
| 'DELETE FROM ' . $wpdb->options . ' WHERE option_name LIKE "wpseo_sitemap_%"' | 1 |
|
| "DELETE FROM $wpdb->usermeta WHERE meta_key = 'wp_yoast_promo_hide_premium_upsell_admin_block'" | 1 |
|
| "DELETE FROM $indexable_table WHERE object_type = 'term' AND object_sub_type IN (" . \implode(', ', \array_fill(0, \count($private_taxonomies), '%s')) . ')' | 1 |
|
| "UPDATE $indexable_table SET permalink = NULL WHERE object_type = 'post' AND object_sub_type = 'attachment'" | 1 |
|
| "DELETE FROM $wpdb->options WHERE option_name LIKE 'wpseo_sitemap%validator%'" | 1 |
|
| 'SELECT option_value FROM ' . $wpdb->options . ' WHERE option_name = %s' | 1 |
|
| "DELETE FROM $indexable_table WHERE object_type = 'post' AND object_sub_type IS NOT NULL" | 1 |
|
| "DELETE FROM $indexable_table WHERE object_type = 'post' AND object_sub_type IS NOT NULL AND object_sub_type NOT IN ( " . \implode(', ', \array_fill(0, \count($included_post_types), '%s')) . ' )' | 1 |
|
| "DELETE FROM $indexable_table WHERE object_type = 'term' AND object_sub_type IS NOT NULL" | 1 |
|
| "DELETE FROM $indexable_table WHERE object_type = 'term' AND object_sub_type IS NOT NULL AND object_sub_type NOT IN ( " . \implode(', ', \array_fill(0, \count($included_taxonomies), '%s')) . ' )' | 1 |
|
| "DELETE FROM $indexable_table WHERE post_status = 'unindexed' AND object_type NOT IN ( 'home-page', 'date-archive', 'post-type-archive', 'system-page' ) AND object_id IS NULL" | 1 |
|
| "DELETE FROM $indexable_table WHERE object_type = 'user'" | 1 |
|
| "DELETE FROM $indexable_table WHERE object_id IN ( " . \implode(', ', \array_fill(0, \count($filtered_duplicates), '%d')) . ' ) AND id NOT IN ( ' . \implode(', ', \array_fill(0, \count($filtered_duplicates), '%d')) . ' ) AND object_type = %s' | 1 |
|
| "SELECT DISTINCT meta_key FROM $wpdb->postmeta WHERE meta_key NOT BETWEEN '_' AND '_z' AND SUBSTRING(meta_key, 1, 1) != '_' LIMIT %d" | 1 |
|
| 'DELETE FROM %1$s WHERE %2$s' | 1 |
|
| " SELECT post_type, MAX(post_modified_gmt) AS date FROM $wpdb->posts WHERE post_status IN ('" . implode("','", $post_statuses) . "') AND post_type IN ('" . implode("','", $post_type_names) . "') GROUP BY post_type ORDER BY date DESC " | 1 |
|
| " SELECT MAX(p.post_modified_gmt) AS lastmod FROM $wpdb->posts AS p INNER JOIN $wpdb->term_relationships AS term_rel ON term_rel.object_id = p.ID INNER JOIN $wpdb->term_taxonomy AS term_tax ON term_tax.term_taxonomy_id = term_rel.term_taxonomy_id AND term_tax.taxonomy = %s AND term_tax.term_id = %d WHERE p.post_status IN ('" . implode("','", $post_statuses) . "') AND p.post_password = '' " | 1 |
|
| " SELECT post_modified_gmt FROM ( SELECT @rownum:=0 ) init JOIN {$wpdb->posts} USE INDEX( type_status_date ) WHERE post_status IN ('" . implode("','", $post_statuses) . "') AND post_type = %s AND ( @rownum:=@rownum+1 ) %% %d = 0 ORDER BY post_modified_gmt ASC " | 1 |
|
| " SELECT COUNT({$wpdb->posts}.ID) FROM {$wpdb->posts} {$join_filter} {$where} {$where_filter} " | 1 |
|
| " SELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_status, post_modified_gmt, post_date, post_date_gmt FROM ( SELECT {$wpdb->posts}.ID FROM {$wpdb->posts} {$join_filter} {$where} {$where_filter} ORDER BY {$wpdb->posts}.post_modified ASC LIMIT %d OFFSET %d ) o JOIN {$wpdb->posts} l ON l.ID = o.ID " | 1 |
|
| 'Show %s in search results?' | 1 |
|
| 'Show blog page in breadcrumbs' | 1 |
|
| "SELECT COUNT(ID) FROM {$subquery} WHERE post_status IN (" . implode(', ', array_fill(0, count($states), '%s')) . ')' | 1 |
|
| " SELECT COUNT(ID) FROM {$subquery} WHERE post_status = %s " | 1 |
|
| "SELECT COUNT(ID) FROM {$subquery} WHERE post_status IN ('trash') " | 1 |
|
| "SELECT DISTINCT post_type FROM {$subquery} WHERE post_status IN (" . implode(', ', array_fill(0, count($states), '%s')) . ') ORDER BY post_type ASC' | 1 |
|
| 'Show All Content Types' | 1 |
|
| "SELECT COUNT(ID) FROM {$subquery} WHERE post_status IN ({$all_states}) {$post_type_clause} " | 1 |
|
| " SELECT ID, post_title, post_type, post_status, post_modified, post_date FROM {$subquery} WHERE post_status IN ({$all_states}) $post_type_clause ORDER BY {$orderby} {$order} LIMIT %d,%d " | 1 |
|
| "SELECT * FROM {$wpdb->postmeta} WHERE {$where}" | 1 |
|
| 'INSERT INTO `%1$s` (%2$s) VALUES ( %3$s ) ON DUPLICATE KEY UPDATE %4$s' | 1 |
|
| "SELECT COUNT( 1 ) FROM {$wpdb->postmeta} WHERE post_id IN( SELECT ID FROM {$wpdb->posts} WHERE post_type = %s ) AND meta_key = %s AND meta_value = '1' " | 1 |
|
| "SELECT COUNT(*) FROM {$wpdb->options} WHERE option_name LIKE 'wpseo_category_%'" | 1 |
|
| "DELETE FROM {$wpdb->postmeta} WHERE meta_key LIKE '_wpseo_edit_%'" | 1 |
|
| "SELECT post_id AS identifier FROM {$this->table_name} WHERE blog_id = %d" | 1 |
|
| "SHOW TABLES LIKE '{$this->table_name}'" | 1 |
|
| "SELECT seo FROM {$this->table_name} WHERE blog_id = %d AND " . $query_where | 1 |
|
| "DELETE FROM {$wpdb->postmeta} WHERE meta_key = %s" | 1 |
|
| "SELECT URL AS identifier FROM {$this->table_name} WHERE blog_id = %d" | 1 |
|
| 'SELECT meta_value FROM tmp_meta_table WHERE meta_value LIKE %s' | 1 |
|
| "DELETE FROM {$wpdb->postmeta} WHERE meta_key LIKE %s" | 1 |
|
| "SELECT COUNT(*) AS `count` FROM {$wpdb->postmeta} WHERE meta_key IN ( " . implode(', ', array_fill(0, count($meta_keys), '%s')) . ' )' | 1 |
|
| "DELETE FROM tmp_meta_table WHERE post_id IN ( SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key = %s )" | 1 |
|
| 'UPDATE tmp_meta_table SET meta_id = NULL' | 1 |
|
| 'UPDATE tmp_meta_table SET meta_key = %s' | 1 |
|
| "INSERT INTO {$wpdb->postmeta} SELECT * FROM tmp_meta_table" | 1 |
|
| 'UPDATE tmp_meta_table SET meta_value = %s WHERE meta_value = %s' | 1 |
|
| "DELETE FROM {$wpdb->postmeta} WHERE meta_key LIKE '_seop_%'" | 1 |
|
| "UPDATE $wpdb->postmeta SET meta_value = REPLACE( meta_value, '%', '%%' ) WHERE meta_key IN ( 'rank_math_description', 'rank_math_title' )" | 1 |
|
| "UPDATE $wpdb->postmeta SET meta_value = REPLACE( meta_value, '%%', '%' ) WHERE meta_key IN ( 'rank_math_description', 'rank_math_title' )" | 1 |
|
| "SELECT post_id, meta_value FROM $wpdb->postmeta WHERE meta_key = 'rank_math_robots'" | 1 |
|
| "DELETE FROM $wpdb->options WHERE option_name LIKE 'rank-math-%'" | 1 |
|
| "DELETE FROM $wpdb->options WHERE option_name LIKE '%rank_math%'" | 1 |
|
| 'Show this item.' | 1 |
|
| 'SELECT ' | 1 |
|
| "UPDATE {$this->quote_identifier($this->table_name)} SET" | 1 |
|
| 'SHOW DATABASES' | 1 |
|
| "SELECT * FROM $table LIMIT 1" | 1 |
|
| "SHOW FULL COLUMNS FROM %s LIKE '%s'" | 1 |
|
| 'SHOW KEYS FROM %s' | 1 |
|
| 'SELECT version FROM %s' | 1 |
|
| "INSERT INTO %s (version) VALUES ('%s')" | 1 |
|
| "DELETE FROM %s WHERE version = '%s'" | 1 |
|
| " SELECT MAX(p.post_modified_gmt) AS last_modified, MIN(p.post_date_gmt) AS published_at FROM {$this->wpdb->posts} AS p WHERE p.post_status IN (" . \implode(', ', \array_fill(0, \count($post_statuses), '%s')) . ") AND p.post_password = '' AND p.post_type = %s " | 1 |
|
| " SELECT MAX(p.post_modified_gmt) AS last_modified, MIN(p.post_date_gmt) AS published_at FROM {$this->wpdb->posts} AS p WHERE p.post_status IN (" . \implode(', ', \array_fill(0, \count($post_statuses), '%s')) . ") AND p.post_password = '' AND p.post_author = %d " | 1 |
|
| " SELECT MAX(p.post_modified_gmt) AS last_modified, MIN(p.post_date_gmt) AS published_at FROM {$this->wpdb->posts} AS p INNER JOIN {$this->wpdb->term_relationships} AS term_rel ON term_rel.object_id = p.ID INNER JOIN {$this->wpdb->term_taxonomy} AS term_tax ON term_tax.term_taxonomy_id = term_rel.term_taxonomy_id AND term_tax.taxonomy = %s AND term_tax.term_id = %d WHERE p.post_status IN (" . \implode(', ', \array_fill(0, \count($post_statuses), '%s')) . ") AND p.post_password = '' " | 1 |
|
| " SELECT MAX(p.post_modified_gmt) AS last_modified, MIN(p.post_date_gmt) AS published_at FROM {$this->wpdb->posts} AS p WHERE p.post_status IN (" . \implode(', ', \array_fill(0, \count($post_statuses), '%s')) . ") AND p.post_password = '' AND p.post_type = 'post' " | 1 |
|
| 'DELETE FROM ' . $this->get_indexable_hierarchy_table_name( ) | 1 |
|
| ' UPDATE ' . Model::get_table_name('Indexable') . ' SET has_ancestors = 1 WHERE id IN ( SELECT indexable_id FROM ' . Model::get_table_name('Indexable_Hierarchy') . ' ) ' | 1 |
|
| 'DELETE wyi FROM ' . $table_name . ' wyi INNER JOIN ' . $table_name . ' wyi2 WHERE wyi2.object_id = wyi.object_id AND wyi2.object_type = wyi.object_type AND wyi2.id < wyi.id;' | 1 |
|
| 'Show debug information' | 1 |
|
| "DELETE FROM $indexable_table WHERE object_type = %s AND object_sub_type = %s ORDER BY id LIMIT %d" | 1 |
|
| "DELETE FROM $indexable_table WHERE object_type = 'post' AND post_status = %s ORDER BY id LIMIT %d" | 1 |
|
| "DELETE FROM $indexable_table WHERE object_type = 'post' AND object_sub_type IS NOT NULL LIMIT %d" | 1 |
|
| "DELETE FROM $indexable_table WHERE object_type = 'post' AND object_sub_type IS NOT NULL AND object_sub_type NOT IN ( " . \implode(', ', \array_fill(0, \count($included_post_types), '%s')) . ' ) LIMIT %d' | 1 |
|
| "DELETE FROM $indexable_table WHERE object_type = 'term' AND object_sub_type IS NOT NULL LIMIT %d" | 1 |
|
| "DELETE FROM $indexable_table WHERE object_type = 'term' AND object_sub_type IS NOT NULL AND object_sub_type NOT IN ( " . \implode(', ', \array_fill(0, \count($included_taxonomies), '%s')) . ' ) LIMIT %d' | 1 |
|
| "DELETE FROM $indexable_table WHERE object_type = 'user' LIMIT %d" | 1 |
|
| "DELETE FROM $indexable_table WHERE object_type = 'user' AND object_id NOT IN ( SELECT DISTINCT post_author FROM $wpdb->posts WHERE post_type IN ( " . \implode(', ', \array_fill(0, \count($author_archive_post_types), '%s')) . ' ) AND post_status IN ( ' . \implode(', ', \array_fill(0, \count($viewable_post_stati), '%s')) . ' ) ) LIMIT %d' | 1 |
|
| " SELECT table_to_clean.{$column} FROM {$table} table_to_clean LEFT JOIN {$indexable_table} AS indexable_table ON table_to_clean.{$column} = indexable_table.id WHERE indexable_table.id IS NULL AND table_to_clean.{$column} IS NOT NULL LIMIT %d" | 1 |
|
| "DELETE FROM $table WHERE {$column} IN( " . \implode(',', $orphans) . ' )' | 1 |
|
| 'Update to the latest version of %1$s!' | 1 |
|
| 'Select SEO plugin' | 1 |
|
| 'Update to the latest version of %s' | 1 |
|
| 'Update %s' | 1 |
|
| 'SELECT term_taxonomy_id FROM ' . $this->wpdb->term_taxonomy . ' WHERE term_id IN( ' . \implode(', ', \array_fill(0, (\count($child_object_ids) + 1), '%s')) . ' )' | 1 |
|
| 'SELECT DISTINCT object_id FROM ' . $this->wpdb->term_relationships . ' WHERE term_taxonomy_id IN( ' . \implode(', ', \array_fill(0, \count($term_taxonomy_ids), '%s')) . ' )' | 1 |
|
| " DELETE FROM `$hierarchy_table` WHERE indexable_id IN( SELECT id FROM `$indexable_table` WHERE object_type = 'post' AND object_sub_type IN( " . \implode(', ', \array_fill(0, $total, '%s')) . ' ) )' | 1 |
|
| " SELECT COUNT(T.term_id) FROM {$this->wpdb->term_taxonomy} AS T LEFT JOIN $indexable_table AS I ON T.term_id = I.object_id AND I.object_type = 'term' AND I.link_count IS NOT NULL WHERE I.object_id IS NULL AND T.taxonomy IN ($placeholders)" | 1 |
|
| " SELECT T.term_id, T.description FROM {$this->wpdb->term_taxonomy} AS T LEFT JOIN $indexable_table AS I ON T.term_id = I.object_id AND I.object_type = 'term' AND I.link_count IS NOT NULL WHERE I.object_id IS NULL AND T.taxonomy IN (" . \implode(', ', \array_fill(0, \count($public_taxonomies), '%s')) . ") $limit_query" | 1 |
|
| " SELECT COUNT(term_id) FROM {$taxonomy_table} AS T LEFT JOIN $indexable_table AS I ON T.term_id = I.object_id AND I.object_type = 'term' AND I.version = %d WHERE I.object_id IS NULL AND taxonomy IN ($taxonomies_placeholders)" | 1 |
|
| " SELECT term_id FROM {$taxonomy_table} AS T LEFT JOIN $indexable_table AS I ON T.term_id = I.object_id AND I.object_type = 'term' AND I.version = %d WHERE I.object_id IS NULL AND taxonomy IN ($placeholders) $limit_query" | 1 |
|
| " SELECT COUNT(P.ID) FROM {$this->wpdb->posts} AS P WHERE P.post_type IN (" . \implode(', ', \array_fill(0, \count($post_types), '%s')) . ') AND P.post_status NOT IN (' . \implode(', ', \array_fill(0, \count($excluded_post_statuses), '%s')) . ") AND P.ID not in ( SELECT I.object_id from $indexable_table as I WHERE I.object_type = 'post' AND I.version = %d )" | 1 |
|
| " SELECT P.ID FROM {$this->wpdb->posts} AS P WHERE P.post_type IN (" . \implode(', ', \array_fill(0, \count($post_types), '%s')) . ') AND P.post_status NOT IN (' . \implode(', ', \array_fill(0, \count($excluded_post_statuses), '%s')) . ") AND P.ID not in ( SELECT I.object_id from $indexable_table as I WHERE I.object_type = 'post' AND I.version = %d ) $limit_query" | 1 |
|
| "SELECT COUNT(P.ID) FROM {$this->wpdb->posts} AS P LEFT JOIN $indexable_table AS I ON P.ID = I.object_id AND I.link_count IS NOT NULL AND I.object_type = 'post' LEFT JOIN $links_table AS L ON L.post_id = P.ID AND L.target_indexable_id IS NULL AND L.type = 'internal' AND L.target_post_id IS NOT NULL AND L.target_post_id != 0 WHERE ( I.object_id IS NULL OR L.post_id IS NOT NULL ) AND P.post_status = 'publish' AND P.post_type IN (" . \implode(', ', \array_fill(0, \count($public_post_types), '%s')) . ')' | 1 |
|
| " SELECT P.ID, P.post_content FROM {$this->wpdb->posts} AS P LEFT JOIN $indexable_table AS I ON P.ID = I.object_id AND I.link_count IS NOT NULL AND I.object_type = 'post' LEFT JOIN $links_table AS L ON L.post_id = P.ID AND L.target_indexable_id IS NULL AND L.type = 'internal' AND L.target_post_id IS NOT NULL AND L.target_post_id != 0 WHERE ( I.object_id IS NULL OR L.post_id IS NOT NULL ) AND P.post_status = 'publish' AND P.post_type IN (" . \implode(', ', \array_fill(0, \count($public_post_types), '%s')) . ") $limit_query" | 1 |
|
| "DELETE FROM {$table} WHERE meta_key IN (" . \implode(', ', \array_fill(0, \count($meta_keys_to_delete), '%s')) . ')' | 1 |
|
| 'SELECT 1' | 1 |
|
| "SHOW COLUMNS FROM {$table}" | 1 |
|
| "SELECT {$select_statement} FROM {$table} WHERE id > %d ORDER BY id{$limit_statement}" | 1 |
|
| "SHOW TABLES LIKE '{$table}'" | 1 |
|
| "DELETE FROM $indexable_table WHERE object_type = 'post' AND object_sub_type = 'attachment'" | 1 |
|
| "UPDATE $links_table SET target_indexable_id = NULL WHERE type = 'image-in'" | 1 |
|
| 'UPDATE tmp_meta_table SET meta_value = REPLACE( meta_value, %s, %s )' | 2 |
|
| 'INSERT INTO' | 2 |
|
| 'DELETE FROM' | 2 |
|