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;
On Tue, Sep 22, 2009 at 11:58 PM, Данило Шеган <email address hidden> wrote: paste.ubuntu. com/275968/
> ok, the rendering above is not working very well; see
> http://
I think the following is a much simpler and faster variant of the above query:
SELECT PotMsgSet.id TemplateItem, TemplateItem AS SingTTI lateItem. potmsgset lateItem. potemplate= 702 msgid_singular msgid_singular potemplate= 702 Id.msgid) LIKE
FROM
PotMsgSet,
Translation
PoMsgId AS SingPoMsgId,
POTMsgSet AS SingPotMsgSet,
Translation
WHERE
PotMsgSet.id = TranslationTemp
AND TranslationTemp
AND SingPoMsgId.id = PotMsgSet.
AND SingPoMsgId.id = SingPotMsgSet.
AND SingTTI.potmsgset = SingPotMsgSet.id
AND SingTTI.
AND SingTTI.sequence > 0
AND lower(SingPoMsg
'%' || lower('Media Management and Playback application') || '%'
ORDER BY PotMsgSet.id;
-- www.stuartbisho p.net/
Stuart Bishop <email address hidden>
http://