Sql query works in workbench but not from code

I'm having an Issue with this query, it doesn't work in code, so it's probably an issue with mysql Connector/Net, i'm using the version 6.9.8 it's for .net 2.0, I'm using that old version because I'm working on an old app that uses .net 2.0. The query works in mysql workbench 6.3 CE, mysql server version is 5.7. The query:

SELECT * FROM (((tblApartmaniRezervacije AS T1 INNER JOIN tblApartmani AS T2 ON (T1.id_apartmana = T2.id_apartmana)) INNER JOIN tblPacijenti T3 ON T1.id_pacijenta = T3.id_pacijenta) INNER JOIN tblTerapije T4 ON T3.terapija = T4.id_terapije) INNER JOIN tblKorisnici T5 ON T1.sofer = T5.id_korisnika WHERE T1.status = true

formated query:

SELECT
  *
FROM
  (
    (
      (
        tblApartmaniRezervacije AS T1
        INNER JOIN tblApartmani AS T2 ON (T1.id_apartmana = T2.id_apartmana)
      )
      INNER JOIN tblPacijenti T3 ON T1.id_pacijenta = T3.id_pacijenta
    )
    INNER JOIN tblTerapije T4 ON T3.terapija = T4.id_terapije
  )
  INNER JOIN tblKorisnici T5 ON T1.sofer = T5.id_korisnika
WHERE
  T1.status = true

And the error:

Server Error in '/' Application.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Source Error:


Line 109:
Line 110:
Line 111:            myDataAdapter.Fill(myDataSet);
Line 112:
Line 113:            //myDataSet.Tables[0].Columns["imeiprezime"].ColumnName = "Ime i prezime";


Source File: c:\Users\Toni\documents\visual studio 2017\projects\scheduler-ostojic\scheduler-ostojic\Ajax\GetSampleDolasci.aspx.cs    Line: 111

Stack Trace:


[MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
   MySql.Data.MySqlClient.MySqlStream.ReadPacket() +281
   MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) +73
   MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) +20
   MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) +108
   MySql.Data.MySqlClient.MySqlDataReader.NextResult() +784
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +1485
   MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +130
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94
   EPPlusWebSample.GetSample.Page_Load(Object sender, EventArgs e) in GetSampleDolasci.aspx.cs:111
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


Version Information: Microsoft .NET Framework Version:2.0.50727.8935; ASP.NET Version:2.0.50727.8922 

Never mind, I found out that the code was adding some more text to the query later in the code.