Advanced Search

Return to Snippet

Revision: 31194
at September 1, 2010 01:22 by djc
Initial Code 
SELECT DISTINCT  [TLM_Body], [File], [Cat], [Filetype], [Description],  [EOMBegin], [Composer]
FROM [Files]
WHERE [Cat]='CMU' And ([TLM_Body]  < GETDATE()-0) And
	[FileType] In(1, 4) And
	(([File] Not Like '?*$#') And ([File] Not Like '?*$##')) ORDER BY [TLM_Body] DESC;
Initial URL 









Initial Description





Segregowanie po ostatnio dodanym (czas, TLM)









Initial Title





AV Inventory tab









Initial Tags














Initial Language





SQL