SQL query built: SELECT TOP 3 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.VisitCount", "System.ItemUrl" FROM SystemIndex..SCOPE()  WHERE  SCOPE='file:C:\Users\ashok\Favorites\'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Title", '"se*"',1033) RANK BY COERCION(Absolute, 500)) ) OR ((CONTAINS("System.ItemFolderNameDisplay", '"se*"',1033) RANK BY COERCION(Absolute, 400)) ) OR ((CONTAINS("System.Link.TargetUrlHostName", '"se*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"se*"',1033) RANK BY COERCION(Absolute, 75)) )) ORDER BY "System.History.SelectionCount" DESC , "System.Search.Rank" DESC , "System.History.VisitCount" DESC 
SQL query built: SELECT TOP 4 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.SelectionCount" FROM SystemIndex..SCOPE()  WHERE  SCOPE='iehistory://{S-1-5-21-4174240206-1519593306-1207757718-1001}/'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Link.TargetUrlHostName", '"se*"',1033) RANK BY COERCION(Absolute, 250)) ) OR ((CONTAINS("System.Title", '"se*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"se*"',1033) RANK BY COERCION(Absolute, 100)) )) ORDER BY "System.History.SelectionCount" DESC , "System.History.VisitCount" DESC , "System.Search.Rank" DESC 
SQL query built: SELECT TOP 4 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.SelectionCount" FROM SystemIndex..SCOPE()  WHERE  SCOPE='iehistory://{S-1-5-21-4174240206-1519593306-1207757718-1001}/'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Link.TargetUrlHostName", '"pe*"',1033) RANK BY COERCION(Absolute, 250)) ) OR ((CONTAINS("System.Title", '"pe*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"pe*"',1033) RANK BY COERCION(Absolute, 100)) )) ORDER BY "System.History.SelectionCount" DESC , "System.History.VisitCount" DESC , "System.Search.Rank" DESC 
SQL query built: SELECT TOP 3 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.VisitCount", "System.ItemUrl" FROM SystemIndex..SCOPE()  WHERE  SCOPE='file:C:\Users\ashok\Favorites\'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Title", '"go*"',1033) RANK BY COERCION(Absolute, 500)) ) OR ((CONTAINS("System.ItemFolderNameDisplay", '"go*"',1033) RANK BY COERCION(Absolute, 400)) ) OR ((CONTAINS("System.Link.TargetUrlHostName", '"go*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"go*"',1033) RANK BY COERCION(Absolute, 75)) )) ORDER BY "System.History.SelectionCount" DESC , "System.Search.Rank" DESC , "System.History.VisitCount" DESC 
RESOLVE NODATE CONDITION:
<CompoundCondition conditionType="and">
  <CompoundCondition conditionType="or">
    <CompoundCondition conditionType="and">
      <NegationCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="4722688" type="System.StructuredQueryType.AnyBitsSet">
        </LeafCondition>
      </NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="536870912" type="System.StructuredQueryType.AllBitsSet">
      </LeafCondition>
      <CompoundCondition conditionType="or">
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2147483658">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354572">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354563">
        </LeafCondition>
        <NegationCondition>
          <LeafCondition localeName="">
            <Property name="System.SFGAOFlags">
            <Operation op="ApplicationSpecific">
            <Value normalized="65536" type="System.StructuredQueryType.AllBitsSet">
          </LeafCondition>
        </NegationCondition>
      </CompoundCondition>
    </CompoundCondition>
    <NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="593920" type="System.StructuredQueryType.AnyBitsSet">
      </LeafCondition>
    </NegationCondition>
  </CompoundCondition>
  <CompoundCondition conditionType="or">
    <CompoundCondition conditionType="and">
      <NegationCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="4194304" type="System.StructuredQueryType.AllBitsSet">
        </LeafCondition>
      </NegationCondition>
      <CompoundCondition conditionType="or">
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="805306368" type="System.StructuredQueryType.AllBitsSet">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="545259520" type="System.StructuredQueryType.AllBitsSet">
        </LeafCondition>
      </CompoundCondition>
    </CompoundCondition>
  </CompoundCondition>
