# Time: 090317 17:36:04
# User@Host: habari_trac_e[habari_trac_e] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
SELECT COUNT(*) FROM (SELECT t.id AS id,t.summary AS summary,t.status AS status,t.type AS type,t.priority AS priority,t.component AS component,t.reporter AS reporter,t.description AS description,t.time AS time,t.changetime AS changetime,priority.value AS priority_value
FROM ticket AS t
  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)
WHERE COALESCE(t.status,'') IN ('assigned','closed','new','reopened') AND COALESCE(t.component,'')='plugin wishlist'
ORDER BY COALESCE(priority.value,'')='',CAST(priority.value AS signed),t.id) AS foo;
# User@Host: habari_trac_e[habari_trac_e] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 31  Rows_examined: 233
SELECT t.id AS id,t.summary AS summary,t.status AS status,t.type AS type,t.priority AS priority,t.component AS component,t.reporter AS reporter,t.description AS description,t.time AS time,t.changetime AS changetime,priority.value AS priority_value
FROM ticket AS t
  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)
WHERE COALESCE(t.status,'') IN ('assigned','closed','new','reopened') AND COALESCE(t.component,'')='plugin wishlist'
ORDER BY COALESCE(priority.value,'')='',CAST(priority.value AS signed),t.id;