Steps to reproduce the issue

In JModelList I was using a query with a condition [where] that was put outside the limit making the query invalid:
SELECT t.id AS id, t.type AS type,t.code AS code,t.prodAlpha AS prodAlpha, t.retailerCode AS retailerCode,t.startDate AS startDate, t.endDate AS endDate,t.imageType AS imageType FROM [ApplicationImage] AS t WHERE t.type = 'BANNER'

Expected result

SELECT * FROM ( SELECT t.id AS id, t.type AS type,t.code AS code,t.prodAlpha AS prodAlpha, t.retailerCode AS retailerCode,t.startDate AS startDate, t.endDate AS endDate,t.imageType AS imageType , ROW_NUMBER() OVER (ORDER BY t.id desc) AS RowNumber FROM [ApplicationImage] AS t WHERE t.type = 'BANNER') _myResults WHERE RowNumber BETWEEN 1 AND 20

Actual result

SELECT * FROM ( SELECT t.id AS id, t.type AS type,t.code AS code,t.prodAlpha AS prodAlpha, t.retailerCode AS retailerCode,t.startDate AS startDate, t.endDate AS endDate,t.imageType AS imageType , ROW_NUMBER() OVER (ORDER BY t.id desc) AS RowNumber FROM [ApplicationImage] AS t ) _myResults WHERE RowNumber BETWEEN 1 AND 20 WHERE t.type = 'BANNER'

System information (as much as possible)

Joomla! 3.3.3

Additional comments

Moving lines 70-78 on "\libraries\joomla\database\query\sqlsrv.php" to before the break did the trick for me