</CompoundCondition>
END
SUCCESS RESULT:
<CompoundCondition conditionType="and">
  <CompoundCondition conditionType="or">
    <CompoundCondition conditionType="and">
      <NegationCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="4722688" type="System.StructuredQueryType.AnyBitsSet">
        </LeafCondition>
      </NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="536870912" type="System.StructuredQueryType.AllBitsSet">
      </LeafCondition>
      <CompoundCondition conditionType="or">
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2147483658">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354572">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354563">
        </LeafCondition>
        <NegationCondition>
          <LeafCondition localeName="">
            <Property name="System.SFGAOFlags">
            <Operation op="ApplicationSpecific">
            <Value normalized="65536" type="System.StructuredQueryType.AllBitsSet">
          </LeafCondition>
        </NegationCondition>
      </CompoundCondition>
    </CompoundCondition>
    <NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="593920" type="System.StructuredQueryType.AnyBitsSet">
      </LeafCondition>
    </NegationCondition>
  </CompoundCondition>
  <NegationCondition>
    <LeafCondition localeName="">
      <Property name="System.SFGAOFlags">
      <Operation op="ApplicationSpecific">
      <Value normalized="4194304" type="System.StructuredQueryType.AllBitsSet">
    </LeafCondition>
  </NegationCondition>
  <CompoundCondition conditionType="or">
    <LeafCondition localeName="">
      <Property name="System.SFGAOFlags">
      <Operation op="ApplicationSpecific">
      <Value normalized="805306368" type="System.StructuredQueryType.AllBitsSet">
    </LeafCondition>
    <LeafCondition localeName="">
      <Property name="System.SFGAOFlags">
      <Operation op="ApplicationSpecific">
      <Value normalized="545259520" type="System.StructuredQueryType.AllBitsSet">
    </LeafCondition>
  </CompoundCondition>
</CompoundCondition>
END
Elapsed time (microseconds): 409.989926
SQL query built: SELECT TOP 4 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.SelectionCount" FROM SystemIndex..SCOPE()  WHERE  SCOPE='iehistory://{S-1-5-21-4174240206-1519593306-1207757718-1001}/'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Link.TargetUrlHostName", '"goo*"',1033) RANK BY COERCION(Absolute, 250)) ) OR ((CONTAINS("System.Title", '"goo*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"goo*"',1033) RANK BY COERCION(Absolute, 100)) )) ORDER BY "System.History.SelectionCount" DESC , "System.History.VisitCount" DESC , "System.Search.Rank" DESC 
SQL query built: SELECT TOP 4 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.SelectionCount" FROM SystemIndex..SCOPE()  WHERE  SCOPE='iehistory://{S-1-5-21-4174240206-1519593306-1207757718-1001}/'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Link.TargetUrlHostName", '"go*"',1033) RANK BY COERCION(Absolute, 250)) ) OR ((CONTAINS("System.Title", '"go*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"go*"',1033) RANK BY COERCION(Absolute, 100)) )) ORDER BY "System.History.SelectionCount" DESC , "System.History.VisitCount" DESC , "System.Search.Rank" DESC 
SQL query built: SELECT TOP 3 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.VisitCount", "System.ItemUrl" FROM SystemIndex..SCOPE()  WHERE  SCOPE='file:C:\Users\ashok\Favorites\'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Title", '"mi*"',1033) RANK BY COERCION(Absolute, 500)) ) OR ((CONTAINS("System.ItemFolderNameDisplay", '"mi*"',1033) RANK BY COERCION(Absolute, 400)) ) OR ((CONTAINS("System.Link.TargetUrlHostName", '"mi*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"mi*"',1033) RANK BY COERCION(Absolute, 75)) )) ORDER BY "System.History.SelectionCount" DESC , "System.Search.Rank" DESC , "System.History.VisitCount" DESC 
SQL query built: SELECT TOP 3 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.VisitCount", "System.ItemUrl" FROM SystemIndex..SCOPE()  WHERE  SCOPE='file:C:\Users\ashok\Favorites\'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Title", '"se*"',1033) RANK BY COERCION(Absolute, 500)) ) OR ((CONTAINS("System.ItemFolderNameDisplay", '"se*"',1033) RANK BY COERCION(Absolute, 400)) ) OR ((CONTAINS("System.Link.TargetUrlHostName", '"se*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"se*"',1033) RANK BY COERCION(Absolute, 75)) )) ORDER BY "System.History.SelectionCount" DESC , "System.Search.Rank" DESC , "System.History.VisitCount" DESC 
RESOLVE NODATE CONDITION:
<CompoundCondition conditionType="and">
  <CompoundCondition conditionType="or">
    <CompoundCondition conditionType="and">
      <NegationCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="4722688" type="System.StructuredQueryType.AnyBitsSet">
        </LeafCondition>
      </NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="536870912" type="System.StructuredQueryType.AllBitsSet">
      </LeafCondition>
      <CompoundCondition conditionType="or">
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2147483658">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354572">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354563">
        </LeafCondition>
        <NegationCondition>
          <LeafCondition localeName="">
            <Property name="System.SFGAOFlags">
            <Operation op="ApplicationSpecific">
            <Value normalized="65536" type="System.StructuredQueryType.AllBitsSet">
          </LeafCondition>
        </NegationCondition>
      </CompoundCondition>
    </CompoundCondition>
    <NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="593920" type="System.StructuredQueryType.AnyBitsSet">
      </LeafCondition>
    </NegationCondition>
  </CompoundCondition>
  <CompoundCondition conditionType="or">
    <CompoundCondition conditionType="and">
      <NegationCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="4194304" type="System.StructuredQueryType.AllBitsSet">
        </LeafCondition>
      </NegationCondition>
      <CompoundCondition conditionType="or">
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="805306368" type="System.StructuredQueryType.AllBitsSet">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="545259520" type="System.StructuredQueryType.AllBitsSet">
        </LeafCondition>
      </CompoundCondition>
    </CompoundCondition>
  </CompoundCondition>
