select @@version
-- Microsoft SQL Server 2012 (SP3) (KB3072779) - 11.0.6020.0 (X64)   Oct 20 2015 15:36:27   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 15063: ) 

exec sp_executesql N'select  a.id
                                                    ,a.flightNo flightno
                                                    ,a.name afml
                                                    ,isnull(pf.name,'''')+isnull('' (''+pf.IcaoCode+'')'','''') placefrom
                                                    ,isnull(pt.name,'''')+isnull('' (''+pt.IcaoCode+'')'','''') placeto
                                                    ,a.date
                                                    ,(select count(1) from loglistattachment lla where lla.list=a.id) acount
                                            from afml a
                                            left join mainFlight ls on ls.afml=a.id 
                                            left join places pf on pf.id=ls.place_from
                                            left join places pt on pt.id=ls.place_to
                                            where 1=1 
                                                and a.date between @dateFrom and @dateTo
                                                and a.MSN=@ac
                                            order by a.date desc,ls.id desc',N'@ac nvarchar(1),@dateFrom nvarchar(10),@dateTo nvarchar(10)',@ac=N'6',@dateFrom=N'29.10.2017',@dateTo=N'17.11.2017'
go