SQL query built: SELECT TOP 7 "System.Kind","System.Search.Rank",path,"System.DateCreated","System.DateModified","System.Search.QueryPropertyHits","System.ItemNameDisplay","System.ItemFolderPathDisplay","System.FileExtension","System.ItemType","System.Communication.HeaderItem","System.Identity","System.Link.TargetParsingPath","System.Link.TargetUrl","System.Document.DateCreated","System.Document.DateSaved","System.Music.Artist","System.Music.AlbumTitle","System.Music.Genre","System.ImageParsingName" FROM SystemIndex WHERE  WITH (System.ItemNameDisplay, System.Music.Artist, System.Music.AlbumTitle) AS #MRProps (System.ItemNameDisplay = 'cmd' RANK BY COERCION(ABSOLUTE, 990) OR System.ItemNameDisplay LIKE 'cmd%' RANK BY COERCION(ABSOLUTE, 980) OR CONTAINS(System.ItemNameDisplay, '"cmd"') RANK BY COERCION(ABSOLUTE, 970) OR CONTAINS(System.ItemNameDisplay, '"cmd*"') RANK BY COERCION(ABSOLUTE, 960) OR System.Title = 'cmd' RANK BY COERCION(ABSOLUTE, 890) OR System.Title LIKE 'cmd%' RANK BY COERCION(ABSOLUTE, 880) OR CONTAINS(System.Title, '"cmd"') RANK BY COERCION(ABSOLUTE, 870) OR CONTAINS(System.Title, '"cmd*"') RANK BY COERCION(ABSOLUTE, 860) OR System.Music.Artist = 'cmd' RANK BY COERCION(ABSOLUTE, 790) OR CONTAINS(System.Music.Artist, '"cmd*"') RANK BY COERCION(ABSOLUTE, 760) OR System.Music.AlbumTitle = 'cmd' RANK BY COERCION(ABSOLUTE, 690) OR CONTAINS(System.Music.AlbumTitle, '"cmd*"') RANK BY COERCION(ABSOLUTE, 660)) AND "System.Kind" = SOME ARRAY['Movie', 'Picture', 'RecordedTV', 'Video', 'Music'] AND NOT System.Shell.SFGAOFlagsStrings = SOME ARRAY['hidden'] AND NOT System.Shell.SFGAOFlagsStrings = SOME ARRAY['system'] AND NOT System.Shell.SFGAOFlagsStrings = SOME ARRAY['link'] AND (System.Shell.SFGAOFlagsStrings = SOME ARRAY['stream'] OR (System.Shell.SFGAOFlagsStrings = SOME ARRAY['fileanc'] AND System.Shell.SFGAOFlagsStrings = SOME ARRAY['folder']) OR (System.Shell.SFGAOFlagsStrings = SOME ARRAY['storageanc'] AND System.Shell.SFGAOFlagsStrings = SOME ARRAY['folder'])) AND System.Shell.OmitFromView != 'true' AND ((Scope = 'file:C:\Users\Administrateur.WIN-38RD1HMBC6M') AND (Scope <> 'file:C:\Users\Administrateur.WIN-38RD1HMBC6M\AppData') AND (Scope <> 'mapi15://') OR (Scope = 'csc://{S-1-5-21-2178940685-1445718617-2171791796-500}') OR (Scope = 'file:C:\Users\Administrateur.WIN-38RD1HMBC6M\ReachitQF\Indexed' AND System.FileExtension = '.appcontent-ms')) ORDER BY "System.Search.Rank" DESC, "System.DateModified" DESC, "System.ItemNameDisplay" ASC