</CompoundCondition>
END
SUCCESS RESULT:
<CompoundCondition conditionType="and">
  <CompoundCondition conditionType="or">
    <CompoundCondition conditionType="and">
      <NegationCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="4722688" type="System.StructuredQueryType.AnyBitsSet">
        </LeafCondition>
      </NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="536870912" type="System.StructuredQueryType.AllBitsSet">
      </LeafCondition>
      <CompoundCondition conditionType="or">
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2147483658">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354572">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354563">
        </LeafCondition>
        <NegationCondition>
          <LeafCondition localeName="">
            <Property name="System.SFGAOFlags">
            <Operation op="ApplicationSpecific">
            <Value normalized="65536" type="System.StructuredQueryType.AllBitsSet">
          </LeafCondition>
        </NegationCondition>
      </CompoundCondition>
    </CompoundCondition>
    <NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="593920" type="System.StructuredQueryType.AnyBitsSet">
      </LeafCondition>
    </NegationCondition>
  </CompoundCondition>
  <NegationCondition>
    <LeafCondition localeName="">
      <Property name="System.SFGAOFlags">
      <Operation op="ApplicationSpecific">
      <Value normalized="4194304" type="System.StructuredQueryType.AllBitsSet">
    </LeafCondition>
  </NegationCondition>
  <CompoundCondition conditionType="or">
    <LeafCondition localeName="">
      <Property name="System.SFGAOFlags">
      <Operation op="ApplicationSpecific">
      <Value normalized="805306368" type="System.StructuredQueryType.AllBitsSet">
    </LeafCondition>
    <LeafCondition localeName="">
      <Property name="System.SFGAOFlags">
      <Operation op="ApplicationSpecific">
      <Value normalized="545259520" type="System.StructuredQueryType.AllBitsSet">
    </LeafCondition>
  </CompoundCondition>
