select research_papers.*, acs_objects.creation_date, parties.*, persons.first_names, persons.last_name, score(1) as the_score from research_papers, acs_objects, parties, persons, cr_revisions where research_papers.paper_id = acs_objects.object_id and acs_objects.creation_user = parties.party_id and acs_objects.creation_user = persons.person_id and research_papers.revision_id = cr_revisions.revision_id(+) and ( lower(research_papers.title) like '%' || :search_text || '%' or contains(cr_revisions.content, :search_text, 1) > 0 or lower(parties.email) like '%' || :search_text || '%' or lower(persons.first_names) like '%' || :search_text || '%' or lower(persons.last_name) like '%' || :search_text || '%' or lower(research_papers.abstract) like '%' || :search_text || '%' or lower(research_papers.subject) like '%' || :search_text || '%' or lower(research_papers.source) like '%' || :search_text || '%' or lower(research_papers.rights) like '%' || :search_text || '%')