select distinct gives OperationalError, select distinctrow is ok

Code

nowym = datetime.now().strftime('%Y%m')

sql = f"SELECT distinct clientID FROM zgx_forecasting WHERE date_format(STR_TO_DATE(concat(Jaar,'',Maand,'-01'),'%Y%m-%d'),'%Y%m')>='

{nowym}' AND Productiviteitscode IN ('1','3','5','7','9') order by clientID"
csr.execute(sql)

returns mariadb.OperationalError: Unknown MySQL error

Code
sql = f"SELECT distinctrow clientID FROM zgx_forecasting WHERE date_format(STR_TO_DATE(concat(Jaar,'',Maand,'-01'),'%Y%m-%d'),'%Y%m')>='{nowym}

' AND Productiviteitscode IN ('1','3','5','7','9') order by clientID"
csr.execute(sql)

returns 388 rows

Does python/connector support distinctrow only?