</CompoundCondition>
END
Elapsed time (microseconds): 115.056586
RESOLVE NODATE CONDITION:
<CompoundCondition conditionType="and">
  <CompoundCondition conditionType="or">
    <CompoundCondition conditionType="and">
      <NegationCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="4722688" type="System.StructuredQueryType.AnyBitsSet">
        </LeafCondition>
      </NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="536870912" type="System.StructuredQueryType.AllBitsSet">
      </LeafCondition>
      <CompoundCondition conditionType="or">
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2147483658">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354572">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354563">
        </LeafCondition>
        <NegationCondition>
          <LeafCondition localeName="">
            <Property name="System.SFGAOFlags">
            <Operation op="ApplicationSpecific">
            <Value normalized="65536" type="System.StructuredQueryType.AllBitsSet">
          </LeafCondition>
        </NegationCondition>
      </CompoundCondition>
    </CompoundCondition>
    <NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="593920" type="System.StructuredQueryType.AnyBitsSet">
      </LeafCondition>
    </NegationCondition>
  </CompoundCondition>
  <CompoundCondition conditionType="or">
    <CompoundCondition conditionType="and">
      <NegationCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="4194304" type="System.StructuredQueryType.AllBitsSet">
        </LeafCondition>
      </NegationCondition>
      <CompoundCondition conditionType="or">
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="805306368" type="System.StructuredQueryType.AllBitsSet">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="545259520" type="System.StructuredQueryType.AllBitsSet">
        </LeafCondition>
      </CompoundCondition>
    </CompoundCondition>
  </CompoundCondition>
</CompoundCondition>
END
SUCCESS RESULT:
<CompoundCondition conditionType="and">
  <CompoundCondition conditionType="or">
    <CompoundCondition conditionType="and">
      <NegationCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="4722688" type="System.StructuredQueryType.AnyBitsSet">
        </LeafCondition>
      </NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="536870912" type="System.StructuredQueryType.AllBitsSet">
      </LeafCondition>
      <CompoundCondition conditionType="or">
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2147483658">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354572">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354563">
        </LeafCondition>
        <NegationCondition>
          <LeafCondition localeName="">
            <Property name="System.SFGAOFlags">
            <Operation op="ApplicationSpecific">
            <Value normalized="65536" type="System.StructuredQueryType.AllBitsSet">
          </LeafCondition>
        </NegationCondition>
      </CompoundCondition>
    </CompoundCondition>
    <NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="593920" type="System.StructuredQueryType.AnyBitsSet">
      </LeafCondition>
    </NegationCondition>
  </CompoundCondition>
  <NegationCondition>
    <LeafCondition localeName="">
      <Property name="System.SFGAOFlags">
      <Operation op="ApplicationSpecific">
      <Value normalized="4194304" type="System.StructuredQueryType.AllBitsSet">
    </LeafCondition>
  </NegationCondition>
  <CompoundCondition conditionType="or">
    <LeafCondition localeName="">
      <Property name="System.SFGAOFlags">
      <Operation op="ApplicationSpecific">
      <Value normalized="805306368" type="System.StructuredQueryType.AllBitsSet">
    </LeafCondition>
    <LeafCondition localeName="">
      <Property name="System.SFGAOFlags">
      <Operation op="ApplicationSpecific">
      <Value normalized="545259520" type="System.StructuredQueryType.AllBitsSet">
    </LeafCondition>
  </CompoundCondition>
</CompoundCondition>
END
Elapsed time (microseconds): 376.499516
SQL query built: SELECT TOP 3 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.VisitCount", "System.ItemUrl" FROM SystemIndex..SCOPE()  WHERE  SCOPE='file:C:\Users\ashok\Favorites\'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Title", '"gm*"',1033) RANK BY COERCION(Absolute, 500)) ) OR ((CONTAINS("System.ItemFolderNameDisplay", '"gm*"',1033) RANK BY COERCION(Absolute, 400)) ) OR ((CONTAINS("System.Link.TargetUrlHostName", '"gm*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"gm*"',1033) RANK BY COERCION(Absolute, 75)) )) ORDER BY "System.History.SelectionCount" DESC , "System.Search.Rank" DESC , "System.History.VisitCount" DESC 
RESOLVE NODATE CONDITION:
<CompoundCondition conditionType="and">
  <CompoundCondition conditionType="or">
    <CompoundCondition conditionType="and">
      <NegationCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="4722688" type="System.StructuredQueryType.AnyBitsSet">
        </LeafCondition>
      </NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="536870912" type="System.StructuredQueryType.AllBitsSet">
      </LeafCondition>
      <CompoundCondition conditionType="or">
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2147483658">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354572">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354563">
        </LeafCondition>
        <NegationCondition>
          <LeafCondition localeName="">
            <Property name="System.SFGAOFlags">
            <Operation op="ApplicationSpecific">
            <Value normalized="65536" type="System.StructuredQueryType.AllBitsSet">
          </LeafCondition>
        </NegationCondition>
      </CompoundCondition>
    </CompoundCondition>
    <NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="593920" type="System.StructuredQueryType.AnyBitsSet">
      </LeafCondition>
    </NegationCondition>
  </CompoundCondition>
  <CompoundCondition conditionType="or">
    <CompoundCondition conditionType="and">
      <NegationCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="4194304" type="System.StructuredQueryType.AllBitsSet">
        </LeafCondition>
      </NegationCondition>
      <CompoundCondition conditionType="or">
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="805306368" type="System.StructuredQueryType.AllBitsSet">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="545259520" type="System.StructuredQueryType.AllBitsSet">
        </LeafCondition>
      </CompoundCondition>
    </CompoundCondition>
  </CompoundCondition>
