Email Field Usage in Search Query

emailsearch.sql

--Mailing Date (From)
SELECT COUNT([Key]) AS 'Mailing Date (From)'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'xc5058da56e9f4f2fa106b7cdea923936';

--Mailing Date (To)
SELECT COUNT([Key]) AS 'Mailing Date (To)'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'xe4eb014c1fc8412781da08879a631144';

--Email Name
SELECT COUNT([Key]) AS 'Email Name'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'xb3fbaac8f7b4418ca84a646526777a15';

--Split Name
SELECT COUNT([Key]) AS 'Split Name'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'x1F0AF02B93BF46F0A7DC351B78A7507A';

--Email Subject Line
SELECT COUNT([Key]) AS 'Email Subject Line'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'xd867e7d2bede4611aeb5a9a1e0952795';

--Clicked URL
SELECT COUNT([Key]) AS 'Clicked URL'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'x40c2135cfd2d4ea1847bb2028d015593';

--Created By
SELECT COUNT([Key]) AS 'Created By'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'xf25ee2090b1546af99bbf172aca5a9b0';

--Created On (From)
SELECT COUNT([Key]) AS 'Created On (From)'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'xb906600c68184a1e976754bf42474186';

--Created On (To)
SELECT COUNT([Key]) AS 'Created On (To)'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'b31a66507c83481189a116edfb685266';

--Email List
SELECT COUNT([Key]) AS 'Email List'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'x0e59eb12e61f4266918707c1cf18388e';

--Forward To A Friend
SELECT COUNT([Key]) AS 'Forward To A Friend'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'xf1d37cc72e4f4b458c62bbcd74a55da9';

--Message Failed
SELECT COUNT([Key]) AS 'Message Failed'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'xfd45368f078d4924baaa568f1948bcb0';

--Message Sent
SELECT COUNT([Key]) AS 'Message Sent'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'x626e13c91fc6472fbc46a9874b535b1a';

--Opened
SELECT COUNT([Key]) AS 'Opened'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'xb3c4debcf596413e8d1fa23f3680c165';

--Unsubscribed
SELECT COUNT([Key]) AS 'Unsubscribed'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'xce9a1cc969bc4e958013dae00868325d';

--Count of Email Messages (Min)
SELECT COUNT([Key]) AS 'Count of Email Messages (Min)'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'xfc13f992f9e645c2ad2a236fcf57e107';

--Count of Email Messages (Max)
SELECT COUNT([Key]) AS 'Count of Email Messages (Max)'
FROM dbo.QueryTemplateParameter (NOLOCK)	
WHERE [Key] = 'xe87a35bad75240fd8aa7de5aea0916e3';