Dumping:
--------

-- RDEBUG http://www.arbeidstilsynet.no/abonnement/glemtpassord.html?
SELECT * FROM topic, topic_subject_identifier psi WHERE psi.topicid = topic.id AND instanceof = psi('http://psi.ravn.no/core/type/sprak') AND topic.id IN (SELECT role_sprak.player FROM topic, association_role role_sprak, association_role role_stoff, tmapi_association association WHERE role_sprak.association = association.id AND association.instanceof = psi('http://psi.ravn.no/core/type/association/content-is-in-language') AND role_sprak.type = psi('http://psi.ravn.no/core/type/role/content-is-in-language-target') AND role_stoff.association = association.id AND role_stoff.type = psi('http://psi.ravn.no/core/type/role/content-is-in-language-source') AND topic.id = role_stoff.player AND 1=1 AND topic.status_id IN (1, 13)  AND NOT EXISTS (SELECT id FROM topic_pub_info WHERE (sperrefrist > now() OR utlopsfrist <= now()) AND topicid=topic.id) );