</CompoundCondition>
END
SUCCESS RESULT:
<CompoundCondition conditionType="and">
  <CompoundCondition conditionType="or">
    <CompoundCondition conditionType="and">
      <NegationCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="4722688" type="System.StructuredQueryType.AnyBitsSet">
        </LeafCondition>
      </NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="536870912" type="System.StructuredQueryType.AllBitsSet">
      </LeafCondition>
      <CompoundCondition conditionType="or">
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2147483658">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354572">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354563">
        </LeafCondition>
        <NegationCondition>
          <LeafCondition localeName="">
            <Property name="System.SFGAOFlags">
            <Operation op="ApplicationSpecific">
            <Value normalized="65536" type="System.StructuredQueryType.AllBitsSet">
          </LeafCondition>
        </NegationCondition>
      </CompoundCondition>
    </CompoundCondition>
    <NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="593920" type="System.StructuredQueryType.AnyBitsSet">
      </LeafCondition>
    </NegationCondition>
  </CompoundCondition>
  <NegationCondition>
    <LeafCondition localeName="">
      <Property name="System.SFGAOFlags">
      <Operation op="ApplicationSpecific">
      <Value normalized="4194304" type="System.StructuredQueryType.AllBitsSet">
    </LeafCondition>
  </NegationCondition>
  <CompoundCondition conditionType="or">
    <LeafCondition localeName="">
      <Property name="System.SFGAOFlags">
      <Operation op="ApplicationSpecific">
      <Value normalized="805306368" type="System.StructuredQueryType.AllBitsSet">
    </LeafCondition>
    <LeafCondition localeName="">
      <Property name="System.SFGAOFlags">
      <Operation op="ApplicationSpecific">
      <Value normalized="545259520" type="System.StructuredQueryType.AllBitsSet">
    </LeafCondition>
  </CompoundCondition>
</CompoundCondition>
END
Elapsed time (microseconds): 106.413723
RESOLVE NODATE CONDITION:
<CompoundCondition conditionType="and">
  <CompoundCondition conditionType="or">
    <CompoundCondition conditionType="and">
      <NegationCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="4722688" type="System.StructuredQueryType.AnyBitsSet">
        </LeafCondition>
      </NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="536870912" type="System.StructuredQueryType.AllBitsSet">
      </LeafCondition>
      <CompoundCondition conditionType="or">
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2147483658">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354572">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354563">
        </LeafCondition>
        <NegationCondition>
          <LeafCondition localeName="">
            <Property name="System.SFGAOFlags">
            <Operation op="ApplicationSpecific">
            <Value normalized="65536" type="System.StructuredQueryType.AllBitsSet">
          </LeafCondition>
        </NegationCondition>
      </CompoundCondition>
    </CompoundCondition>
    <NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="593920" type="System.StructuredQueryType.AnyBitsSet">
      </LeafCondition>
    </NegationCondition>
  </CompoundCondition>
  <CompoundCondition conditionType="or">
    <CompoundCondition conditionType="and">
      <NegationCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="4194304" type="System.StructuredQueryType.AllBitsSet">
        </LeafCondition>
      </NegationCondition>
      <CompoundCondition conditionType="or">
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="805306368" type="System.StructuredQueryType.AllBitsSet">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="545259520" type="System.StructuredQueryType.AllBitsSet">
        </LeafCondition>
      </CompoundCondition>
    </CompoundCondition>
  </CompoundCondition>
