create table t1 (a int);

insert into t1 values (1),(2),(3),(4),(5);

select sql_no_cache * from t1 order by a limit 1; 

(select sql_no_cache * from t1 order by a) limit 1; #error

MariaDB [test]> select sql_no_cache * from t1 order by a limit 1; #

+------+

| a    |

+------+

|    1 |

+------+

1 row in set (0.000 sec)

MariaDB [test]> (select sql_no_cache * from t1 order by a) limit 1;

ERROR 1234 (42000): Incorrect usage/placement of 'SQL_NO_CACHE'