[wp-meta] [Making WordPress.org] #3351: Duplicated tickets in the theme final review queue

[Making WordPress.org]

#3351: Duplicated tickets in the theme final review queue
-----------------------------+------------------
 Reporter:  chetan200891     |       Owner:
     Type:  defect           |      Status:  new
 Priority:  normal           |   Milestone:
Component:  Theme Review     |  Resolution:
 Keywords:  has-screenshots  |
-----------------------------+------------------

Comment (by Otto42):

 Replying to [comment:2 SergeyBiryukov]:
 > Could we adjust the query to add `DISTINCT` (or something to that
 effect) to prevent future confusion?

 If you'd like to give it a try, go ahead. I'm not sure that that query is
 used enough for DISTINCT to add any sort of performance problem, but I'm
 unfamiliar with Trac quirks and SQL-Lite oddities.

 This is the query for that report:

 {{{
 SELECT
    id AS ticket,
    summary,
    reporter AS submitter,
    owner AS reviewer,
    tc.tc_time AS modified,
    t.keywords AS keywords

 FROM ticket t
 LEFT JOIN
 (SELECT ticket, time as tc_time FROM ticket_change WHERE field = 'status'
 AND newvalue = 'approved') tc
 ON (t.id = tc.ticket)
 WHERE status = 'approved'
 ORDER BY tc.tc_time
 }}}

--
Ticket URL: <https://meta.trac.wordpress.org/ticket/3351#comment:3>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org