</CompoundCondition>
END
SUCCESS RESULT:
<CompoundCondition conditionType="and">
  <CompoundCondition conditionType="or">
    <CompoundCondition conditionType="and">
      <NegationCondition>
        <LeafCondition localeName="">
          <Property name="System.SFGAOFlags">
          <Operation op="ApplicationSpecific">
          <Value normalized="4722688" type="System.StructuredQueryType.AnyBitsSet">
        </LeafCondition>
      </NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="536870912" type="System.StructuredQueryType.AllBitsSet">
      </LeafCondition>
      <CompoundCondition conditionType="or">
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2147483658">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354572">
        </LeafCondition>
        <LeafCondition localeName="">
          <Property name="System.FileReparsePointTag">
          <Operation op="Equal">
          <Value normalized="2684354563">
        </LeafCondition>
        <NegationCondition>
          <LeafCondition localeName="">
            <Property name="System.SFGAOFlags">
            <Operation op="ApplicationSpecific">
            <Value normalized="65536" type="System.StructuredQueryType.AllBitsSet">
          </LeafCondition>
        </NegationCondition>
      </CompoundCondition>
    </CompoundCondition>
    <NegationCondition>
      <LeafCondition localeName="">
        <Property name="System.SFGAOFlags">
        <Operation op="ApplicationSpecific">
        <Value normalized="593920" type="System.StructuredQueryType.AnyBitsSet">
      </LeafCondition>
    </NegationCondition>
  </CompoundCondition>
  <NegationCondition>
    <LeafCondition localeName="">
      <Property name="System.SFGAOFlags">
      <Operation op="ApplicationSpecific">
      <Value normalized="4194304" type="System.StructuredQueryType.AllBitsSet">
    </LeafCondition>
  </NegationCondition>
  <CompoundCondition conditionType="or">
    <LeafCondition localeName="">
      <Property name="System.SFGAOFlags">
      <Operation op="ApplicationSpecific">
      <Value normalized="805306368" type="System.StructuredQueryType.AllBitsSet">
    </LeafCondition>
    <LeafCondition localeName="">
      <Property name="System.SFGAOFlags">
      <Operation op="ApplicationSpecific">
      <Value normalized="545259520" type="System.StructuredQueryType.AllBitsSet">
    </LeafCondition>
  </CompoundCondition>
