Comment 1 for bug 30607

Revision history for this message
Dafydd Harries (daf) wrote :

Naughty query:

25008ms SELECT DISTINCT POSubmission.id FROM POSubmission JOIN POMsgSet ON POSubmission.pomsgset = POMsgSet.id JOIN POFile ON (POMsgSet.pofile = POFile.id AND POFile.language = 409) JOIN POTMsgSet ON (POMsgSet.potmsgset = POTMsgSet.id AND POTMsgSet.primemsgid = 215839) LEFT OUTER JOIN POSelection AS ps1 ON ( ps1.activesubmission = POSubmission.id AND ps1.pluralform = 0) LEFT OUTER JOIN POSelection AS ps2 ON ( ps2.publishedsubmission = POSubmission.id AND ps2.pluralform = 0) WHERE ps1.id IS NOT NULL OR ps2.id IS NOT NULL