Custom SQL query only yields partial results while the query yields all the results in MS SQL Server

select * from transactionlog where (transactionname in ('marketgetbranches', 'marketgetareas', 'marketcopy') )
or (parameters like '%source=market%') or (parameters like '%market=1%')

This query in MS SQL Server gives me multiple values of transactionname, but only one value when I run it as a custom SQL query in Tableau. Does anyone have any idea of where this problem could be coming from if it's a general Tableau issue?