</CompoundCondition>
END
Elapsed time (microseconds): 85.347046
SQL query built: SELECT TOP 4 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.SelectionCount" FROM SystemIndex..SCOPE()  WHERE  SCOPE='iehistory://{S-1-5-21-4174240206-1519593306-1207757718-1001}/'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Link.TargetUrlHostName", '"go*"',1033) RANK BY COERCION(Absolute, 250)) ) OR ((CONTAINS("System.Title", '"go*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"go*"',1033) RANK BY COERCION(Absolute, 100)) )) ORDER BY "System.History.SelectionCount" DESC , "System.History.VisitCount" DESC , "System.Search.Rank" DESC 
SQL query built: SELECT TOP 4 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.SelectionCount" FROM SystemIndex..SCOPE()  WHERE  SCOPE='iehistory://{S-1-5-21-4174240206-1519593306-1207757718-1001}/'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Link.TargetUrlHostName", '"yo*"',1033) RANK BY COERCION(Absolute, 250)) ) OR ((CONTAINS("System.Title", '"yo*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"yo*"',1033) RANK BY COERCION(Absolute, 100)) )) ORDER BY "System.History.SelectionCount" DESC , "System.History.VisitCount" DESC , "System.Search.Rank" DESC 
SQL query built: SELECT TOP 3 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.VisitCount", "System.ItemUrl" FROM SystemIndex..SCOPE()  WHERE  SCOPE='file:C:\Users\ashok\Favorites\'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Title", '"yo*"',1033) RANK BY COERCION(Absolute, 500)) ) OR ((CONTAINS("System.ItemFolderNameDisplay", '"yo*"',1033) RANK BY COERCION(Absolute, 400)) ) OR ((CONTAINS("System.Link.TargetUrlHostName", '"yo*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"yo*"',1033) RANK BY COERCION(Absolute, 75)) )) ORDER BY "System.History.SelectionCount" DESC , "System.Search.Rank" DESC , "System.History.VisitCount" DESC 
SQL query built: SELECT TOP 3 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.VisitCount", "System.ItemUrl" FROM SystemIndex..SCOPE()  WHERE  SCOPE='file:C:\Users\ashok\Favorites\'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Title", '"se*"',1033) RANK BY COERCION(Absolute, 500)) ) OR ((CONTAINS("System.ItemFolderNameDisplay", '"se*"',1033) RANK BY COERCION(Absolute, 400)) ) OR ((CONTAINS("System.Link.TargetUrlHostName", '"se*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"se*"',1033) RANK BY COERCION(Absolute, 75)) )) ORDER BY "System.History.SelectionCount" DESC , "System.Search.Rank" DESC , "System.History.VisitCount" DESC 
SQL query built: SELECT TOP 3 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.VisitCount", "System.ItemUrl" FROM SystemIndex..SCOPE()  WHERE  SCOPE='file:C:\Users\ashok\Favorites\'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Title", '"gm*"',1033) RANK BY COERCION(Absolute, 500)) ) OR ((CONTAINS("System.ItemFolderNameDisplay", '"gm*"',1033) RANK BY COERCION(Absolute, 400)) ) OR ((CONTAINS("System.Link.TargetUrlHostName", '"gm*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"gm*"',1033) RANK BY COERCION(Absolute, 75)) )) ORDER BY "System.History.SelectionCount" DESC , "System.Search.Rank" DESC , "System.History.VisitCount" DESC 
SQL query built: SELECT TOP 4 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.SelectionCount" FROM SystemIndex..SCOPE()  WHERE  SCOPE='iehistory://{S-1-5-21-4174240206-1519593306-1207757718-1001}/'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Link.TargetUrlHostName", '"gm*"',1033) RANK BY COERCION(Absolute, 250)) ) OR ((CONTAINS("System.Title", '"gm*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"gm*"',1033) RANK BY COERCION(Absolute, 100)) )) ORDER BY "System.History.SelectionCount" DESC , "System.History.VisitCount" DESC , "System.Search.Rank" DESC 
SQL query built: SELECT TOP 3 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.VisitCount", "System.ItemUrl" FROM SystemIndex..SCOPE()  WHERE  SCOPE='file:C:\Users\ashok\Favorites\'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Title", '"se*"',1033) RANK BY COERCION(Absolute, 500)) ) OR ((CONTAINS("System.ItemFolderNameDisplay", '"se*"',1033) RANK BY COERCION(Absolute, 400)) ) OR ((CONTAINS("System.Link.TargetUrlHostName", '"se*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"se*"',1033) RANK BY COERCION(Absolute, 75)) )) ORDER BY "System.History.SelectionCount" DESC , "System.Search.Rank" DESC , "System.History.VisitCount" DESC 
SQL query built: SELECT TOP 4 "System.Link.TargetUrl", "System.ItemPathDisplay", "System.Title", "System.History.SelectionCount" FROM SystemIndex..SCOPE()  WHERE  SCOPE='iehistory://{S-1-5-21-4174240206-1519593306-1207757718-1001}/'  AND ((NOT CONTAINS("System.ItemType",'"Folder"') AND NOT CONTAINS("System.ItemType",'"Directory"'))) AND (((CONTAINS("System.Link.TargetUrlHostName", '"gmail*"',1033) RANK BY COERCION(Absolute, 250)) ) OR ((CONTAINS("System.Title", '"gmail*"',1033) RANK BY COERCION(Absolute, 150)) ) OR ((CONTAINS("System.Link.TargetUrlPath", '"gmail*"',1033) RANK BY COERCION(Absolute, 100)) )) ORDER BY "System.History.SelectionCount" DESC , "System.History.VisitCount" DESC , "System.Search.Rank" DESC