Re: Error on Full-Text

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Sathya (Sathya_at_discussions.microsoft.com)
Date: 08/04/04 

Date: Tue, 3 Aug 2004 23:33:02 -0700

I'm sorry i did not send the query in my previous mail...
The query is pasted below
SELECT egpl_kb_article.orig_article_id original_article_id , egpl_kb_links.parent_id parent_folder_id FROM egpl_kb_article , egpl_kb_links WHERE ( ( contains(egpl_kb_article.article_desc,'"want"') OR contains(egpl_kb_article.article_desc,'FORMSOF(INFLECTIONAL, "want")') or contains(egpl_kb_article.article_desc,'"information"') OR contains(egpl_kb_article.article_desc,'FORMSOF(INFLECTIONAL, "information")') or contains(egpl_kb_article.article_desc,'"on"') OR contains(egpl_kb_article.article_desc,'FORMSOF(INFLECTIONAL, "on")') or contains(egpl_kb_article.article_desc,'"Diamond"') OR contains(egpl_kb_article.article_desc,'FORMSOF(INFLECTIONAL, "Diamond")') or contains(egpl_kb_article.article_desc,'"Ring"') OR contains(egpl_kb_article.article_desc,'FORMSOF(INFLECTIONAL, "Ring")') or contains(egpl_kb_article.article_desc,'"want"') OR contains(egpl_kb_article.article_desc,'FORMSOF(INFLECTIONAL, "want")') or contains(egpl_kb_article.article_desc,'"information"') OR contains(egpl_kb_article.article_
desc,'FORMSOF(INFLECTIONAL, "information")') or contains(egpl_kb_article.article_desc,'"on"') OR contains(egpl_kb_article.article_desc,'FORMSOF(INFLECTIONAL, "on")') or contains(egpl_kb_article.article_desc,'"Diamond"') OR contains(egpl_kb_article.article_desc,'FORMSOF(INFLECTIONAL, "Diamond")') or contains(egpl_kb_article.article_desc,'"Ring"') OR contains(egpl_kb_article.article_desc,'FORMSOF(INFLECTIONAL, "Ring")') ) or ( contains(egpl_kb_article.article_summary,'"want"') OR contains(egpl_kb_article.article_summary,'FORMSOF(INFLECTIONAL, "want")') or contains(egpl_kb_article.article_summary,'"information"') OR contains(egpl_kb_article.article_summary,'FORMSOF(INFLECTIONAL, "information")') or contains(egpl_kb_article.article_summary,'"on"') OR contains(egpl_kb_article.article_summary,'FORMSOF(INFLECTIONAL, "on")') or contains(egpl_kb_article.article_summary,'"Diamond"') OR contains(egpl_kb_article.article_summary,'FORMSOF(INFLECTIONAL, "Diamond")') or contains(egpl_kb_article.article_summary,'"Ring
"') OR contains(egpl_kb_article.article_summary,'FORMSOF(INFLECTIONAL, "Ring")') or contains(egpl_kb_article.article_summary,'"want"') OR contains(egpl_kb_article.article_summary,'FORMSOF(INFLECTIONAL, "want")') or contains(egpl_kb_article.article_summary,'"information"') OR contains(egpl_kb_article.article_summary,'FORMSOF(INFLECTIONAL, "information")') or contains(egpl_kb_article.article_summary,'"on"') OR contains(egpl_kb_article.article_summary,'FORMSOF(INFLECTIONAL, "on")') or contains(egpl_kb_article.article_summary,'"Diamond"') OR contains(egpl_kb_article.article_summary,'FORMSOF(INFLECTIONAL, "Diamond")') or contains(egpl_kb_article.article_summary,'"Ring"') OR contains(egpl_kb_article.article_summary,'FORMSOF(INFLECTIONAL, "Ring")') ) or ( contains(egpl_kb_article.keywords,'"want"') OR contains(egpl_kb_article.keywords,'FORMSOF(INFLECTIONAL, "want")') or contains(egpl_kb_article.keywords,'"information"') OR contains(egpl_kb_article.keywords,'FORMSOF(INFLECTIONAL, "information")') or contains(
egpl_kb_article.keywords,'"on"') OR contains(egpl_kb_article.keywords,'FORMSOF(INFLECTIONAL, "on")') or contains(egpl_kb_article.keywords,'"Diamond"') OR contains(egpl_kb_article.keywords,'FORMSOF(INFLECTIONAL, "Diamond")') or contains(egpl_kb_article.keywords,'"Ring"') OR contains(egpl_kb_article.keywords,'FORMSOF(INFLECTIONAL, "Ring")') or contains(egpl_kb_article.keywords,'"want"') OR contains(egpl_kb_article.keywords,'FORMSOF(INFLECTIONAL, "want")') or contains(egpl_kb_article.keywords,'"information"') OR contains(egpl_kb_article.keywords,'FORMSOF(INFLECTIONAL, "information")') or contains(egpl_kb_article.keywords,'"on"') OR contains(egpl_kb_article.keywords,'FORMSOF(INFLECTIONAL, "on")') or contains(egpl_kb_article.keywords,'"Diamond"') OR contains(egpl_kb_article.keywords,'FORMSOF(INFLECTIONAL, "Diamond")') or contains(egpl_kb_article.keywords,'"Ring"') OR contains(egpl_kb_article.keywords,'FORMSOF(INFLECTIONAL, "Ring")') ) or ( contains(egpl_kb_article.content_text,'"want"') OR contains(egpl_kb
_article.content_text,'FORMSOF(INFLECTIONAL, "want")') or contains(egpl_kb_article.content_text,'"information"') OR contains(egpl_kb_article.content_text,'FORMSOF(INFLECTIONAL, "information")') or contains(egpl_kb_article.content_text,'"on"') OR contains(egpl_kb_article.content_text,'FORMSOF(INFLECTIONAL, "on")') or contains(egpl_kb_article.content_text,'"Diamond"') OR contains(egpl_kb_article.content_text,'FORMSOF(INFLECTIONAL, "Diamond")') or contains(egpl_kb_article.content_text,'"Ring"') OR contains(egpl_kb_article.content_text,'FORMSOF(INFLECTIONAL, "Ring")') or contains(egpl_kb_article.content_text,'"want"') OR contains(egpl_kb_article.content_text,'FORMSOF(INFLECTIONAL, "want")') or contains(egpl_kb_article.content_text,'"information"') OR contains(egpl_kb_article.content_text,'FORMSOF(INFLECTIONAL, "information")') or contains(egpl_kb_article.content_text,'"on"') OR contains(egpl_kb_article.content_text,'FORMSOF(INFLECTIONAL, "on")') or contains(egpl_kb_article.content_text,'"Diamond"') OR co
ntains(egpl_kb_article.content_text,'FORMSOF(INFLECTIONAL, "Diamond")') or contains(egpl_kb_article.content_text,'"Ring"') OR contains(egpl_kb_article.content_text,'FORMSOF(INFLECTIONAL, "Ring")') ) OR orig_article_id in (SELECT article_id FROM egpl_kb_search_attachment WHERE ( contains(egpl_kb_search_attachment.content,'"want"') OR contains(egpl_kb_search_attachment.content,'FORMSOF(INFLECTIONAL, "want")') or contains(egpl_kb_search_attachment.content,'"information"') OR contains(egpl_kb_search_attachment.content,'FORMSOF(INFLECTIONAL, "information")') or contains(egpl_kb_search_attachment.content,'"on"') OR contains(egpl_kb_search_attachment.content,'FORMSOF(INFLECTIONAL, "on")') or contains(egpl_kb_search_attachment.content,'"Diamond"') OR contains(egpl_kb_search_attachment.content,'FORMSOF(INFLECTIONAL, "Diamond")') or contains(egpl_kb_search_attachment.content,'"Ring"') OR contains(egpl_kb_search_attachment.content,'FORMSOF(INFLECTIONAL, "Ring")') or contains(egpl_kb_search_attachment.content
,'"want"') OR contains(egpl_kb_search_attachment.content,'FORMSOF(INFLECTIONAL, "want")') or contains(egpl_kb_search_attachment.content,'"information"') OR contains(egpl_kb_search_attachment.content,'FORMSOF(INFLECTIONAL, "information")') or contains(egpl_kb_search_attachment.content,'"on"') OR contains(egpl_kb_search_attachment.content,'FORMSOF(INFLECTIONAL, "on")') or contains(egpl_kb_search_attachment.content,'"Diamond"') OR contains(egpl_kb_search_attachment.content,'FORMSOF(INFLECTIONAL, "Diamond")') or contains(egpl_kb_search_attachment.content,'"Ring"') OR contains(egpl_kb_search_attachment.content,'FORMSOF(INFLECTIONAL, "Ring")') ) or ( contains(egpl_kb_search_attachment.attachment_name,'"want"') OR contains(egpl_kb_search_attachment.attachment_name,'FORMSOF(INFLECTIONAL, "want")') or contains(egpl_kb_search_attachment.attachment_name,'"information"') OR contains(egpl_kb_search_attachment.attachment_name,'FORMSOF(INFLECTIONAL, "information")') or contains(egpl_kb_search_attachment.attachment_na
me,'"on"') OR contains(egpl_kb_search_attachment.attachment_name,'FORMSOF(INFLECTIONAL, "on")') or contains(egpl_kb_search_attachment.attachment_name,'"Diamond"') OR contains(egpl_kb_search_attachment.attachment_name,'FORMSOF(INFLECTIONAL, "Diamond")') or contains(egpl_kb_search_attachment.attachment_name,'"Ring"') OR contains(egpl_kb_search_attachment.attachment_name,'FORMSOF(INFLECTIONAL, "Ring")') or contains(egpl_kb_search_attachment.attachment_name,'"want"') OR contains(egpl_kb_search_attachment.attachment_name,'FORMSOF(INFLECTIONAL, "want")') or contains(egpl_kb_search_attachment.attachment_name,'"information"') OR contains(egpl_kb_search_attachment.attachment_name,'FORMSOF(INFLECTIONAL, "information")') or contains(egpl_kb_search_attachment.attachment_name,'"on"') OR contains(egpl_kb_search_attachment.attachment_name,'FORMSOF(INFLECTIONAL, "on")') or contains(egpl_kb_search_attachment.attachment_name,'"Diamond"') OR contains(egpl_kb_search_attachment.attachment_name,'FORMSOF(INFLECTIONAL, "Diamo
nd")') or contains(egpl_kb_search_attachment.attachment_name,'"Ring"') OR contains(egpl_kb_search_attachment.attachment_name,'FORMSOF(INFLECTIONAL, "Ring")') ) ) ) AND ( egpl_kb_article.orig_article_id IN( SELECT egss_topic_links.child_id FROM egss_topic_links WHERE egss_topic_links.parent_id IN ( 1032 , 1040 , 1027 , 1034 , 1033 , 1046 , 1006 ) AND egss_topic_links.link_type = 1 AND egss_topic_links.is_deleted = 0 ) OR egpl_kb_article.orig_article_id IN ( SELECT egpl_link_category_article.item_id2 FROM egpl_link_category_article WHERE item_id1 IN ( -1 ) ) ) AND egpl_kb_article.commit_state != 3 AND egpl_kb_article.orig_article_id = egpl_kb_links.child_id AND egpl_kb_article.commit_state IN (1,4) AND egpl_kb_links.link_type = 2 AND egpl_kb_links.marked_delete = 0 AND DATEDIFF(day, GETDATE(),ISNULL( egpl_kb_article.expiry_date ,GETDATE() + 1)) >= 0