BUILDING QUERY SQL for PRESTASHOP

Hi, i need to integrate data.

This is my query:

SELECT CONCAT(LEFT(cu.`firstname`, 1), '. ', cu.`lastname`) AS `Cliente`, o.reference AS `Riferimento Ordine`, o.invoice_number AS `#OC`, o.total_paid_tax_incl AS `Totale tax incl.`, cur.iso_code AS `Valuta`, osl.name AS `Stato Ordine`, o.payment AS `Tipo Pagamento`, o.date_add AS `Data Ordine`,
(select GROUP_CONCAT(DISTINCT(cl.name) separator " , " ) from prstshp_order_detail ok LEFT JOIN prstshp_product k ON (k.id_product = ok.product_id) LEFT JOIN prstshp_category_lang cl ON (cl.id_category = k.id_category_default AND cl.id_lang = 1 ) WHERE ok.id_order = o.id_order ) as product_category FROM prstshp_orders o LEFT JOIN prstshp_customer cu ON o.id_customer = cu.id_customer LEFT JOIN prstshp_currency cur ON o.id_currency = cur.id_currency INNER JOIN prstshp_address a ON o.id_address_delivery = a.id_address LEFT JOIN prstshp_order_state os ON o.current_state = os.id_order_state LEFT JOIN prstshp_shop s ON o.id_shop = s.id_shop INNER JOIN prstshp_country c ON a.id_country = c.id_country INNER JOIN prstshp_country_lang cl ON c.id_country = cl.id_country AND cl.id_lang = 1 LEFT JOIN prstshp_order_state_lang osl ON os.id_order_state = osl.id_order_state AND osl.id_lang = 1 WHERE (o.`id_shop` IN ('1')) AND (o.`date_add` <= 'YEAR(CURDATE())') HAVING product_category like "%zevio%" ORDER BY o.`date_add` desc LIMIT 1000


i need to add this code from Custom Field Plugin support:
SELECT ................................, cfu.`field_value`
LEFT JOIN `custom_field_userdata` cfu ON (o.id_order = cfu.id_order)

If you also need titles of fields with user date than


SELECT ................................, cfu.`field_value`, cfl.`field_name`
LEFT JOIN `custom_field_userdata` cfu ON (o.id_order = cfu.id_order)
LEFT JOIN `custom_field_lang` cfl ON (cfl.id_custom_field = cfu.id_custom_field)