Comment 6 for bug 371609

On Tue, Sep 22, 2009 at 11:58 PM, Данило Шеган <email address hidden> wrote:
> ok, the rendering above is not working very well; see
> http://paste.ubuntu.com/275968/

I think the following is a much simpler and faster variant of the above query:

SELECT PotMsgSet.id
FROM
    PotMsgSet,
    TranslationTemplateItem,
    PoMsgId AS SingPoMsgId,
    POTMsgSet AS SingPotMsgSet,
    TranslationTemplateItem AS SingTTI
WHERE
    PotMsgSet.id = TranslationTemplateItem.potmsgset
    AND TranslationTemplateItem.potemplate=702
    AND SingPoMsgId.id = PotMsgSet.msgid_singular
    AND SingPoMsgId.id = SingPotMsgSet.msgid_singular
    AND SingTTI.potmsgset = SingPotMsgSet.id
    AND SingTTI.potemplate=702
    AND SingTTI.sequence > 0
    AND lower(SingPoMsgId.msgid) LIKE
        '%' || lower('Media Management and Playback application') || '%'
ORDER BY PotMsgSet.id;

--
Stuart Bishop <email address hidden>
http://www.stuartbishop.net/