public static function getZoneByProducts()
{
$query = new DbQuery();
$query->select('id_product, id_product_attribute, wpl.id_warehouse_product_location,
id_wharehouse, location, id_erpip_warehouse_product_location, id_zone, id_zone_parent');
$query->from('warehouse_product_location', 'wpl');
$query->inner('erp_warehouse_product_location', 'ewpl', 'wpl.id_warehouse_product_location = ewpl.id_warehouse_product_location');
return Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($query);
}
