Select via mariadb console not return all rows like system console

[manal_erpnext]

when i run the same sql statement in mariadb console and system console i get diff return as you see it the short screen

i not that the mariadb console return just as max 1000 rows