SELECT DISTINCT(items.id) as item_id, items.visibility FROM items LEFT JOIN iset_items ON iset_items.item_id=items.id AND iset_items.account_id=items.account_id LEFT JOIN item_types on items.item_type_id=item_types.id LEFT JOIN item_type_visibilities as itv ON items.item_type_id=itv.item_type_id AND items.account_id = itv.account_id WHERE items.account_id=33254 AND (items.visibility IS NULL OR items.visibility IN('P')) AND (SELECT COUNT(DISTINCT(item_custom_info.item_id)) FROM item_custom_info WHERE item_custom_info.item_id=items.id AND item_custom_info.account_id=items.account_id AND item_custom_info.lang_code='ESP') > 0 AND item_types.name='ListItem' AND items.status='A' AND items.deleted=0 AND iset_items.iset_id is null ORDER BY items.position ASC,items.date_create DESC LIMIT 4 OFFSET 0 Cartera de clientes - Hispanogas, S. A.

Cartera de clientes y últimas promociones

A continuación les mostramos las prestigiosas empresas para las que Hispanogas trabaja actualmente.

Para saber más de ellas y poder comprobar las promociones que se han ejecutado o en fase de obra mediante fotos demostrativas, pinche sobre el logo correspondiente.

Categorías

Subir
Web Design by Domestika