[SQL] Can you automate an SQL query in the database manager?

[Nickovitshj]

select ps_order_history.id_order, ps_order_history.date_add, ps_order_state_lang.name from ps_order_history INNER JOIN ps_order_state_lang ON ps_order_history.id_order_state=ps_order_state_lang.id_order_state where id_lang = 1 order by id_order, date_add;

I'd like to automatically export the .csv resulting from this SQL query.
Can this only be done through a php script?

If so, can anyone point me in the right direction regarding that?

Kind regards,
Nick

[Nickovitshj]

Thanks Crezzur, i'll be taking a look at this.

[Nickovitshj]

Works perfectly, 
his and sl are known PrestaShop shortcuts?

Any idea by any chance how we could get this file sent as an attachment over mail?

Regards,

Nick

[Nickovitshj]

2 hours ago, Nickovitshj said:

Works perfectly, 
his and sl are known PrestaShop shortcuts?

Any idea by any chance how we could get this file sent as an attachment over mail?

Regards,

Nick

Nevermind, I just noticed you set them as such.

The question about the email remains though.