Fixed vBulletin 4.2.5: Custom FAQ not imported

[ivp]

Affected version

1.2.3

This is the fix for vBulletin 4.2.5 Custom FAQ not being imported:

SELECT faq.*,
        p1.text AS title,
        p2.text AS html
FROM faq AS
        faq
INNER JOIN phrase AS
        p1 ON (p1.varname = CONCAT(faq.faqname, '_gfaqtitle') AND p1.languageid = 0)
INNER JOIN phrase AS 
        p2 ON (p2.varname = CONCAT(faq.faqname, '_gfaqtext') AND p2.languageid = 0)
WHERE faq.volatile = 0
ORDER BY faq.displayorder

should be changed to:

SELECT faq.*,
    p1.text AS title,
    p2.text AS html
FROM faq AS
    faq
INNER JOIN phrase AS
    p1 ON (p1.varname = faq.faqname AND p1.fieldname = 'faqtitle' AND p1.languageid = 0)
INNER JOIN phrase AS 
    p2 ON (p2.varname = faq.faqname AND p2.fieldname = 'faqtext' AND p2.languageid = 0)
WHERE faq.volatile = 0
ORDER BY faq.displayorder