Wcf-The maximum message size quota for incoming messages (65536) has been exceeded?

You should set maxReceivedMessageSize="2147483647" to increase message size. Try to change config to this:

 maxBufferSize="2147483647" 
         maxBufferPoolSize="2147483647" 
         maxReceivedMessageSize="2147483647">
     maxDepth="2147483647" 
                  maxStringContentLength="2147483647" 
                  maxArrayLength="2147483647" 
                  maxBytesPerRead="2147483647"
                  maxNameTableCharCount="2147483647" />

ref:

1) http://stackoverflow.com/questions/19564047/wcf-the-maximum-message-size-quota-for-incoming-messages-65536-has-been-exceed

2) http://weblogs.asp.net/hajan/transferring-large-data-when-using-web-services

sql server finding duplicate on one column but using select where

SELECT Id, Terms, Track, Active
FROM QueryData
WHERE Terms IN (
                SELECT Terms 
                FROM QueryData
                WHERE Track = 'Y' and Active = 'Y' 
                GROUP BY Terms
                HAVING COUNT(*) > 1
                )

SELECT ArticleId
FROM Image2Articles
WHERE ArticleId IN (
                SELECT ArticleId 
                FROM Image2Articles
                
                GROUP BY ArticleId
                HAVING COUNT(*) > 1
                )