SELECT Causes Performance Issue
I'm guessing you don't have any covering indexes for the select columns.  Because your Count(*) runs faster, you probably have the columns in the joins or where clause indexed.  As soon as you add your select columns back, the query engine now has to scan the whole table again.  If possible, add the select columns as included columns to the indexes (not sure if this is ms sql server).