Lines Matching refs:where_clause
77 $where_clause = ' WHERE 1 = 1 '; variable
81 $where_clause .= ' AND bugdb.private = "Y" ';
85 $where_clause .= ' AND (bugdb.bug_type <> "Security" OR private = "N") ';
89 $where_clause .= ' AND bugdb.package_name';
92 $where_clause .= " IN (" . join(", ", $items) . ")";
94 $where_clause .= ' = ' . $dbh->quote($package_name[0]);
99 $where_clause .= ' AND bugdb.package_name';
102 $where_clause .= " NOT IN (" . join(", ", $items) . ")";
104 $where_clause .= ' <> ' . $dbh->quote($package_nname[0]);
124 $where_clause .= " AND bugdb.status='$status'";
127 $where_clause .= " AND bugdb.status='Feedback'
131 $where_clause .= " AND bugdb.status NOT IN ('Closed', 'Duplicate', 'Not a bug')
135 $where_clause .= " AND bugdb.status NOT IN ('Closed', 'Duplicate', 'Not a bug')
139 …$where_clause .= " AND bugdb.status NOT IN ('Closed', 'Duplicate', 'Not a bug', 'Assigned', 'Wont …
142 …$where_clause .= " AND bugdb.status IN ('Open', 'Re-Opened', 'Assigned','Analyzed', 'Critical', 'V…
146 …$where_clause .= " AND bugdb.status IN ('Open', 'Re-Opened', 'Assigned', 'Analyzed', 'Critical', '…
151 $where_clause .= $sql_search;
159 … $where_clause .= ' AND (bugdb.bug_type = "Bug" OR bugdb.bug_type="Documentation Problem")';
161 $where_clause .= ' AND bugdb.bug_type = ' . $dbh->quote($bug_type);
166 $where_clause .= " AND bugdb.ts1 >= DATE_SUB(NOW(), INTERVAL $bug_age DAY)";
170 $where_clause .= " AND bugdb.ts2 >= DATE_SUB(NOW(), INTERVAL $bug_updated DAY)";
174 $where_clause .= " AND bugdb.php_os {$php_os_not} LIKE " . $dbh->quote('%'.$php_os.'%');
178 $where_clause .= " AND bugdb.php_version LIKE " . $dbh->quote($phpver.'%');
182 …$where_clause .= " AND EXISTS (SELECT 1 FROM bugdb_pseudo_packages b WHERE b.name = bugdb.package_…
186 $where_clause .= " AND bugdb.cve_id {$cve_id_not} LIKE " . $dbh->quote($cve_id.'%');
191 $where_clause .= " AND (1=2";
194 …$where_clause .= " OR EXISTS (SELECT 1 FROM bugdb_patchtracker WHERE bugdb_id = bugdb.id LIMIT 1)";
197 $where_clause .= " OR EXISTS (SELECT 1 FROM bugdb_pulls WHERE bugdb_id = bugdb.id LIMIT 1)";
200 $where_clause .= ")";
203 $where_clause .= ' AND bugdb.assign = ' . $dbh->quote($assign);
207 $where_clause .= ' AND bugdb.email = ' . $dbh->quote($author_email);
210 $where_clause .= ' AND c.email = ' . $dbh->quote($commented_by);
213 $where_clause .= ' AND (1=1';
216 $where_clause .= " OR bugdb.package_name";
219 $where_clause .= " IN (" . join(", ", $pseudo) . ")";
221 $where_clause .= " = " . $dbh->quote(reset($pseudo));
225 $where_clause .= " OR bugdb.package_name IN (" . join(", ", $items) . ")";
228 $query .= "$where_clause )";
