export order details by SQL manager Prestasho 1.7.6

[rayleic]

hello friends,

There is export function of prestashop default system and here is the offcial docs http://doc.prestashop.com/display/PS17/SQL+Manager
I am trying to export below order details from date ** to date **. How to use SQL manager to do this? I followed the offcial docs but not working. Can anyone help?

Firstname,
Lastname,
Address1,
Address2,
City,
Zip code,
Country,
Product_name, 
TEL,
Reference,
SKU,
Quantity,
Order ID,

SELECT o.`id_order` AS `id`,
    CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) AS `Customer`,
    ca.`name` AS `Carrier`,
    cu.`name` AS `Currency`,
    o.`payment`, CONCAT(o.`total_paid_real`, ' ', cu.`sign`) AS `Total`,
    o.`date_add` AS `Date`
FROM `ps_orders` o
LEFT JOIN `ps_customer` c ON (o.`id_customer` = c.`id_customer`)
LEFT JOIN `ps_carrier` ca ON (o.id_carrier = ca.id_carrier)
LEFT JOIN `ps_currency` cu ON (o.`id_currency` = cu.`id_currency`)