sql prestashop get product quantity by combination and warehouse

prestashop mysql query

SELECT pat.id_product
,prdl.name
,wloc.id_warehouse_product_location
,w.name
,s.quantity
, prd.reference

    , GROUP_CONCAT(DISTINCT(concat(pal.name, ":", atg.position)) SEPARATOR ", ") as combinación

 FROM ps_product_attribute pat
INNER JOIN ps_product prd ON (prd.id_product = pat.id_product)
left join ps_product_lang prdl on prd.id_product =  prdl.id_product AND prdl.id_lang=1 
 LEFT JOIN ps_product_attribute_combination pac ON (pat.id_product_attribute = pac.id_product_attribute)
 LEFT JOIN ps_attribute att ON (pac.id_attribute = att.id_attribute)
 LEFT JOIN ps_attribute_group atg ON ( atg.id_attribute_group = att.id_attribute_group)
 LEFT JOIN ps_attribute_group_lang atgl ON ( atgl.id_attribute_group = atg.id_attribute_group)
 LEFT JOIN ps_attribute_lang pal ON (pac.id_attribute = pal.id_attribute AND pal.id_lang = atgl.id_lang)
left join ps_warehouse_product_location wloc on prd.id_product = wloc.id_product
left join ps_warehouse w on wloc.id_warehouse =w.id_warehouse
LEFT JOIN ps_stock_available s ON (prd.id_product = s.id_product)
WHERE atgl.id_lang = 1 
GROUP BY pat.id_product_attribute
ORDER BY pat.id_product, pac.id_attribute