SELECT `vtiger_sedes`.`sedesid` AS `sedesid`,
`vtiger_sedes`.`sede` AS `sede`,
`vtiger_sedes`.`clasesede` AS `clasesede`,
`vtiger_sedescf`.`cf_2192` AS `EstadoEquipos`,
`vtiger_sedescf`.`cf_2194` AS `Responsable`,
`vtiger_sedescf`.`cf_2235` AS `EstadoSede`,
`vtiger_sedescf`.`cf_2237` AS `SubtipoSede`,
`vtiger_sedescf`.`cf_2239` AS `TipoSede`,
`vtiger_sedescf`.`cf_2271` AS `Regional`,
`vtiger_sedes`.`propiedadsede` AS `propiedadsede`,
`vtiger_sedes`.`custodia` AS `custodia`,
`vtiger_sedes`.`habilitarentradas` AS `habilitarentradas`,
`vtiger_sedes`.`habilitarsalidas` AS `habilitarsalidas`,
`vtiger_sedes`.`estado_activo` AS `estado_activo`,
`vtiger_sedesgrouprel`.`groupname` AS `GrupoLogistico`,
`vtiger_sedescf`.`cf_3330` AS `En Proceso`,
`vtiger_sedes`.`situacionsede` AS `situacionsede`
LEFT JOIN ` vtiger_sedescf` on `vtiger_sedescf`.`sedesid` = `vtiger_sedes`.`sedesid`
|