~/bugzilla-5.0.2 grep -rF ' WHERE ' Bugzilla
Bugzilla/Memcached.pm: $dbh->do("UPDATE profiles SET request_count=10 WHERE login_name=?", undef, $login);
Bugzilla/Memcached.pm: $dbh->do("UPDATE profiles SET last_activity_ts=? WHERE userid=?",
Bugzilla/Search.pm:# SELECT blah FROM blah WHERE ( (a1 OR a2)AND(b1 OR b2 OR b3)AND(c1)) AND (d1)
Bugzilla/Search.pm: WHERE $where
Bugzilla/Search.pm:# Internal Accessors: WHERE #
Bugzilla/Search.pm:# Note: There's also quite a bit of stuff that affects the WHERE clause
Bugzilla/Search.pm:# The terms that are always in the WHERE clause. These implement bug
Bugzilla/Search.pm: return "$outer $not IN (SELECT DISTINCT $inner FROM $table WHERE $cond)";
Bugzilla/Search.pm: my $q = "SELECT DISTINCT $inner FROM $table WHERE $cond";
Bugzilla/Search.pm: # Create search terms to add to the SELECT and WHERE clauses.
Bugzilla/Search.pm: # The term to use in the WHERE clause.
Bugzilla/Search.pm: WHERE bugs_$chart_id.bug_id = $bugs_table.bug_id
Bugzilla/Product.pm: WHERE product_id = ? AND group_id = ?',
Bugzilla/Product.pm: WHERE product_id = ? AND group_id = ?",
Bugzilla/Product.pm: WHERE product_id = ?
Bugzilla/Product.pm: WHERE product_id = ? AND group_id = ?',
Bugzilla/Product.pm: $dbh->do('DELETE FROM bug_group_map WHERE group_id = ? AND ' .
Bugzilla/Product.pm: WHERE series_categories.name = ?',
Bugzilla/Product.pm: $dbh->do('DELETE FROM series WHERE ' . $dbh->sql_in('series_id', $series_ids));
Bugzilla/Product.pm: WHERE series_categories.name = ? ' .
Bugzilla/Product.pm: $dbh->do('DELETE FROM series_categories WHERE name = ?', undef, $self->name);
Bugzilla/Product.pm: WHERE product_id = ?
Bugzilla/Product.pm: WHERE bugs.product_id = ? ' .
Bugzilla/Product.pm: WHERE isbuggroup = 1 AND isactive = 1 AND product_id = ?
Bugzilla/Product.pm: WHERE isbuggroup = 1 AND isactive = 1 AND product_id = ?
Bugzilla/Product.pm: WHERE product_id = ? AND isactive = 1
Bugzilla/Product.pm: WHERE product_id = ? AND isbuggroup = 1
Bugzilla/Product.pm: WHERE product_id = ?}, undef, $self->id);
Bugzilla/Product.pm: WHERE product_id = ?}, undef, $self->id);
Bugzilla/Product.pm: WHERE product_id = ?}, undef, $self->id);
Bugzilla/Product.pm: WHERE product_id = ?},
Bugzilla/Product.pm: WHERE products.id = ? ' . Bugzilla->dbh->sql_limit(1),
Bugzilla/Series.pm: WHERE series_id = $self->{'series_id'}");
Bugzilla/Series.pm: "FROM series WHERE category = $category_id " .
Bugzilla/Series.pm: $dbh->do('DELETE FROM series WHERE series_id = ?', undef, $self->id);
Bugzilla/Field/Choice.pm: $dbh->do("UPDATE bug_$fname SET value = ? WHERE value = ?",
Bugzilla/Field/Choice.pm: $dbh->do("UPDATE bugs SET $fname = ? WHERE $fname = ?",
Bugzilla/Field/ChoiceInterface.pm: WHERE value = ?", undef, $self->name);
Bugzilla/Field/ChoiceInterface.pm: WHERE $fname = ?",
Bugzilla/Field/ChoiceInterface.pm: WHERE value_id = ? AND visibility_field_id = ?", undef,
Bugzilla/Attachment.pm: WHERE id = ?",
Bugzilla/Attachment.pm: WHERE id = ?",
Bugzilla/Attachment.pm: WHERE bug_id = ? $and_restriction",
Bugzilla/Attachment.pm: WHERE bug_id = ?',
Bugzilla/Attachment.pm: $dbh->do('UPDATE attachments SET modification_time = ? WHERE attach_id = ?',
Bugzilla/Attachment.pm: $dbh->do('UPDATE bugs SET delta_ts = ? WHERE bug_id = ?',
Bugzilla/Attachment.pm: 'SELECT id FROM flags WHERE attach_id = ?', undef, $self->id);
Bugzilla/Attachment.pm: $dbh->do('DELETE FROM flags WHERE ' . $dbh->sql_in('id', $flag_ids))
Bugzilla/Attachment.pm: $dbh->do('DELETE FROM attach_data WHERE id = ?', undef, $self->id);
Bugzilla/Attachment.pm: WHERE attach_id = ?', undef, ('text/plain', 0, 1, $self->id));
Bugzilla/Field.pm: WHERE field_id = ?", undef, $self->id);
Bugzilla/Field.pm: WHERE fieldid = ?", undef, $self->id);
Bugzilla/Field.pm: $bugs_query = "SELECT COUNT(*) FROM bugs WHERE $name IS NOT NULL";
Bugzilla/Field.pm: $dbh->do('UPDATE fielddefs SET obsolete = 0 WHERE id = ?', undef, $field->id)
Bugzilla/Field.pm: $dbh->do("DELETE FROM field_visibility WHERE field_id = ?",
Bugzilla/Field.pm: WHERE isactive = ?
Bugzilla/Field.pm: $dbh->do("DELETE FROM fielddefs WHERE name='cc_accessible'");
Bugzilla/Field.pm: $dbh->do("DELETE FROM fielddefs WHERE name='requesters.login_name'");
Bugzilla/Field.pm: $dbh->do("DELETE FROM fielddefs WHERE name='attachments.thedata'");
Bugzilla/Field.pm: WHERE description = ?',
Bugzilla/Field.pm: FROM namedqueries WHERE ' .
Bugzilla/Field.pm: WHERE userid = ? AND name = ?');
Bugzilla/Field.pm: FROM series WHERE ' .
Bugzilla/Field.pm: WHERE series_id = ?');
Bugzilla/Field.pm: $dbh->do('UPDATE fielddefs SET name = ? WHERE id = ?',
Bugzilla/Object.pm: WHERE $id_field = ?}, undef, $id);
Bugzilla/Object.pm: "SELECT $columns FROM $table WHERE $condition", undef, @values);
Bugzilla/Object.pm:# certain other tables for the WHERE criteria.
Bugzilla/Object.pm: # the WHERE value is a hashref where the keys are
Bugzilla/Object.pm: $sql .= " WHERE $where ";
Bugzilla/Object.pm: $dbh->do("UPDATE $table SET $columns WHERE $id_field = ?", undef,
Bugzilla/Object.pm: $dbh->do("DELETE FROM $table WHERE $id_field = ?", undef, $self->id);
Bugzilla/Object.pm:C<condition> is a set of SQL conditions for the WHERE clause, which contain
Bugzilla/Object.pm: WHERE => { 'some_column >= ?' => $some_value }
Bugzilla/Bug.pm: WHERE ($where_sql) $product_sql
Bugzilla/Bug.pm: $dbh->do('UPDATE bugs SET creation_ts = ? WHERE bug_id = ?', undef,
Bugzilla/Bug.pm: my $sth_bug_time = $dbh->prepare('UPDATE bugs SET delta_ts = ? WHERE bug_id = ?');
Bugzilla/Bug.pm: $dbh->do('DELETE FROM cc WHERE bug_id = ? AND '
Bugzilla/Bug.pm: $dbh->do('DELETE FROM bugs_aliases WHERE bug_id = ? AND alias = ?',
Bugzilla/Bug.pm: $dbh->do('DELETE FROM keywords WHERE bug_id = ? AND '
Bugzilla/Bug.pm: $dbh->do("DELETE FROM dependencies WHERE $type = ? AND $other = ?",
Bugzilla/Bug.pm: $dbh->do('UPDATE bugs SET delta_ts = ? WHERE bug_id = ?',
Bugzilla/Bug.pm: $dbh->do('UPDATE bugs SET delta_ts = ? WHERE bug_id = ?',
Bugzilla/Bug.pm: WHERE bug_id = ? AND group_id IN ($qmarks)", undef,
Bugzilla/Bug.pm: $dbh->do("DELETE FROM duplicates WHERE dupe = ?", undef, $self->id);
Bugzilla/Bug.pm: $dbh->do('UPDATE bugs SET delta_ts = ? WHERE bug_id = ?',
Bugzilla/Bug.pm: WHERE user_id = ? AND bug_id = ?',
Bugzilla/Bug.pm: 'SELECT thetext, isprivate FROM longdescs WHERE bug_id = ?',
Bugzilla/Bug.pm: ' WHERE bug_id = ?',
Bugzilla/Bug.pm: $dbh->do("DELETE FROM bugs_fulltext WHERE bug_id = ?", undef, $bug_id);
Bugzilla/Bug.pm: "SELECT $field FROM bugs WHERE bug_id = ?", undef, $dep_id);
Bugzilla/Bug.pm: WHERE bgm.bug_id IN (' . join(',', ('?') x @idlist) . ')
Bugzilla/Bug.pm: WHERE gcm.product_id = ?
Bugzilla/Bug.pm: WHERE name = ? AND user_id = ?',
Bugzilla/Bug.pm: $dbh->do('DELETE FROM bug_tag WHERE bug_id = ? AND tag_id = ?',
Bugzilla/Bug.pm: $dbh->do('DELETE FROM tag WHERE name = ? AND user_id = ?',
Bugzilla/Bug.pm: WHERE bug_id = ? AND user_id = ?',
Bugzilla/Bug.pm: WHERE dupe = ?},
Bugzilla/Bug.pm: my $sth = $dbh->prepare('SELECT dupe_of FROM duplicates WHERE dupe = ?');
Bugzilla/Bug.pm: WHERE longdescs.bug_id=?");
Bugzilla/Bug.pm: q{SELECT alias FROM bugs_aliases WHERE bug_id = ? ORDER BY alias},
Bugzilla/Bug.pm: WHERE bug_id = ?
Bugzilla/Bug.pm: 'SELECT who FROM cc WHERE bug_id = ?', undef, $self->id);
Bugzilla/Bug.pm: $dbh->selectcol_arrayref('SELECT dupe FROM duplicates WHERE dupe_of = ?',
Bugzilla/Bug.pm: "SELECT keywordid FROM keywords WHERE bug_id = ?", undef, $self->id);
Bugzilla/Bug.pm: 'SELECT id FROM bug_see_also WHERE bug_id = ?',
Bugzilla/Bug.pm: " WHERE isbuggroup = 1" .
Bugzilla/Bug.pm: 'SELECT group_id FROM bug_group_map WHERE bug_id = ?',
Bugzilla/Bug.pm: "SELECT bug_id FROM bugs_aliases WHERE alias = ?", undef, $alias);
Bugzilla/Bug.pm: WHERE $my_field = ? $is_open_clause
Bugzilla/Bug.pm: 'SELECT bug_id, alias FROM bugs_aliases WHERE ' .
Bugzilla/Bug.pm: WHERE bugs_activity.bug_id = ?
Bugzilla/Bug.pm: WHERE longdescs_tags_activity.bug_id = ?
Bugzilla/Bug.pm: $sth{dependson} = $dbh->prepare('SELECT dependson FROM dependencies WHERE blocked = ?');
Bugzilla/Bug.pm: $sth{blocked} = $dbh->prepare('SELECT blocked FROM dependencies WHERE dependson = ?');
Bugzilla/Bug.pm: "SELECT value FROM bug_$field WHERE bug_id = ? ORDER BY value",
Bugzilla/Group.pm: 'SELECT bug_id FROM bug_group_map WHERE group_id = ?',
Bugzilla/Group.pm: WHERE isbless = 0 $grant_clause AND group_id = ?", undef, $self->id);
Bugzilla/Group.pm: WHERE grantor_id = ? AND grant_type = $type",
Bugzilla/Group.pm: WHERE member_id = ? AND grant_type = $type",
Bugzilla/Group.pm: FROM group_control_map WHERE group_id = ?', {Slice=>{}},
Bugzilla/Group.pm: WHERE mailto_type = ? AND mailto = ?',
Bugzilla/Group.pm: WHERE group_control_map.group_id = ?
Bugzilla/Group.pm: WHERE user_id = ? AND group_id = ?
Bugzilla/Group.pm: WHERE grantor_id = ?
Bugzilla/Comment.pm: "DELETE FROM longdescs_tags WHERE comment_id = ? AND tag = ?"
Bugzilla/Comment.pm: WHERE " . $dbh->sql_in('comment_id', \@comment_ids) . ' ' .
Bugzilla/Comment.pm: WHERE comment_id = ?
Bugzilla/Comment.pm: WHERE bug_id = ?
Bugzilla/Classification.pm: 'SELECT id FROM products WHERE classification_id = ?', undef, $self->id);
Bugzilla/Classification.pm: $dbh->do('UPDATE products SET classification_id = 1 WHERE '
Bugzilla/Classification.pm: WHERE classification_id = ?}, undef, $self->id) || 0;
Bugzilla/Classification.pm: WHERE classification_id = ?
Bugzilla/FlagType.pm: $dbh->do("DELETE FROM flag$category WHERE type_id = ?", undef, $flag_id);
Bugzilla/FlagType.pm: WHERE flags.type_id = ?
Bugzilla/FlagType.pm: WHERE flags.type_id = ?
Bugzilla/FlagType.pm: 'SELECT id FROM flags WHERE type_id = ? AND requestee_id IS NOT NULL',
Bugzilla/FlagType.pm: $dbh->do('UPDATE flags SET requestee_id = NULL WHERE ' . $dbh->sql_in('id', $ids));
Bugzilla/FlagType.pm: WHERE type_id = ?', undef, $self->{'id'});
Bugzilla/FlagType.pm: WHERE flagtypes.id = ?",
Bugzilla/FlagType.pm: my $flagtype_ids = $dbh->selectcol_arrayref("SELECT id FROM $tables WHERE $criteria");
Bugzilla/FlagType.pm: FROM $tables WHERE $criteria");
Bugzilla/FlagType.pm: # size before building a WHERE clause out of it
Bugzilla/FlagType.pm: # exclusions list, we add a WHERE criteria to use only records with
Bugzilla/Keyword.pm: 'SELECT COUNT(*) FROM keywords WHERE keywordid = ?',
Bugzilla/Auth/Persist/Cookie.pm: $dbh->do("DELETE FROM logincookies WHERE lastused < "
Bugzilla/Auth/Persist/Cookie.pm: $dbh->do("DELETE FROM logincookies WHERE userid = ?",
Bugzilla/Auth/Persist/Cookie.pm: $dbh->do("DELETE FROM logincookies WHERE " .
Bugzilla/Auth/Persist/Cookie.pm: $dbh->do("DELETE FROM logincookies WHERE " .
Bugzilla/Auth/Login/Cookie.pm: WHERE cookie = ?
Bugzilla/Auth/Login/Cookie.pm: WHERE cookie = ?", undef, $login_cookie);
Bugzilla/Auth/Verify.pm: FROM profiles WHERE extern_id = ?', undef, $extern_id);
Bugzilla/Auth/Verify.pm: $dbh->do('UPDATE profiles SET extern_id = ? WHERE userid = ?',
Bugzilla/Auth/Verify/DB.pm: $dbh->do("UPDATE profiles SET cryptpassword = ? WHERE userid = ?",
Bugzilla/Install/DB.pm: WHERE name = 'qacontact_accessible'
Bugzilla/Install/DB.pm: 'SELECT COUNT(id) FROM fielddefs WHERE sortkey >= 100'))
Bugzilla/Install/DB.pm: $dbh->do('UPDATE fielddefs SET sortkey = ? WHERE id = ?',
Bugzilla/Install/DB.pm: $dbh->do('UPDATE fielddefs SET buglist = 1 WHERE custom = 1 AND type != ' . FIELD_TYPE_MULTI_SELECT);
Bugzilla/Install/DB.pm: WHERE custom = 1 AND type = ' . FIELD_TYPE_MULTI_SELECT);
Bugzilla/Install/DB.pm: $dbh->do('UPDATE fielddefs SET is_numeric = 1 WHERE type = '
Bugzilla/Install/DB.pm: $dbh->do("UPDATE series SET creator = NULL WHERE creator = 0");
Bugzilla/Install/DB.pm: $dbh->do('UPDATE quips SET userid = NULL WHERE userid = 0');
Bugzilla/Install/DB.pm: $dbh->do("UPDATE bugs SET qa_contact = NULL WHERE qa_contact = 0");
Bugzilla/Install/DB.pm: $dbh->do("DELETE FROM user_group_map WHERE grant_type = " . GRANT_DERIVED);
Bugzilla/Install/DB.pm: $dbh->do("UPDATE bugs_activity SET fieldid = ? WHERE field = ?",
Bugzilla/Install/DB.pm: WHERE p1.userid < p2.userid
Bugzilla/Install/DB.pm: $dbh->do("DELETE FROM profiles WHERE userid = $u2");
Bugzilla/Install/DB.pm: "SELECT userid FROM profiles WHERE login_name = ?",
Bugzilla/Install/DB.pm: WHERE program = ? AND value = ?", undef,
Bugzilla/Install/DB.pm: "SELECT userid FROM profiles WHERE login_name = ?",
Bugzilla/Install/DB.pm: WHERE program = ? AND value = ?", undef,
Bugzilla/Install/DB.pm: WHERE target_milestone = ' '");
Bugzilla/Install/DB.pm: WHERE value = ? AND product = ?", undef, $value, $product);
Bugzilla/Install/DB.pm: WHERE value = ? AND product = ?",
Bugzilla/Install/DB.pm: WHERE (" . $dbh->sql_regexp("thetext",
Bugzilla/Install/DB.pm: WHERE bug_id = $bug_id AND who = $who
Bugzilla/Install/DB.pm: $dbh->do("DELETE FROM logincookies WHERE cookie = $cookie");
Bugzilla/Install/DB.pm: $dbh->do("DELETE FROM products WHERE product IS NULL");
Bugzilla/Install/DB.pm: $dbh->do("DELETE FROM components WHERE value IS NULL");
Bugzilla/Install/DB.pm: $dbh->do("DELETE FROM products WHERE id = $product_id");
Bugzilla/Install/DB.pm: $dbh->do("DELETE FROM components WHERE id = $component_id");
Bugzilla/Install/DB.pm: my $sth = $dbh->prepare("SELECT bit, id FROM groups WHERE bit > 0");
Bugzilla/Install/DB.pm: WHERE (groupset & $bit) != 0");
Bugzilla/Install/DB.pm: WHERE group_id = $gid AND user_id = $uid
Bugzilla/Install/DB.pm: WHERE (blessgroupset & $bit) != 0");
Bugzilla/Install/DB.pm: WHERE (groupset & $bit) != 0");
Bugzilla/Install/DB.pm: WHERE name = " . $dbh->quote('bug_group'));
Bugzilla/Install/DB.pm: WHERE name = " . $dbh->quote('groupset'));
Bugzilla/Install/DB.pm: FROM bugs_activity WHERE fieldid = $gsid");
Bugzilla/Install/DB.pm: WHERE (bit & $added) != 0
Bugzilla/Install/DB.pm: WHERE (bit & $removed) != 0
Bugzilla/Install/DB.pm: " WHERE bug_id = $bug_id AND bug_when = " .
Bugzilla/Install/DB.pm: WHERE (bit & $added) != 0
Bugzilla/Install/DB.pm: WHERE (bit & $removed) != 0
Bugzilla/Install/DB.pm: " WHERE userid = $uid AND profiles_when = " .
Bugzilla/Install/DB.pm: "SELECT id FROM groups WHERE name = 'admin'");
Bugzilla/Install/DB.pm: $dbh->do("DELETE FROM fielddefs WHERE name = "
Bugzilla/Install/DB.pm: "SELECT id FROM fielddefs WHERE name='attachstatusdefs.name'")
Bugzilla/Install/DB.pm: "SELECT id FROM fielddefs WHERE name = 'flagtypes.name'");
Bugzilla/Install/DB.pm: WHERE attachstatuses.statusid = attachstatusdefs.id
Bugzilla/Install/DB.pm: WHERE bug_id = ? AND attach_id = ?
Bugzilla/Install/DB.pm: WHERE fieldid = $old_field_id");
Bugzilla/Install/DB.pm: $dbh->do("DELETE FROM fielddefs WHERE name='attachstatusdefs.name'");
Bugzilla/Install/DB.pm: my $sth = $dbh->prepare("UPDATE flagtypes SET name = ? WHERE id = ?");
Bugzilla/Install/DB.pm: WHERE isbuggroup != 0");
Bugzilla/Install/DB.pm: WHERE name = " .$dbh->quote($groupname));
Bugzilla/Install/DB.pm: "DELETE FROM series_data WHERE series_id = ? AND series_date = ?");
Bugzilla/Install/DB.pm: $dbh->do("DELETE FROM user_group_map WHERE isderived != 0");
Bugzilla/Install/DB.pm: WHERE (} . $dbh->sql_position(q{'\n'}, 'thetext') . q{ > 81
Bugzilla/Install/DB.pm: $dbh->do("UPDATE groups SET name = ? WHERE id = ?",
Bugzilla/Install/DB.pm: WHERE event = $source");
Bugzilla/Install/DB.pm: "SELECT 1 FROM email_setting WHERE event = $event "
Bugzilla/Install/DB.pm: $dbh->do('DELETE FROM versions WHERE product_id = ? AND value = ?',
Bugzilla/Install/DB.pm: $dbh->do('UPDATE op_sys SET value = ? WHERE value = ?',
Bugzilla/Install/DB.pm: $dbh->do('UPDATE bugs SET op_sys = ? WHERE op_sys = ?',
Bugzilla/Install/DB.pm: WHERE query LIKE '$broken_series_indicator%'");
Bugzilla/Install/DB.pm: $dbh->prepare('DELETE FROM series_data WHERE series_id = ?');
Bugzilla/Install/DB.pm: $dbh->prepare('UPDATE series SET query = ? WHERE series_id = ?');
Bugzilla/Install/DB.pm: $dbh->prepare("SELECT series_id FROM series WHERE query IN (?, ?)");
Bugzilla/Install/DB.pm: WHERE series_id = ?');
Bugzilla/Install/DB.pm: ' WHERE series_id = ?');
Bugzilla/Install/DB.pm: ' WHERE series_id = ? AND series_date = ?');
Bugzilla/Install/DB.pm: ' WHERE series_id = ? AND series_date = ?');
Bugzilla/Install/DB.pm: ' WHERE series_id = ? AND series_date = ?');
Bugzilla/Install/DB.pm: "SELECT 1 FROM groups WHERE userregexp = '' " . $dbh->sql_limit(1));
Bugzilla/Install/DB.pm: 'SELECT 1 FROM user_group_map WHERE grant_type = ' . GRANT_REGEXP
Bugzilla/Install/DB.pm: WHERE userregexp != '' OR user_group_map.group_id IS NOT NULL");
Bugzilla/Install/DB.pm: WHERE user_id = ? AND group_id = ? AND isbless = 0
Bugzilla/Install/DB.pm: $dbh->selectall_arrayref("SELECT short_desc, bug_id FROM bugs WHERE " .
Bugzilla/Install/DB.pm: $dbh->do("UPDATE bugs SET short_desc = ? WHERE bug_id = ?",
Bugzilla/Install/DB.pm: $dbh->do('DELETE FROM flags WHERE is_active = 0');
Bugzilla/Install/DB.pm: FROM bugs WHERE CHAR_LENGTH(short_desc) > 255');
Bugzilla/Install/DB.pm: WHERE bug_id = ?');
Bugzilla/Install/DB.pm: WHERE linkinfooter = 1');
Bugzilla/Install/DB.pm: WHERE userid = ?');
Bugzilla/Install/DB.pm: 'SELECT userid FROM profiles WHERE login_name = ?',
Bugzilla/Install/DB.pm: 'SELECT name, type FROM fielddefs WHERE custom = 1');
Bugzilla/Install/DB.pm: $dbh->do('UPDATE fielddefs SET name = ? WHERE name = ?',
Bugzilla/Install/DB.pm: 'SELECT name FROM fielddefs WHERE type = ? AND custom = 1',
Bugzilla/Install/DB.pm: WHERE is_open = 0');
Bugzilla/Install/DB.pm: WHERE resolution != ?', undef, '')};
Bugzilla/Install/DB.pm: $dbh->do('UPDATE bug_status SET is_open = 0 WHERE value IN (' .
Bugzilla/Install/DB.pm: my $sth_select = $dbh->prepare('SELECT id FROM bug_status WHERE value = ?');
Bugzilla/Install/DB.pm: 'SELECT id FROM bug_status WHERE value = ?', undef, $dup_status);
Bugzilla/Install/DB.pm: WHERE old_status IS NULL', undef, $status_id);
Bugzilla/Install/DB.pm: WHERE name = 'lang'
Bugzilla/Install/DB.pm: $dbh->do(q{UPDATE setting SET subclass = 'Lang' WHERE name = 'lang'});
Bugzilla/Install/DB.pm: $dbh->do(q{DELETE FROM setting_value WHERE name = 'lang'});
Bugzilla/Install/DB.pm: WHERE attach_id IS NOT NULL ' .
Bugzilla/Install/DB.pm: WHERE attach_id = ?');
Bugzilla/Install/DB.pm: WHERE CHAR_LENGTH($field_name) > ?", {Columns=>[1,2]}, $max_length) };
Bugzilla/Install/DB.pm: WHERE type = ' . FIELD_TYPE_MULTI_SELECT);
Bugzilla/Install/DB.pm: $dbh->do("DELETE FROM bugs_fulltext WHERE "
Bugzilla/Install/DB.pm: WHERE modification_date < creation_date');
Bugzilla/Install/DB.pm: 'SELECT name FROM fielddefs WHERE custom = 1 AND type IN(?,?)',
Bugzilla/Install/DB.pm: $dbh->do("UPDATE profiles SET extern_id = NULL WHERE extern_id = ''");
Bugzilla/Install/DB.pm: $dbh->do('UPDATE products SET isactive = 0 WHERE disallownew = 1');
Bugzilla/Install/DB.pm: $dbh->do('UPDATE products SET isactive = 1 WHERE disallownew = 0');
Bugzilla/Install/DB.pm: $dbh->do('UPDATE logincookies SET ipaddr = NULL WHERE ipaddr = ?',
Bugzilla/Install/DB.pm: "SELECT 1 FROM longdescs WHERE type = $type " . $dbh->sql_limit(1));
Bugzilla/Install/DB.pm: WHERE thetext LIKE '$string%'",
Bugzilla/Install/DB.pm: WHERE comment_id = ?');
Bugzilla/Install/DB.pm: 'SELECT DISTINCT bug_id FROM longdescs WHERE '
Bugzilla/Install/DB.pm: WHERE votestoconfirm > 0');
Bugzilla/Install/DB.pm: $dbh->do('UPDATE attachments SET filename = ? WHERE isurl = 1',
Bugzilla/Install/DB.pm: $dbh->do("DELETE FROM fielddefs WHERE name='attachments.isurl'");
Bugzilla/Install/DB.pm: WHERE visibility_value_id IS NOT NULL",
Bugzilla/Install/DB.pm: WHERE s1.series_id != s2.series_id');
Bugzilla/Install/DB.pm: my $sth_series_update = $dbh->prepare('UPDATE series SET name = ? WHERE series_id = ?');
Bugzilla/Install/DB.pm: my $sth_series_query = $dbh->prepare('SELECT 1 FROM series WHERE name = ?
Bugzilla/Install/DB.pm: WHERE query_type != 0');
Bugzilla/Install/DB.pm: 'SELECT id FROM tag WHERE user_id = ? AND name = ?');
Bugzilla/Install/DB.pm: WHERE id = ?');
Bugzilla/Install/DB.pm: $dbh->prepare("UPDATE bug_see_also SET class = ? WHERE id = ?");
Bugzilla/Install/DB.pm: WHERE disabledtext != ''");
Bugzilla/Install/DB.pm: WHERE blocked = ? AND dependson = ?",
Bugzilla/Install/DB.pm: WHERE CHAR_LENGTH(quip) > 512");
Bugzilla/Install/DB.pm: my $query = $dbh->prepare("UPDATE quips SET quip = ? WHERE quipid = ?");
Bugzilla/Install/DB.pm: my $profiles = $dbh->selectall_arrayref("SELECT userid, cryptpassword FROM profiles WHERE ("
Bugzilla/Install/DB.pm: my $query = $dbh->prepare("UPDATE profiles SET cryptpassword = ? WHERE userid = ?");
Bugzilla/Install/DB.pm: WHERE type_id = ? AND product_id = ? AND component_id = ?",
Bugzilla/Install/DB.pm: SELECT bug_id, alias FROM bugs WHERE alias IS NOT NULL
Bugzilla/Install/DB.pm: $dbh->selectcol_arrayref('SELECT added FROM audit_log WHERE class = ? AND field = ?
Bugzilla/Install/DB.pm: WHERE class = ? AND field = ? AND added = ?');
Bugzilla/BugMail.pm: WHERE watched IN ($involved)");
Bugzilla/BugMail.pm: $dbh->do('UPDATE bugs SET lastdiffed = ? WHERE bug_id = ?',
Bugzilla/BugMail.pm: WHERE bugs_activity.bug_id = ?
Bugzilla/BugMail.pm: 'SELECT isprivate FROM attachments WHERE attach_id = ?',
Bugzilla/Status.pm: 'SELECT value FROM bug_status WHERE is_open = 1'
Bugzilla/Status.pm: WHERE isactive = 1
Bugzilla/Status.pm: WHERE $cond", undef, @$values);
Bugzilla/Status.pm: WHERE old_status IS NULL',
Bugzilla/Token.pm: WHERE userid = ? AND tokentype = 'api_token'
Bugzilla/Token.pm: WHERE tokentype = ?
Bugzilla/Token.pm: WHERE userid = ? AND tokentype = ?
Bugzilla/Token.pm: WHERE ' . $dbh->sql_to_days('NOW()') . ' - ' .
Bugzilla/Token.pm: my $sth = $dbh->prepare("SELECT 1 FROM $table WHERE $column = ?");
Bugzilla/Token.pm: WHERE token = ?',
Bugzilla/Token.pm: WHERE userid = ? AND tokentype = ?',
Bugzilla/Token.pm: WHERE userid = ?
Bugzilla/Token.pm: WHERE token = ?", undef, $token);
Bugzilla/Token.pm: $dbh->do("DELETE FROM tokens WHERE token = ?", undef, $token);
Bugzilla/Constants.pm: # SQLite 3.6.22 fixes a WHERE clause problem that may affect us.
Bugzilla/Mailer.pm: my $sth = $dbh->prepare('DELETE FROM mail_staging WHERE id = ?');
Bugzilla/Search/Quicksearch.pm: q{SELECT bug_id FROM bugs_aliases WHERE alias = ?}, undef, $alias);
Bugzilla/Search/Saved.pm: "SELECT $id_field, query FROM $table WHERE query LIKE ?",
Bugzilla/Search/Saved.pm: $dbh->do("UPDATE $table SET query = ? WHERE $id_field = ?",
Bugzilla/Search/Saved.pm: WHERE ' . $dbh->sql_in('namedquery_id', \@query_ids) . ' AND user_id = ?',
Bugzilla/Search/Saved.pm: WHERE whine_events.owner_userid = ? AND query_name = ?', undef,
Bugzilla/Search/Saved.pm: WHERE namedquery_id = ? AND user_id = ?',
Bugzilla/Search/Saved.pm: 'SELECT group_id FROM namedquery_group_map WHERE namedquery_id = ?',
Bugzilla/Search/Saved.pm: WHERE namedquery_id = ?
Bugzilla/Search/Recent.pm: "SELECT id FROM profile_search WHERE user_id = ? ORDER BY id",
Bugzilla/Search/Recent.pm: "DELETE FROM profile_search WHERE id IN (" . join(',', @ids) . ")");
Bugzilla/Migrate.pm: WHERE bug_id = ?', undef, $bug->{creation_ts},
Bugzilla/Migrate.pm: $dbh->do('UPDATE bugs SET delta_ts = ? WHERE bug_id = ?',
Bugzilla/Migrate.pm: $dbh->do('UPDATE bugs SET lastdiffed = delta_ts WHERE bug_id = ?',
Bugzilla/Migrate.pm: $dbh->do('UPDATE bugs SET bug_status = ? WHERE bug_id = ?',
Bugzilla/Migrate.pm: $dbh->do('UPDATE bugs SET resolution = ? WHERE bug_id = ?',
Bugzilla/Migrate.pm: $dbh->do('DELETE FROM bugs_fulltext WHERE bug_id = ?',
Bugzilla/Milestone.pm: WHERE target_milestone = ? AND product_id = ?',
Bugzilla/Milestone.pm: WHERE id = ? AND defaultmilestone = ?',
Bugzilla/Milestone.pm: WHERE product_id = ? AND target_milestone = ?',
Bugzilla/Milestone.pm: WHERE ' . $dbh->sql_in('bug_id', $bug_ids),
Bugzilla/Milestone.pm: WHERE product_id = ? AND target_milestone = ?},
Bugzilla/Version.pm: WHERE product_id = ? AND version = ?}, undef,
Bugzilla/Version.pm: WHERE version = ? AND product_id = ?',
Bugzilla/Flag.pm: $dbh->do('UPDATE flags SET modification_date = ? WHERE id = ?',
Bugzilla/Flag.pm: WHERE bugs.bug_id = ? AND i.type_id IS NULL',
Bugzilla/Flag.pm: WHERE bugs.bug_id = ?
Bugzilla/Flag.pm: $dbh->do('UPDATE flags SET type_id = ? WHERE id = ?',
Bugzilla/DB/Schema.pm: . " WHERE $column IS NULL");
Bugzilla/DB/Mysql.pm: WHERE TABLE_SCHEMA = ? AND ENGINE = ?',
Bugzilla/DB/Mysql.pm: WHERE bug_id=? AND who=?
Bugzilla/DB/Mysql.pm: WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ?',
Bugzilla/DB/Mysql.pm: WHERE TABLE_SCHEMA = ? AND TABLE_COLLATION IS NOT NULL
Bugzilla/DB/Oracle.pm: eval { $self->do("SELECT 1 FROM DUAL WHERE "
Bugzilla/DB/Oracle.pm: # query with "SELECT * FROM (...) WHERE rownum < $limit"
Bugzilla/DB/Oracle.pm: $new_sql = $new_sql." WHERE 1=1";
Bugzilla/DB/Oracle.pm: $new_sql = $before_where." WHERE ".$after_where;
Bugzilla/DB/Oracle.pm: "SELECT LOWER(COLUMN_NAME) FROM USER_TAB_COLUMNS WHERE
Bugzilla/DB/Oracle.pm: "SELECT LOWER(TABLE_NAME) FROM USER_TABLES WHERE
Bugzilla/DB/Oracle.pm: WHERE type_name = 'T_GROUP_CONCAT'");
Bugzilla/DB/Oracle.pm: "SELECT pre_name FROM CTXSYS.CTX_PREFERENCES WHERE pre_name = ? AND
Bugzilla/DB/Oracle.pm: my $sth = $self->prepare("SELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_NAME = ?");
Bugzilla/DB/Oracle.pm: . " WHERE $column = :OLD.$to_column;"
Bugzilla/DB/Pg.pm: 'SELECT 1 FROM pg_statio_user_sequences WHERE relname = ?',
Bugzilla/DB/Pg.pm: my ($has_plpgsql) = $self->selectrow_array("SELECT COUNT(*) FROM pg_language WHERE lanname = 'plpgsql'");
Bugzilla/DB/Pg.pm: 'SELECT 1 FROM pg_proc WHERE proname = ?', undef, $function);
Bugzilla/DB/Pg.pm: "SELECT $field FROM $table WHERE LOWER($field) = ?",
Bugzilla/DB/Pg.pm: "SELECT 1 FROM $table WHERE LOWER($field) = ?",
Bugzilla/DB/Pg.pm: $dbh->do("UPDATE $table SET $field = ? WHERE $field = ?",
Bugzilla/DB/Schema/Mysql.pm: WHERE $column IS NULL") if defined $set_nulls_to;
Bugzilla/DB/Schema/Sqlite.pm: "SELECT sql FROM sqlite_master WHERE name = ? AND type = 'table'",
Bugzilla/DB/Schema/Oracle.pm: WHERE $column = :OLD.$to_column;
Bugzilla/DB/Schema/Oracle.pm: . " WHERE $column IS NULL");
Bugzilla/DB/Schema/Oracle.pm: "SELECT CNAME FROM COL WHERE TNAME = UPPER(?) AND
Bugzilla/DB/Schema/Oracle.pm: WHERE OBJECT_NAME = ?", undef, $trigger_name);
Bugzilla/User.pm: WHERE user_id = ?
Bugzilla/User.pm: $dbh->do('DELETE FROM tokens WHERE userid = ?', undef, $self->id)
Bugzilla/User.pm: WHERE user_id = ? AND isbless = ? AND grant_type = ?},
Bugzilla/User.pm: $dbh->do("UPDATE profiles SET last_seen_date = ? WHERE userid = ?",
Bugzilla/User.pm: 'SELECT cryptpassword FROM profiles WHERE userid = ?',
Bugzilla/User.pm: 'SELECT id FROM namedqueries WHERE userid = ?', undef, $self->id);
Bugzilla/User.pm: WHERE lif.user_id = ?
Bugzilla/User.pm: WHERE ' . $self->groups_in_sql . "
Bugzilla/User.pm: WHERE user_id = ? ' . $dbh->sql_group_by('id', 'name'),
Bugzilla/User.pm: WHERE user_id = ?',
Bugzilla/User.pm: 'SELECT id FROM reports WHERE user_id = ?', undef, $self->id);
Bugzilla/User.pm: WHERE user_id = ? AND isbless = 0", undef, $self->id);
Bugzilla/User.pm: WHERE grant_type = " . GROUP_MEMBERSHIP);
Bugzilla/User.pm: WHERE user_id = ?
Bugzilla/User.pm: WHERE grant_type = " . GROUP_BLESS . "
Bugzilla/User.pm: WHERE product_id = ?
Bugzilla/User.pm: WHERE $group != 0
Bugzilla/User.pm: WHERE userid = ?
Bugzilla/User.pm: WHERE userid = ?
Bugzilla/User.pm: WHERE product_id = $prod_id) AS p");
Bugzilla/User.pm: WHERE product_id = ?
Bugzilla/User.pm: WHERE bugs.bug_id IN (} . join(',', ('?') x @$check_ids) . qq{)
Bugzilla/User.pm: WHERE bugs.bug_id IN (' . join(',', ('?') x @$check_ids) . ')
Bugzilla/User.pm: $query .= " WHERE group_id IN (" . $self->groups_as_string . ")
Bugzilla/User.pm: WHERE group_id IS NULL";
Bugzilla/User.pm: $query .= " WHERE (group_id IN (" . $self->groups_as_string . ")" .
Bugzilla/User.pm: " WHERE group_id IS NULL"
Bugzilla/User.pm: WHERE ' . $dbh->sql_in('products.id', $enterable_ids) .
Bugzilla/User.pm: WHERE components.isactive = 1)
Bugzilla/User.pm: WHERE versions.isactive = 1)');
Bugzilla/User.pm: WHERE " . $self->groups_in_sql('member_id') . "
Bugzilla/User.pm: WHERE user_id = ?
Bugzilla/User.pm: WHERE components.initialowner = ?
Bugzilla/User.pm: WHERE ' . $dbh->sql_istrcmp('login_name', '?'),
Bugzilla/User.pm: $query .= " WHERE (" .
Bugzilla/User.pm: WHERE user_id = ?', undef, $self->id);
Bugzilla/User.pm: $dbh->selectrow_array('SELECT 1 FROM audit_log WHERE user_id = ? ' .
Bugzilla/User.pm: $query .= " WHERE is_enabled = 1 ";
Bugzilla/User.pm: 'DELETE FROM login_failure WHERE user_id = ? AND ip_addr = ?',
Bugzilla/User.pm: WHERE user_id = ? AND login_time > $time
Bugzilla/User.pm: WHERE (tokentype = 'emailold'
Bugzilla/User.pm: WHERE " . $dbh->sql_istrcmp('login_name', '?'), undef, $login);
Bugzilla/WebService/Bug.pm: WHERE => {
Bugzilla/WebService/Group.pm: WHERE ugm.user_id = profiles.userid
Bugzilla/WebService/Group.pm: WHERE ugm.user_id = profiles.userid
Bugzilla/WebService/Bugzilla.pm: $sql_statement .= " WHERE " . $dbh->sql_in('class', \@class_values_quoted);
Bugzilla/User/Setting.pm: WHERE name = ?
Bugzilla/User/Setting.pm: WHERE name = ?},
Bugzilla/User/Setting.pm: $dbh->do('DELETE FROM setting_value WHERE name = ?', undef, $name);
Bugzilla/User/Setting.pm: $dbh->do('DELETE FROM setting WHERE name = ?', undef, $name);
Bugzilla/User/Setting.pm: WHERE setting_name = ? AND setting_value NOT IN ($list)",
Bugzilla/User/Setting.pm: WHERE name = ?});
Bugzilla/User/Setting.pm: "SELECT 1 FROM setting WHERE name = ?", undef, $setting_name) || 0;
Bugzilla/User/Setting.pm: WHERE name = ?
Bugzilla/User/Setting.pm: WHERE setting_name = ?
Bugzilla/User/Setting.pm: WHERE setting_name = ?
Bugzilla/DB.pm: "SELECT 1 FROM $table WHERE $name IS NULL");
Bugzilla/DB.pm: WHERE forn.$foreign_column IS NULL
Bugzilla/DB.pm: $self->do("DELETE FROM $table WHERE $column IN ("
Bugzilla/DB.pm: WHERE $column IN ("
Bugzilla/DB.pm: " FROM bugs WHERE bug_status != 'RESOLVED' " .
Bugzilla/Component.pm: WHERE component_id = ?', undef, $self->id);
Bugzilla/Component.pm: $dbh->do('DELETE FROM component_cc WHERE component_id = ?', undef, $self->id);
Bugzilla/Component.pm: WHERE component_id = ?}, undef, $self->id) || 0;
Bugzilla/Component.pm: WHERE component_id = ?}, undef, $self->id);
Bugzilla/Component.pm: WHERE component_id = ?',
Bugzilla/Install.pm: $dbh->do('DELETE FROM setting WHERE name = ?', undef, 'per_bug_queries');
Bugzilla/Install.pm: 'SELECT user_id FROM user_group_map WHERE group_id = ?
Bugzilla/Install.pm: WHERE group_id IN ($admin_group_ids)");
Created
February 21, 2016 20:16
-
-
Save dnmfarrell/691694fc62e4508974e9 to your computer and use it in GitHub Desktop.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment