List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| 'Select the permalink structure for your website. Including the %s tag makes links easy to understand, and can help your posts rank higher in search engines.' | 1 |
|
| 'Select a Privacy Policy page' | 1 |
|
| "SELECT comment_ID FROM $wpdb->comments WHERE comment_approved = %s AND %s > comment_date_gmt" | 1 |
|
| 'Select theme to edit:' | 1 |
|
| "SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month FROM $wpdb->posts WHERE post_type = %s AND post_status != 'auto-draft' ORDER BY post_date DESC" | 1 |
|
| "SELECT DISTINCT post_author FROM {$wpdb->posts} WHERE post_type = 'post'" | 1 |
|
| "SELECT DISTINCT post_author FROM {$wpdb->posts} WHERE post_type = 'page'" | 1 |
|
| 'Select location' | 1 |
|
| 'Delete a menu item by <strong>expanding it and clicking the Remove link</strong>' | 1 |
|
| 'Select a Menu' | 1 |
|
| 'Select a menu to edit:' | 1 |
|
| 'Select plugin to edit:' | 1 |
|
| 'Update to latest %s nightly' | 1 |
|
| 'Update WordPress' | 1 |
|
| "SELECT ID, post_parent FROM $wpdb->posts WHERE post_type = 'page'" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE 1=1" | 1 |
|
| "SELECT meta_key FROM $wpdb->postmeta GROUP BY meta_key ORDER BY meta_key" | 1 |
|
| "SELECT meta_key, meta_value, meta_id, post_id FROM $wpdb->postmeta WHERE post_id = %d ORDER BY meta_key,meta_id" | 1 |
|
| 'Delete Plugin' | 1 |
|
| 'Delete Plugins' | 1 |
|
| 'Delete My Site Permanently' | 1 |
|
| "SELECT $prefix" | 1 |
|
| 'Update WordPress Database' | 1 |
|
| 'Update Complete' | 1 |
|
| "SELECT ID FROM {$wpdb->posts} WHERE post_author IN( " . implode(',', $user_ids) . ' ) LIMIT 1' | 1 |
|
| "SELECT link_id FROM {$wpdb->links} WHERE link_owner IN( " . implode(',', $user_ids) . ' ) LIMIT 1' | 1 |
|
| 'Delete Users' | 1 |
|
| 'Show comments cookies opt-in checkbox, allowing comment author cookies to be set' | 1 |
|
| 'Show Avatars' | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE post_type='attachment' AND post_status = 'trash'" | 1 |
|
| 'Select one or more Theme features to filter by' | 1 |
|
| "SELECT activation_key FROM {$wpdb->signups} WHERE user_login = %s AND user_email = %s" | 1 |
|
| "SELECT * FROM $wpdb->options ORDER BY option_name" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE post_type=%s AND post_status = %s" | 1 |
|
| 'Select both the sidebar for this widget and the position of the widget in that sidebar.' | 1 |
|
| "SELECT blog_id FROM {$wpdb->registration_log} WHERE {$wpdb->registration_log}.IP LIKE %s" | 1 |
|
| "SELECT ID FROM {$wpdb->posts} $join WHERE $where" | 1 |
|
| "SELECT * FROM $wpdb->termmeta WHERE term_id = %d" | 1 |
|
| "SELECT DISTINCT post_author FROM $wpdb->posts WHERE post_status != 'auto-draft' $and" | 1 |
|
| "SELECT * FROM {$wpdb->posts} $where" | 1 |
|
| "SELECT * FROM $wpdb->postmeta WHERE post_id = %d" | 1 |
|
| "SELECT * FROM $wpdb->comments WHERE comment_post_ID = %d AND comment_approved <> 'spam'" | 1 |
|
| "SELECT * FROM $wpdb->commentmeta WHERE comment_id = %d" | 1 |
|
| 'Show Toolbar when viewing site' | 1 |
|
| 'Update Profile' | 1 |
|
| 'Update User' | 1 |
|
| 'Delete which is a permanent action after the confirmation screens.' | 1 |
|
| 'Update your network' | 1 |
|
| 'Delete Theme' | 1 |
|
| 'Delete Themes' | 1 |
|
| "SELECT ID, post_title FROM $wpdb->posts WHERE post_type = 'post' AND post_status = 'draft' AND post_author = %d ORDER BY post_modified DESC" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE post_author = %d AND post_type IN ('$post_types_to_delete')" | 1 |
|
| "SELECT * FROM {$blog_prefix}options WHERE option_name NOT LIKE %s AND option_name NOT LIKE %s" | 1 |
|
| 'Select a user to change role.' | 1 |
|
| 'Select a user to remove.' | 1 |
|
| " SELECT post_status, COUNT( * ) AS num_posts FROM {$wpdb->posts} WHERE post_type = %s AND post_name = %s GROUP BY post_status" | 1 |
|
| 'Delete requests' | 1 |
|
| 'Delete “%s”' | 1 |
|
| 'UPDATE LOG ==========' | 1 |
|
| 'Update your plugins' | 1 |
|
| 'Select a user' | 1 |
|
| "SELECT TABLE_NAME AS 'table', TABLE_ROWS AS 'rows', SUM(data_length + index_length) as 'bytes' FROM information_schema.TABLES WHERE TABLE_SCHEMA = %s AND TABLE_NAME IN ('$table_names') GROUP BY TABLE_NAME;" | 1 |
|
| 'Update to %s' | 1 |
|
| 'Show comments' | 1 |
|
| "SELECT ID, post_title, post_name FROM $wpdb->posts WHERE post_name = ''" | 1 |
|
| "UPDATE $wpdb->posts SET post_name = %s WHERE ID = %d" | 1 |
|
| "SELECT cat_ID, cat_name, category_nicename FROM $wpdb->categories" | 1 |
|
| "UPDATE $wpdb->options SET option_value = REPLACE(option_value, 'wp-links/links-images/', 'wp-images/links/') WHERE option_name LIKE %s AND option_value LIKE %s" | 1 |
|
| "SELECT DISTINCT post_id FROM $wpdb->post2cat" | 1 |
|
| "SELECT ID, post_category FROM $wpdb->posts WHERE post_category != '0' $catwhere" | 1 |
|
| "SELECT * FROM $wpdb->post2cat WHERE post_id = %d AND category_id = %d" | 1 |
|
| "SELECT ID, user_nickname, user_nicename FROM $wpdb->users" | 1 |
|
| "SELECT ID, user_pass from $wpdb->users" | 1 |
|
| "SELECT MAX(post_date_gmt) FROM $wpdb->posts" | 1 |
|
| "UPDATE $wpdb->posts SET post_date_gmt = DATE_ADD(post_date, INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE)" | 1 |
|
| "UPDATE $wpdb->posts SET post_modified = post_date" | 1 |
|
| "UPDATE $wpdb->posts SET post_modified_gmt = DATE_ADD(post_modified, INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE) WHERE post_modified != '0000-00-00 00:00:00'" | 1 |
|
| "UPDATE $wpdb->comments SET comment_date_gmt = DATE_ADD(comment_date, INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE)" | 1 |
|
| "UPDATE $wpdb->users SET user_registered = DATE_ADD(user_registered, INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE)" | 1 |
|
| "SELECT ID, post_title, post_content, post_excerpt, guid, post_date, post_name, post_status, post_author FROM $wpdb->posts" | 1 |
|
| "SELECT comment_ID, comment_author, comment_content FROM $wpdb->comments" | 1 |
|
| "SELECT link_id, link_name, link_description FROM $wpdb->links" | 1 |
|
| "UPDATE $wpdb->comments SET comment_type='trackback', comment_content = REPLACE(comment_content, '<trackback />', '') WHERE comment_content LIKE '<trackback />%'" | 1 |
|
| "UPDATE $wpdb->comments SET comment_type='pingback', comment_content = REPLACE(comment_content, '<pingback />', '') WHERE comment_content LIKE '<pingback />%'" | 1 |
|
| "SELECT option_name, COUNT(option_name) AS dupes FROM `$wpdb->options` GROUP BY option_name" | 1 |
|
| "SELECT option_id FROM $wpdb->options WHERE option_name = %s LIMIT %d" | 1 |
|
| "DELETE FROM $wpdb->options WHERE option_id IN ($dupe_ids)" | 1 |
|
| "SELECT * FROM $wpdb->users" | 1 |
|
| "SELECT comment_post_ID, COUNT(*) as c FROM $wpdb->comments WHERE comment_approved = '1' GROUP BY comment_post_ID" | 1 |
|
| "SELECT ID, post_type FROM $wpdb->posts WHERE post_status = 'object'" | 1 |
|
| "SELECT ID, post_status FROM $wpdb->posts" | 1 |
|
| "UPDATE $wpdb->posts SET post_status = %s, post_type = %s WHERE ID = %d" | 1 |
|
| "UPDATE $wpdb->posts SET post_status = 'future' WHERE post_status = 'publish' AND post_date_gmt > '$now'" | 1 |
|
| "SELECT ID, post_date FROM $wpdb->posts WHERE post_status ='future'" | 1 |
|
| "SELECT * FROM $wpdb->categories ORDER BY cat_ID" | 1 |
|
| "SELECT MAX(term_group) FROM $wpdb->terms GROUP BY term_group" | 1 |
|
| "UPDATE $wpdb->terms SET term_group = %d WHERE term_id = %d" | 1 |
|
| "INSERT INTO $wpdb->terms (term_id, name, slug, term_group) VALUES (%d, %s, %s, %d)" | 1 |
|
| "SELECT $select FROM $wpdb->post2cat GROUP BY post_id, category_id" | 1 |
|
| 'SELECT cat_id, cat_name FROM ' . $wpdb->prefix . 'linkcategories' | 1 |
|
| "SELECT link_id, link_category FROM $wpdb->links" | 1 |
|
| "SELECT link_id, category_id FROM $wpdb->link2cat GROUP BY link_id, category_id" | 1 |
|
| "SELECT term_taxonomy_id, taxonomy FROM $wpdb->term_taxonomy" | 1 |
|
| "SELECT COUNT(*) FROM $wpdb->term_relationships, $wpdb->posts WHERE $wpdb->posts.ID = $wpdb->term_relationships.object_id AND post_status = 'publish' AND post_type = 'post' AND term_taxonomy_id = %d" | 1 |
|
| "UPDATE $wpdb->postmeta SET meta_key = '_wp_old_slug' WHERE meta_key = 'old_slug'" | 1 |
|
| "UPDATE $wpdb->users SET user_activation_key = ''" | 1 |
|
| "UPDATE $wpdb->posts SET post_date = post_modified WHERE post_date = '0000-00-00 00:00:00'" | 1 |
|
| "SELECT option_name, option_value FROM $wpdb->options ORDER BY option_id LIMIT $start, 20" | 1 |
|
| "DELETE FROM $wpdb->usermeta WHERE meta_key LIKE %s OR meta_key LIKE %s OR meta_key LIKE %s OR meta_key LIKE %s OR meta_key LIKE %s OR meta_key LIKE %s OR meta_key = 'manageedittagscolumnshidden' OR meta_key = 'managecategoriescolumnshidden' OR meta_key = 'manageedit-tagscolumnshidden' OR meta_key = 'manageeditcolumnshidden' OR meta_key = 'categories_per_page' OR meta_key = 'edit_tags_per_page'" | 1 |
|
| "DELETE FROM $wpdb->usermeta WHERE meta_key IN ('show_admin_bar_admin', 'plugins_last_view')" | 1 |
|
| "DELETE FROM $wpdb->usermeta WHERE meta_key = 'themes_last_view'" | 1 |
|
| "SELECT autoload FROM $wpdb->options WHERE option_name = 'uninstall_plugins'" | 1 |
|
| "DELETE FROM $wpdb->usermeta WHERE meta_key IN ('$meta_keys')" | 1 |
|
| "SELECT `comment_ID` FROM `{$wpdb->comments}` WHERE `comment_date_gmt` > '2015-04-26' AND LENGTH( `comment_content` ) >= {$allowed_length} AND ( `comment_content` LIKE '%<%' OR `comment_content` LIKE '%>%' )" | 1 |
|
| "DELETE FROM $wpdb->options WHERE option_name REGEXP '^[0-9]+_new_email$'" | 1 |
|
| "SHOW COLUMNS FROM $wpdb->posts LIKE 'post_category'" | 1 |
|
| "SELECT 1 FROM {$wpdb->usermeta} WHERE meta_key = %s LIMIT 1" | 1 |
|
| "SELECT option_name FROM $wpdb->options WHERE autoload = 'yes' AND option_name != %s AND option_name LIKE %s" | 1 |
|
| "SELECT meta_key, meta_value FROM {$wpdb->sitemeta} ORDER BY meta_id LIMIT $start, 20" | 1 |
|
| "SHOW INDEXES FROM $wpdb->signups" | 1 |
|
| "SHOW FULL COLUMNS FROM `$table`" | 1 |
|
| "SHOW TABLE STATUS LIKE '$table'" | 1 |
|
| "SELECT option_value FROM $wpdb->options WHERE option_name = %s" | 1 |
|
| "SHOW INDEX FROM {$table};" | 1 |
|
| "DELETE o1 FROM $wpdb->options AS o1 JOIN $wpdb->options AS o2 USING (`option_name`) WHERE o2.option_id > o1.option_id" | 1 |
|
| "SHOW TABLES LIKE '{$wpdb->termmeta}'" | 1 |
|
| "SHOW INDEX FROM {$wpdb->termmeta} WHERE Column_name = 'meta_key'" | 1 |
|
| 'Update Now' | 1 |
|
| "SELECT comment_post_ID FROM $wpdb->comments WHERE comment_author = %s AND $date_field = %s" | 1 |
|
| "SELECT comment_post_ID, COUNT(comment_ID) as num_comments FROM $wpdb->comments WHERE comment_post_ID IN ( $post_id_in ) AND comment_approved = '0' GROUP BY comment_post_ID" | 1 |
|
| 'Show advanced menu properties' | 1 |
|
| "SELECT ID FROM $wpdb->posts AS p LEFT JOIN $wpdb->postmeta AS m ON p.ID = m.post_id WHERE post_type = 'nav_menu_item' AND post_status = 'draft' AND meta_key = '_menu_item_orphaned' AND meta_value < %d" | 1 |
|
| 'Show header text with your image.' | 1 |
|
| "SELECT post_id, meta_value FROM $wpdb->postmeta WHERE meta_key = %s LIMIT %d,%d" | 1 |
|
| "SELECT COUNT( post_id ) AS cnt FROM $wpdb->postmeta WHERE meta_key = %s" | 1 |
|
| "SELECT comment_ID, comment_agent FROM $wpdb->comments LIMIT %d,%d" | 1 |
|
| "SELECT COUNT( 1 ) FROM $wpdb->posts WHERE post_type = %s AND post_status NOT IN ( '" . implode("','", $exclude_states) . "' ) AND post_author = %d" | 1 |
|
| "SELECT COUNT( 1 ) FROM $wpdb->posts WHERE post_type = %s AND post_status NOT IN ('trash', 'auto-draft') AND ID IN ($sticky_posts)" | 1 |
|
| "SELECT option_name FROM $wpdb->options WHERE option_name in ( $keys )" | 1 |
|
| "INSERT INTO $wpdb->options (option_name, option_value, autoload) VALUES " . $insert | 1 |
|
| "DELETE FROM $wpdb->options WHERE option_name REGEXP '^rss_[0-9a-f]{32}(_ts)?$'" | 1 |
|
| "SELECT id FROM $wpdb->site WHERE id = %d" | 1 |
|
| "SELECT meta_value FROM $wpdb->sitemeta WHERE meta_key = %s AND site_id = %d" | 1 |
|
| "INSERT INTO $wpdb->sitemeta ( site_id, meta_key, meta_value ) VALUES " . $insert | 1 |
|
| "INSERT INTO $wpdb->blogmeta ( blog_id, meta_key, meta_value ) VALUES " . $insert | 1 |
|
| "SELECT domain FROM $wpdb->site ORDER BY id ASC LIMIT 1" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE post_date < DATE_SUB(NOW(), INTERVAL 1 MONTH) AND post_status = 'publish'" | 1 |
|
| "SELECT meta_value FROM $wpdb->sitemeta WHERE site_id = 1 AND meta_key = 'subdomain_install'" | 1 |
|
| 'Update Comment' | 1 |
|
| "SELECT DISTINCT meta_key FROM $wpdb->postmeta WHERE meta_key NOT BETWEEN '_' AND '_z' HAVING meta_key NOT LIKE %s ORDER BY meta_key LIMIT %d" | 1 |
|
| "SELECT ID, post_parent, post_title FROM $wpdb->posts WHERE post_parent = %d AND post_type = 'page' ORDER BY menu_order" | 1 |
|
| 'Select comment' | 1 |
|
| "SELECT count(*) FROM $wpdb->posts WHERE post_type = 'attachment' AND post_status != 'trash' AND post_parent = %d" | 1 |
|
| 'Insert media from another website' | 1 |
|
| 'Update gallery settings' | 1 |
|
| "SELECT DISTINCT YEAR(post_date) AS yyear, MONTH(post_date) AS mmonth FROM $wpdb->posts WHERE post_type = 'attachment' ORDER BY post_date DESC" | 1 |
|
| "UPDATE $wpdb->posts SET post_parent = %d WHERE post_type = 'attachment' AND ID IN ( $ids_string )" | 1 |
|
| "UPDATE $wpdb->posts SET post_parent = 0 WHERE post_type = 'attachment' AND ID IN ( $ids_string )" | 1 |
|
| 'Select bulk action' | 1 |
|
| "SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month FROM $wpdb->posts WHERE post_type = %s $extra_checks ORDER BY post_date DESC" | 1 |
|
| 'SHOW VARIABLES LIKE %s' | 1 |
|
| 'SHOW TABLE STATUS' | 1 |
|
| "SELECT user_id FROM $wpdb->usermeta WHERE meta_key = %s AND meta_value != '0'" | 1 |
|
| "SELECT * FROM $wpdb->users WHERE ID IN ($editable) ORDER BY display_name" | 1 |
|
| "SELECT user_id FROM $wpdb->usermeta WHERE meta_key = %s" | 1 |
|
| "SELECT user_id FROM $wpdb->usermeta WHERE meta_key = %s AND meta_value = '0'" | 1 |
|
| "SELECT DISTINCT($wpdb->users.ID)" . $this->query_from . $this->query_where . $this->query_orderby . $this->query_limit | 1 |
|
| "SELECT COUNT(DISTINCT($wpdb->users.ID))" . $this->query_from . $this->query_where | 1 |
|
| "SELECT ID, post_title, post_author FROM $wpdb->posts WHERE post_type = 'post' AND $type_sql AND post_author IN ($editable) AND post_author != %d ORDER BY post_modified $dir" | 1 |
|
| "SELECT meta_id FROM $wpdb->postmeta WHERE post_id = %d AND meta_key = 'enclosure' AND meta_value LIKE %s" | 1 |
|
| "SELECT post_id FROM $wpdb->postmeta WHERE post_id = %d AND meta_key = 'enclosure' AND meta_value LIKE %s" | 1 |
|
| "SELECT option_value FROM $wpdb->options WHERE option_name = 'siteurl'" | 1 |
|
| "SHOW TABLES LIKE '{$wpdb->blogmeta}'" | 1 |
|
| 'Select a city' | 1 |
|
| "SELECT post_id FROM $wpdb->postmeta WHERE meta_key = '_wp_trash_meta_time' AND meta_value < %d" | 1 |
|
| "SELECT comment_id FROM $wpdb->commentmeta WHERE meta_key = '_wp_trash_meta_time' AND meta_value < %d" | 1 |
|
| 'Update PHP' | 1 |
|
| 'SELECT @@SESSION.sql_mode' | 1 |
|
| "UPDATE `$table` SET $fields WHERE $conditions" | 1 |
|
| "DELETE FROM `$table` WHERE $conditions" | 1 |
|
| "SHOW FULL COLUMNS FROM $table" | 1 |
|
| 'SELECT ' . implode(', ', $sql) | 1 |
|
| " SELECT * FROM $wpdb->posts WHERE post_parent = %d AND post_type = 'revision' AND post_status = 'inherit' AND post_name = %s " . $user_id_query . ' ORDER BY post_date DESC LIMIT 1' | 1 |
|
| "INSERT IGNORE INTO `$wpdb->options` (`option_name`, `option_value`, `autoload`) VALUES (%s, %s, 'no') /* LOCK */" | 1 |
|
| 'Update Link Category' | 1 |
|
| 'Update Pattern Category' | 1 |
|
| "SELECT tr.object_id FROM $wpdb->term_relationships AS tr INNER JOIN $wpdb->term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ($taxonomies) AND tt.term_id IN ($term_ids) ORDER BY tr.object_id $order" | 1 |
|
| "SELECT meta_key, meta_value, meta_id, term_id FROM $wpdb->termmeta WHERE term_id = %d ORDER BY meta_key,meta_id" | 1 |
|
| "SELECT term_id, term_taxonomy_id FROM $wpdb->term_taxonomy WHERE `parent` = " . (int) $term_obj->term_id | 1 |
|
| "SELECT object_id FROM $wpdb->term_relationships WHERE term_taxonomy_id = %d" | 1 |
|
| "SELECT meta_id FROM $wpdb->termmeta WHERE term_id = %d " | 1 |
|
| "SELECT t.term_id, t.slug, tt.term_taxonomy_id, tt.taxonomy FROM $wpdb->terms AS t INNER JOIN $wpdb->term_taxonomy AS tt ON ( tt.term_id = t.term_id ) WHERE t.slug = %s AND tt.parent = %d AND tt.taxonomy = %s AND t.term_id < %d AND tt.term_taxonomy_id != %d" | 1 |
|
| "SELECT term_taxonomy_id FROM $wpdb->term_relationships WHERE object_id = %d AND term_taxonomy_id = %d" | 1 |
|
| "SELECT tt.term_id FROM $wpdb->term_taxonomy AS tt WHERE tt.taxonomy = %s AND tt.term_taxonomy_id IN ($in_delete_tt_ids)" | 1 |
|
| "INSERT INTO $wpdb->term_relationships (object_id, term_taxonomy_id, term_order) VALUES " . implode(',', $values) . ' ON DUPLICATE KEY UPDATE term_order = VALUES(term_order)' | 1 |
|
| "DELETE FROM $wpdb->term_relationships WHERE object_id = %d AND term_taxonomy_id IN ($in_tt_ids)" | 1 |
|
| "SELECT slug FROM $wpdb->terms WHERE slug = %s AND term_id != %d" | 1 |
|
| "SELECT term_id, taxonomy FROM $wpdb->term_taxonomy WHERE term_taxonomy_id IN ($tt_ids)" | 1 |
|
| "SELECT object_id, term_taxonomy_id FROM $wpdb->term_relationships INNER JOIN $wpdb->posts ON object_id = ID WHERE term_taxonomy_id IN (" . implode(',', array_keys($term_ids)) . ") AND post_type IN ('" . implode("', '", $object_types) . "') AND post_status = 'publish'" | 1 |
|
| "SELECT t.*, tt.* FROM $wpdb->terms AS t INNER JOIN $wpdb->term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (%s)" | 1 |
|
| "SELECT COUNT(*) FROM $wpdb->term_relationships, $wpdb->posts p1 WHERE p1.ID = $wpdb->term_relationships.object_id AND ( post_status IN ('" . implode("', '", $post_statuses) . "') OR ( post_status = 'inherit' AND post_parent > 0 AND ( SELECT post_status FROM $wpdb->posts WHERE ID = p1.post_parent ) IN ('" . implode("', '", $post_statuses) . "') ) ) AND post_type = 'attachment' AND term_taxonomy_id = %d" | 1 |
|
| "SELECT COUNT(*) FROM $wpdb->term_relationships, $wpdb->posts WHERE $wpdb->posts.ID = $wpdb->term_relationships.object_id AND post_status IN ('" . implode("', '", $post_statuses) . "') AND post_type IN ('" . implode("', '", $object_types) . "') AND term_taxonomy_id = %d" | 1 |
|
| "SELECT COUNT(*) FROM $wpdb->term_taxonomy tt WHERE tt.term_id = %d AND tt.term_taxonomy_id != %d" | 1 |
|
| "SELECT term_id FROM $wpdb->term_taxonomy WHERE term_taxonomy_id = %d" | 1 |
|
| "SELECT t.* FROM $wpdb->terms t WHERE t.term_id = %d" | 1 |
|
| "SELECT * FROM $wpdb->term_taxonomy WHERE term_taxonomy_id = %d" | 1 |
|
| "SELECT term_taxonomy_id FROM $wpdb->term_taxonomy WHERE parent = %d AND taxonomy = %s" | 1 |
|
| "SELECT taxonomy FROM $wpdb->term_taxonomy WHERE term_id = %d" | 1 |
|
| "SELECT tt.term_id, t.*, count(*) as term_tt_count FROM {$wpdb->term_taxonomy} tt LEFT JOIN {$wpdb->terms} t ON t.term_id = tt.term_id GROUP BY t.term_id HAVING term_tt_count > 1 LIMIT 1" | 1 |
|
| "SELECT tt.term_id, t.*, count(*) as term_tt_count FROM {$wpdb->term_taxonomy} tt LEFT JOIN {$wpdb->terms} t ON t.term_id = tt.term_id GROUP BY t.term_id HAVING term_tt_count > 1 LIMIT 10" | 1 |
|
| "SELECT * FROM {$wpdb->term_taxonomy} WHERE `term_id` IN ({$shared_term_ids})" | 1 |
|
| "SELECT m1.post_id FROM {$wpdb->postmeta} AS m1 INNER JOIN {$wpdb->postmeta} AS m2 ON ( m2.post_id = m1.post_id ) INNER JOIN {$wpdb->postmeta} AS m3 ON ( m3.post_id = m1.post_id ) WHERE ( m1.meta_key = '_menu_item_type' AND m1.meta_value = 'taxonomy' ) AND ( m2.meta_key = '_menu_item_object' AND m2.meta_value = %s ) AND ( m3.meta_key = '_menu_item_object_id' AND m3.meta_value = %d )" | 1 |
|
| "UPDATE $wpdb->posts SET post_author = %d WHERE post_author = %d" | 1 |
|
| "UPDATE $wpdb->links SET link_owner = %d WHERE link_owner = %d" | 1 |
|
| "SELECT * FROM $wpdb->signups WHERE user_login = %s" | 1 |
|
| "SELECT * FROM $wpdb->signups WHERE user_email = %s" | 1 |
|
| 'SELECT post_name FROM ' . $wpdb->get_blog_prefix($current_network->site_id) . "posts WHERE post_type = 'page' AND post_name = %s" | 1 |
|
| "SELECT * FROM $wpdb->signups WHERE domain = %s AND path = %s" | 1 |
|
| "SELECT * FROM $wpdb->signups WHERE activation_key = %s" | 1 |
|
| "SELECT ID, post_date_gmt FROM {$prefix}posts WHERE post_author = %d AND post_type = 'post' AND post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1" | 1 |
|
| "SELECT COUNT(ID) FROM {$wpdb->posts} WHERE post_status = 'publish' and post_type = 'post'" | 1 |
|
| 'Insert into template' | 1 |
|
| 'Insert into template part' | 1 |
|
| 'Insert into Navigation Menu' | 1 |
|
| "SELECT post_status, COUNT( * ) AS num_posts FROM {$wpdb->posts} WHERE post_type = %s" | 1 |
|
| "SELECT post_mime_type, COUNT( * ) AS num_posts FROM $wpdb->posts WHERE post_type = 'attachment' AND post_status != 'trash' $and GROUP BY post_mime_type" | 1 |
|
| "SELECT COUNT( * ) FROM $wpdb->posts WHERE post_type = 'attachment' AND post_status = 'trash' $and" | 1 |
|
| "SELECT * FROM $wpdb->posts WHERE post_parent = %d AND post_type = %s" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE post_parent = %d AND post_type = 'revision'" | 1 |
|
| "SELECT comment_ID, comment_approved FROM $wpdb->comments WHERE comment_post_ID = %d" | 1 |
|
| "UPDATE $wpdb->comments SET comment_approved = %s WHERE comment_ID IN ($comments_in)" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE ID = %d" | 1 |
|
| "SELECT post_name FROM $wpdb->posts WHERE post_name = %s AND ID != %d LIMIT 1" | 1 |
|
| "SELECT post_name FROM $wpdb->posts WHERE post_name = %s AND post_type IN ( %s, 'attachment' ) AND ID != %d AND post_parent = %d LIMIT 1" | 1 |
|
| "SELECT post_name FROM $wpdb->posts WHERE post_name = %s AND post_type = %s AND ID != %d LIMIT 1" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE post_type = 'page'" | 1 |
|
| " SELECT ID, post_name, post_parent, post_type FROM $wpdb->posts WHERE post_name IN ($in_string) AND post_type IN ($post_type_in_string) " | 1 |
|
| "SELECT meta_id FROM $wpdb->postmeta WHERE meta_key = '_wp_attachment_metadata' AND meta_value LIKE %s AND post_id <> %d" | 1 |
|
| "SELECT post_{$field}_gmt FROM $wpdb->posts WHERE post_status = 'publish' AND post_type IN ({$post_types}) ORDER BY post_{$field}_gmt DESC LIMIT 1" | 1 |
|
| "SELECT post_{$field} FROM $wpdb->posts WHERE post_status = 'publish' AND post_type IN ({$post_types}) ORDER BY post_{$field}_gmt DESC LIMIT 1" | 1 |
|
| "SELECT DATE_ADD(post_{$field}_gmt, INTERVAL '$add_seconds_server' SECOND) FROM $wpdb->posts WHERE post_status = 'publish' AND post_type IN ({$post_types}) ORDER BY post_{$field}_gmt DESC LIMIT 1" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE post_status = 'auto-draft' AND DATE_SUB( NOW(), INTERVAL 7 DAY ) > post_date" | 1 |
|
| "SELECT $wpdb->posts.* FROM $wpdb->posts WHERE ID IN (%s)" | 1 |
|
| "SELECT $wpdb->posts.ID, $wpdb->posts.post_parent FROM $wpdb->posts WHERE ID IN (%s)" | 1 |
|
| "SELECT DISTINCT post_mime_type FROM $wpdb->posts WHERE post_type = %s" | 1 |
|
| "SELECT $distinct $fields" | 1 |
|
| "SELECT ID, post_name, post_parent FROM $wpdb->posts WHERE post_type = 'page' AND post_status != 'auto-draft'" | 1 |
|
| "SELECT ID, post_name, post_parent FROM $wpdb->posts WHERE post_type = 'attachment' AND post_parent = %d" | 1 |
|
| "SELECT post_type, post_parent FROM $wpdb->posts WHERE ID = %d" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE $wpdb->posts.post_author = %d AND $wpdb->posts.post_status = 'publish' LIMIT 1" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE $where AND post_status IN ('" . implode("', '", esc_sql($publicly_viewable_statuses)) . "')" | 1 |
|
| "SELECT option_name, option_value FROM $wpdb->options WHERE option_name IN (%s)" | 1 |
|
| "SELECT option_name FROM $wpdb->options $where" | 1 |
|
| "UPDATE $wpdb->options SET autoload = %s WHERE option_name IN (" . implode(',', array_fill(0, count($grouped_options[$autoload]), '%s')) . ')' | 1 |
|
| "SELECT option_name, option_value FROM $wpdb->options WHERE autoload = 'yes'" | 1 |
|
| "SELECT meta_key, meta_value FROM $wpdb->sitemeta WHERE meta_key IN ($core_options_in) AND site_id = %d" | 1 |
|
| "INSERT INTO `$wpdb->options` (`option_name`, `option_value`, `autoload`) VALUES (%s, %s, %s) ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)" | 1 |
|
| "SELECT autoload FROM $wpdb->options WHERE option_name = %s" | 1 |
|
| "DELETE a, b FROM {$wpdb->options} a, {$wpdb->options} b WHERE a.option_name LIKE %s AND a.option_name NOT LIKE %s AND b.option_name = CONCAT( '_transient_timeout_', SUBSTRING( a.option_name, 12 ) ) AND b.option_value < %d" | 1 |
|
| "DELETE a, b FROM {$wpdb->options} a, {$wpdb->options} b WHERE a.option_name LIKE %s AND a.option_name NOT LIKE %s AND b.option_name = CONCAT( '_site_transient_timeout_', SUBSTRING( a.option_name, 17 ) ) AND b.option_value < %d" | 1 |
|
| "DELETE a, b FROM {$wpdb->sitemeta} a, {$wpdb->sitemeta} b WHERE a.meta_key LIKE %s AND a.meta_key NOT LIKE %s AND b.meta_key = CONCAT( '_site_transient_timeout_', SUBSTRING( a.meta_key, 17 ) ) AND b.meta_value < %d" | 1 |
|
| "SELECT meta_value FROM $wpdb->sitemeta WHERE meta_key = %s AND site_id = %d" | 1 |
|
| "SELECT meta_id FROM {$wpdb->sitemeta} WHERE meta_key = %s AND site_id = %d" | 1 |
|
| " SELECT ID page_id, post_title page_title, post_parent page_parent_id, post_date_gmt, post_date, post_status FROM {$wpdb->posts} WHERE post_type = 'page' ORDER BY ID " | 1 |
|
| "SELECT ID, guid FROM {$wpdb->posts} WHERE post_parent = '0' AND post_type = 'attachment'" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE post_title RLIKE %s" | 1 |
|
| "SELECT COUNT(*) FROM $wpdb->posts $where" | 1 |
|
| "SELECT post_author, COUNT(*) FROM $wpdb->posts $where AND post_author IN ($userlist) GROUP BY post_author" | 1 |
|
| " SELECT {$select_count}, COUNT(*) FROM {$wpdb->usermeta} INNER JOIN {$wpdb->users} ON user_id = ID WHERE meta_key = '{$blog_prefix}capabilities' " | 1 |
|
| " SELECT meta_value FROM {$wpdb->usermeta} INNER JOIN {$wpdb->users} ON user_id = ID WHERE meta_key = '{$blog_prefix}capabilities' " | 1 |
|
| "SELECT COUNT(ID) as c FROM $wpdb->users" | 1 |
|
| "SELECT user_id FROM $wpdb->usermeta WHERE meta_key = '{$prefix}capabilities' AND meta_value NOT REGEXP %s" | 1 |
|
| "SELECT domain FROM $wpdb->blogs WHERE domain = %s LIMIT 1" | 1 |
|
| "SELECT COUNT(*) FROM $table WHERE meta_key = %s AND $column = %d" | 1 |
|
| "SELECT $id_column FROM $table WHERE meta_key = %s AND $column = %d" | 1 |
|
| "SELECT $id_column FROM $table WHERE meta_key = %s" | 1 |
|
| "SELECT $type_column FROM $table WHERE meta_key = %s AND meta_value = %s" | 1 |
|
| "SELECT $type_column FROM $table WHERE meta_key = %s" | 1 |
|
| "DELETE FROM $table WHERE $id_column IN( " . implode(',', $meta_ids) . ' )' | 1 |
|
| "SELECT * FROM $table WHERE $id_column = %d" | 1 |
|
| "SELECT $column, meta_key, meta_value FROM $table WHERE $column IN ($id_list) ORDER BY $id_column ASC" | 1 |
|
| "SELECT meta_id FROM $wpdb->blogmeta WHERE blog_id = %d " | 1 |
|
| "SELECT * FROM $wpdb->blogs WHERE blog_id IN (%s)" | 1 |
|
| "SELECT * FROM $wpdb->blogs WHERE domain IN (%s,%s) AND path = %s ORDER BY CHAR_LENGTH(domain) DESC" | 1 |
|
| "SELECT * FROM $wpdb->blogs WHERE domain = %s AND path = %s" | 1 |
|
| "SELECT * FROM $wpdb->blogs WHERE domain IN (%s,%s) ORDER BY CHAR_LENGTH(domain) DESC" | 1 |
|
| "SELECT * FROM $wpdb->blogs WHERE domain = %s" | 1 |
|
| "SELECT %s FROM {$wpdb->blogs} WHERE blog_id = %d" | 1 |
|
| "SELECT blog_id, domain, path FROM $wpdb->blogs WHERE site_id = %d AND public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' AND last_updated != '0000-00-00 00:00:00' ORDER BY last_updated DESC limit %d, %d" | 1 |
|
| "SELECT * FROM {$wpdb->blogs} WHERE blog_id = %d LIMIT 1" | 1 |
|
| "SELECT blog_id, domain, path FROM $wpdb->blogs WHERE site_id = %d AND public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' ORDER BY registered DESC" | 1 |
|
| "SELECT COUNT(ID) FROM " . $wpdb->get_blog_prefix($details['blog_id']) . "posts WHERE post_status='publish' AND post_type='post'" | 1 |
|
| "SELECT u.ID, u.user_login, u.user_pass FROM $wpdb->users AS u, $wpdb->sitemeta AS sm WHERE sm.meta_key = 'admin_user_id' AND u.ID = sm.meta_value AND sm.site_id = %d" | 1 |
|
| "SELECT $wpdb->site.* FROM $wpdb->site WHERE id IN (%s)" | 1 |
|
| "SELECT p.ID FROM $wpdb->posts AS p $join $where $sort" | 1 |
|
| "SELECT 1 FROM $wpdb->postmeta $subquery_alias " | 1 |
|
| "SELECT * FROM $wpdb->links WHERE link_id = %d LIMIT 1" | 1 |
|
| "SELECT * $length $recently_updated_test $get_updated FROM $wpdb->links $join WHERE 1=1 $visible $category_query" | 1 |
|
| "SELECT comment_approved FROM $wpdb->comments WHERE user_id = %d AND comment_approved = '1' LIMIT 1" | 1 |
|
| "SELECT comment_approved FROM $wpdb->comments WHERE comment_author = %s AND comment_author_email = %s and comment_approved = '1' LIMIT 1" | 1 |
|
| "SELECT comment_date_gmt FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1" | 1 |
|
| "SELECT comment_date FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1" | 1 |
|
| "SELECT DATE_ADD(comment_date_gmt, INTERVAL %s SECOND) FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1" | 1 |
|
| "SELECT comment_ID FROM $wpdb->comments WHERE comment_post_ID = %d AND comment_parent = %s AND comment_approved != 'trash' AND ( comment_author = %s " | 1 |
|
| "SELECT post_author FROM $wpdb->posts WHERE ID = %d LIMIT 1" | 1 |
|
| "SELECT `comment_date_gmt` FROM `$wpdb->comments` WHERE `comment_date_gmt` >= %s AND ( $check_column = %s OR `comment_author_email` = %s ) ORDER BY `comment_date_gmt` DESC LIMIT 1" | 1 |
|
| "SELECT comment_ID FROM $wpdb->comments WHERE comment_parent = %d" | 1 |
|
| "SELECT meta_id FROM $wpdb->commentmeta WHERE comment_id = %d" | 1 |
|
| "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_post_ID = %d AND comment_approved = '1'" | 1 |
|
| "UPDATE $wpdb->posts SET to_ping = TRIM(REPLACE(to_ping, %s, '')) WHERE ID = %d" | 1 |
|
| "UPDATE $wpdb->posts SET pinged = CONCAT(pinged, '\n', %s) WHERE ID = %d" | 1 |
|
| "UPDATE $wpdb->posts SET to_ping = TRIM(REPLACE(to_ping, %s, '')) WHERE ID = %d" | 1 |
|
| "SELECT $wpdb->comments.* FROM $wpdb->comments WHERE comment_ID IN (%s)" | 1 |
|
| "SELECT comment_ID FROM $wpdb->comments WHERE comment_type = '' LIMIT 1" | 1 |
|
| "SELECT comment_ID FROM {$wpdb->comments} WHERE comment_type = '' ORDER BY comment_ID DESC LIMIT %d" | 1 |
|
| "UPDATE {$wpdb->comments} SET comment_type = 'comment' WHERE comment_type = '' AND comment_ID IN ({$comment_id_list})" | 1 |
|
| 'Show Video List' | 1 |
|
| 'Show Tracklist' | 1 |
|
| 'Show Artist Name in Tracklist' | 1 |
|
| 'Show Images' | 1 |
|
| "SELECT * FROM $wpdb->comments WHERE comment_ID = %d LIMIT 1" | 1 |
|
| "SELECT * FROM $wpdb->posts WHERE ID = %d LIMIT 1" | 1 |
|
| "SELECT * FROM $wpdb->users WHERE ID IN ($list)" | 1 |
|
| "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '0'" | 1 |
|
| "SELECT * FROM {$wpdb->site} WHERE id = %d LIMIT 1" | 1 |
|
| "SELECT post_id FROM $wpdb->postmeta, $wpdb->posts WHERE ID = post_id AND post_type = %s AND meta_key = '_wp_old_slug' AND meta_value = %s" | 1 |
|
| "SELECT post_id FROM $wpdb->postmeta AS pm_date, $wpdb->posts WHERE ID = post_id AND post_type = %s AND meta_key = '_wp_old_date' AND post_name = %s" . $date_query | 1 |
|
| "SELECT ID FROM $wpdb->posts, $wpdb->postmeta AS pm_slug, $wpdb->postmeta AS pm_date WHERE ID = pm_slug.post_id AND ID = pm_date.post_id AND post_type = %s AND pm_slug.meta_key = '_wp_old_slug' AND pm_slug.meta_value = %s AND pm_date.meta_key = '_wp_old_date'" . $date_query | 1 |
|
| "SELECT $distinct {$wpdb->comments}.comment_ID FROM {$wpdb->comments} $cjoin $cwhere $cgroupby $corderby $climits" | 1 |
|
| " SELECT $found_rows $distinct $fields FROM {$wpdb->posts} $join WHERE 1=1 $where $groupby $orderby $limits " | 1 |
|
| " SELECT $found_rows $distinct {$wpdb->posts}.ID FROM {$wpdb->posts} $join WHERE 1=1 $where $groupby $orderby $limits " | 1 |
|
| "SELECT {$wpdb->comments}.comment_ID FROM {$wpdb->comments} $cjoin $cwhere $cgroupby $corderby $climits" | 1 |
|
| "SELECT t.*, tt.* FROM $wpdb->terms AS t INNER JOIN $wpdb->term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = %d" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE post_type = 'attachment' AND post_mime_type LIKE 'audio%' LIMIT 1" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE post_type = 'attachment' AND post_mime_type LIKE 'video%' LIMIT 1" | 1 |
|
| "SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month FROM $wpdb->posts WHERE post_type = %s ORDER BY post_date DESC" | 1 |
|
| 'Insert from URL' | 1 |
|
| 'Update gallery' | 1 |
|
| 'Select and crop' | 1 |
|
| 'Select poster image' | 1 |
|
| 'Insert audio playlist' | 1 |
|
| 'Update audio playlist' | 1 |
|
| 'Insert video playlist' | 1 |
|
| 'Update video playlist' | 1 |
|
| "SELECT post_id, meta_value FROM $wpdb->postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = %s" | 1 |
|
| 'Select an area to move this widget into:' | 1 |
|
| 'Update Tag' | 1 |
|
| 'Update Category' | 1 |
|
| 'Insert into post' | 1 |
|
| 'Insert into page' | 1 |
|
| "SELECT * FROM $wpdb->users WHERE $db_field = %s LIMIT 1" | 1 |
|
| " SELECT {$this->query_fields} {$this->query_from} {$this->query_where} {$this->query_orderby} {$this->query_limit} " | 1 |
|
| 'Show Controls' | 1 |
|
| "SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM $wpdb->posts $join $where GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date $order $limit" | 1 |
|
| "SELECT YEAR(post_date) AS `year`, count(ID) as posts FROM $wpdb->posts $join $where GROUP BY YEAR(post_date) ORDER BY post_date $order $limit" | 1 |
|
| "SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, DAYOFMONTH(post_date) AS `dayofmonth`, count(ID) as posts FROM $wpdb->posts $join $where GROUP BY YEAR(post_date), MONTH(post_date), DAYOFMONTH(post_date) ORDER BY post_date $order $limit" | 1 |
|
| "SELECT DISTINCT $week AS `week`, YEAR( `post_date` ) AS `yr`, DATE_FORMAT( `post_date`, '%Y-%m-%d' ) AS `yyyymmdd`, count( `ID` ) AS `posts` FROM `$wpdb->posts` $join $where GROUP BY $week, YEAR( `post_date` ) ORDER BY `post_date` $order $limit" | 1 |
|
| "SELECT * FROM $wpdb->posts $join $where ORDER BY $orderby $limit" | 1 |
|
| "SELECT 1 as test FROM $wpdb->posts WHERE post_type = 'post' AND post_status = 'publish' LIMIT 1" | 1 |
|
| "SELECT DATE_FORMAT((DATE_ADD('{$thisyear}0101', INTERVAL $d DAY) ), '%m')" | 1 |
|
| "SELECT MONTH(post_date) AS month, YEAR(post_date) AS year FROM $wpdb->posts WHERE post_date < '$thisyear-$thismonth-01' AND post_type = 'post' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1" | 1 |
|
| "SELECT MONTH(post_date) AS month, YEAR(post_date) AS year FROM $wpdb->posts WHERE post_date > '$thisyear-$thismonth-{$last_day} 23:59:59' AND post_type = 'post' AND post_status = 'publish' ORDER BY post_date ASC LIMIT 1" | 1 |
|
| "SELECT DISTINCT DAYOFMONTH(post_date) FROM $wpdb->posts WHERE post_date >= '{$thisyear}-{$thismonth}-01 00:00:00' AND post_type = 'post' AND post_status = 'publish' AND post_date <= '{$thisyear}-{$thismonth}-{$last_day} 23:59:59'" | 1 |
|
| "DELETE FROM $wpdb->usermeta WHERE user_id = %d AND meta_key = %s AND meta_value = %s" | 1 |
|
| "DELETE FROM $wpdb->usermeta WHERE user_id = %d AND meta_key = %s" | 1 |
|
| "SELECT meta_value FROM $wpdb->usermeta WHERE user_id = %d AND meta_key = %s" | 1 |
|
| "SELECT meta_value FROM $wpdb->usermeta WHERE user_id = %d" | 1 |
|
| "SELECT user_id, user_id AS ID, user_login, display_name, user_email, meta_value FROM $wpdb->users, $wpdb->usermeta WHERE {$wpdb->users}.ID = {$wpdb->usermeta}.user_id AND meta_key = '{$blog_prefix}capabilities' ORDER BY {$wpdb->usermeta}.user_id" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE post_title = %s AND post_type IN ($post_type_in_string)" | 1 |
|
| "SELECT ID FROM $wpdb->posts WHERE post_title = %s AND post_type = %s" | 1 |
|
| "SELECT DISTINCT post_author, COUNT(ID) AS count FROM $wpdb->posts WHERE " . get_private_posts_cap_sql('post') . ' GROUP BY post_author' | 1 |
|
| "SELECT DISTINCT post_author FROM $wpdb->posts WHERE post_type = 'post' AND post_status = 'publish' LIMIT 2" | 1 |
|
| "SELECT 1 as test FROM {$wpdb->posts} WHERE post_type = 'post' AND post_status = 'publish' LIMIT 1" | 1 |
|
| 'Insert an image to make a visual statement.' | 1 |
|
| 'Show login & logout links.' | 1 |
|
| 'Show a block pattern.' | 1 |
|
| 'Insert additional custom elements with a WordPress shortcode.' | 1 |
|
| 'Insert poetry. Use special spacing formats. Or quote song lyrics.' | 1 |
|
| 'DELETE i, cd FROM `' . $this->options['extras']['prefix'] . 'cache_data` cd, ' . '`' . $this->options['extras']['prefix'] . 'items` i ' . 'WHERE cd.id = i.feed_id ' . 'AND cd.mtime < (unix_timestamp() - :purge_time)' | 1 |
|
| 'SELECT COUNT(*) FROM `' . $this->options['extras']['prefix'] . 'cache_data` WHERE `id` = :feed' | 1 |
|
| 'UPDATE `' . $this->options['extras']['prefix'] . 'cache_data` SET `items` = :items, `data` = :data, `mtime` = :time WHERE `id` = :feed' | 1 |
|
| 'UPDATE `' . $this->options['extras']['prefix'] . 'cache_data` SET `data` = :data, `mtime` = :time WHERE `id` = :feed' | 1 |
|
| 'INSERT INTO `' . $this->options['extras']['prefix'] . 'cache_data` (`id`, `items`, `data`, `mtime`) VALUES(:feed, :count, :data, :time)' | 1 |
|
| 'SELECT `id` FROM `' . $this->options['extras']['prefix'] . 'items` WHERE `id` = ' . implode(' OR `id` = ', $database_ids) . ' AND `feed_id` = :feed' | 1 |
|
| 'INSERT INTO `' . $this->options['extras']['prefix'] . 'items` (`feed_id`, `id`, `data`, `posted`) VALUES(:feed, :id, :data, :date)' | 1 |
|
| 'SELECT `id` FROM `' . $this->options['extras']['prefix'] . 'cache_data` WHERE `id` = :feed' | 1 |
|
| 'UPDATE `' . $this->options['extras']['prefix'] . 'cache_data` SET `items` = 0, `data` = :data, `mtime` = :time WHERE `id` = :feed' | 1 |
|
| 'INSERT INTO `' . $this->options['extras']['prefix'] . 'cache_data` (`id`, `items`, `data`, `mtime`) VALUES(:id, 0, :data, :time)' | 1 |
|
| 'SELECT `items`, `data` FROM `' . $this->options['extras']['prefix'] . 'cache_data` WHERE `id` = :id' | 1 |
|
| 'SELECT `data` FROM `' . $this->options['extras']['prefix'] . 'items` WHERE `feed_id` = :feed ORDER BY `posted` DESC' | 1 |
|
| 'SELECT `mtime` FROM `' . $this->options['extras']['prefix'] . 'cache_data` WHERE `id` = :id' | 1 |
|
| 'UPDATE `' . $this->options['extras']['prefix'] . 'cache_data` SET `mtime` = :time WHERE `id` = :id' | 1 |
|
| 'DELETE FROM `' . $this->options['extras']['prefix'] . 'cache_data` WHERE `id` = :id' | 1 |
|
| 'DELETE FROM `' . $this->options['extras']['prefix'] . 'items` WHERE `feed_id` = :id' | 1 |
|
| 'Show tag counts' | 1 |
|
| 'Select Link Category:' | 1 |
|
| 'Show Link Image' | 1 |
|
| 'Show Link Name' | 1 |
|
| 'Show Link Description' | 1 |
|
| 'Show Link Rating' | 1 |
|
| 'Show hierarchy' | 1 |
|
| 'Select Menu:' | 1 |
|
| 'Select site icon' | 1 |
|
| 'Update now' | 1 |
|
| 'Select pages to feature in each area from the dropdowns. Add an image to a section by setting a featured image in the page editor. Empty sections will not be displayed.' | 1 |
|
| 'Select a Color' | 1 |
|
| 'Show search in header' | 1 |
|
| 'Show author bio' | 1 |
|
| "SELECT * FROM $wpdb->comments WHERE comment_post_ID = %d AND comment_author_url = %s" | 2 |
|
| 'Show password' | 2 |
|
| 'Update Plugin' | 2 |
|
| 'Update Theme' | 2 |
|
| 'Show previous theme' | 2 |
|
| 'Show next theme' | 2 |
|
| 'Update Available' | 2 |
|
| 'Update Incompatible' | 2 |
|
| 'Update File' | 2 |
|
| 'Delete this comment permanently' | 2 |
|
| 'Delete Menu' | 2 |
|
| 'Update Link' | 2 |
|
| 'Show hidden updates' | 2 |
|
| 'Delete Site' | 2 |
|
| 'Update Services' | 2 |
|
| 'Delete all content.' | 2 |
|
| 'Update anyway, even though it might break your site?' | 2 |
|
| 'Update URI' | 2 |
|
| "SELECT user_login FROM {$wpdb->signups} WHERE user_login = %s" | 2 |
|
| "UPDATE {$wpdb->signups} SET user_email = %s WHERE user_login = %s" | 2 |
|
| "SELECT umeta_id FROM $wpdb->usermeta WHERE user_id = %d" | 2 |
|
| 'SELECT VERSION()' | 2 |
|
| 'Update your site to use HTTPS' | 2 |
|
| "DELETE FROM $wpdb->usermeta WHERE user_id != %d AND meta_key = %s" | 2 |
|
| "SELECT term_id, term_group FROM $wpdb->terms WHERE slug = %s" | 2 |
|
| "INSERT INTO $wpdb->term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( %d, %s, %s, %d, %d)" | 2 |
|
| "SELECT COUNT(*) FROM $wpdb->term_relationships WHERE term_taxonomy_id = %d" | 2 |
|
| "SELECT link_id FROM $wpdb->links LIMIT 1" | 2 |
|
| "SHOW TABLES LIKE '{$tables['sitecategories']}'" | 2 |
|
| "SELECT option_name, option_value FROM $wpdb->options" | 2 |
|
| 'Select Image' | 2 |
|
| 'Delete “%s” permanently' | 2 |
|
| 'Select Files' | 2 |
|
| 'Insert gallery' | 2 |
|
| "SELECT COUNT(*) FROM $wpdb->term_taxonomy WHERE term_id = %d" | 2 |
|
| "SELECT MAX(term_group) FROM $wpdb->terms" | 2 |
|
| "SELECT tt.term_taxonomy_id FROM $wpdb->term_taxonomy AS tt INNER JOIN $wpdb->terms AS t ON tt.term_id = t.term_id WHERE tt.taxonomy = %s AND t.term_id = %d" | 2 |
|
| 'Select all' | 2 |
|
| 'Insert date/time' | 2 |
|
| 'Insert video' | 2 |
|
| 'Insert table' | 2 |
|
| 'Delete table' | 2 |
|
| 'Insert row before' | 2 |
|
| 'Insert row after' | 2 |
|
| 'Insert column before' | 2 |
|
| 'Insert column after' | 2 |
|
| 'Delete row' | 2 |
|
| 'Delete column' | 2 |
|
| 'Insert template' | 2 |
|
| 'Show blocks' | 2 |
|
| 'Show invisible characters' | 2 |
|
| 'Insert Page Break tag' | 2 |
|
| "SELECT * FROM $wpdb->posts WHERE ID = %d" | 2 |
|
| "SELECT comment_ID FROM $wpdb->comments WHERE comment_post_ID = %d ORDER BY comment_ID DESC" | 2 |
|
| "SELECT meta_id FROM $wpdb->postmeta WHERE post_id = %d " | 2 |
|
| 'Select logo' | 2 |
|
| "SELECT comment_author_url, comment_content, comment_author_IP, comment_type FROM $wpdb->comments WHERE comment_post_ID = %d" | 2 |
|
| "SELECT ID FROM $wpdb->users WHERE user_nicename = %s AND user_login != %s LIMIT 1" | 2 |
|
| 'Delete it: %s' | 2 |
|
| "SELECT * FROM $wpdb->usermeta WHERE user_id = %d AND meta_key = %s" | 2 |
|
| 'Select Year' | 2 |
|
| 'Select Month' | 2 |
|
| 'Select Day' | 2 |
|
| 'Select Week' | 2 |
|
| 'Select Post' | 2 |
|
| 'Select Category' | 2 |
|
| 'Show post counts' | 2 |
|
| 'Select video' | 2 |
|
| 'Select audio' | 2 |
|
| 'Select image' | 2 |
|
| 'Select file' | 2 |
|
| 'Show sub menu' | 2 |
|
| "SELECT option_value FROM $wpdb->options WHERE option_name = %s LIMIT 1" | 3 |
|
| 'SHOW TABLES' | 3 |
|
| 'Update to version %s' | 3 |
|
| 'Update Translations' | 3 |
|
| 'Update progress' | 3 |
|
| "SELECT ID FROM $wpdb->posts WHERE post_author = %d" | 3 |
|
| "INSERT IGNORE INTO `$wpdb->options` ( `option_name`, `option_value`, `autoload` ) VALUES (%s, %s, 'no') /* LOCK */" | 3 |
|
| "SELECT slug FROM $wpdb->terms WHERE slug = %s" | 3 |
|
| 'Insert into Post' | 3 |
|
| "SELECT $found_rows $fields" | 3 |
|
| 'Insert image' | 3 |
|
| 'Insert link' | 3 |
|
| 'Insert Read More tag' | 3 |
|
| 'SHOW TABLES LIKE %s' | 4 |
|
| 'Delete %s' | 4 |
|
| 'Update package not available.' | 4 |
|
| 'Update %s now' | 4 |
|
| "SELECT link_id FROM $wpdb->links WHERE link_owner = %d" | 4 |
|
| 'Update Available <span class="count">(%s)</span>' | 4 |
|
| 'Update Plugins' | 5 |
|
| 'Update Themes' | 5 |
|
| 'Show more details' | 5 |
|
| 'SELECT FOUND_ROWS()' | 5 |
|
| 'Delete Permanently' | 6 |
|
| 'Select All' | 7 |
|
| 'Delete permanently' | 9 |
|
| 'Select %s' | 12 |
|