SELECT `vtiger_servicios`.`serviciosid` AS `serviciosid`,
`vtiger_servicio_contrato`.`contrato` AS `contrato`,
`vtiger_contrato`.`estado_contrato` AS `estado_contrato`,
`vtiger_contrato`.`nombre_contrato` AS `nombre_contrato`,
`vtiger_servicioscf`.`cf_1874` AS `CodigoAtencion`,
`vtiger_servicios`.`nombre_servicio` AS `nombre_servicio`,
`vtiger_servicio_contrato`.`activoencontrato` AS `ServicioActivo`,
`vtiger_servicios`.`activoencontrato` AS `activoencontrato`,
cast(`vtiger_servicios`.`precio` AS decimal(12, 2)) AS `precio`,
`vtiger_servicioscf`.`cf_2799` AS `DescripcionServicio`,
`vtiger_servicioscf`.`cf_2953` AS `CilRespaldo`,
`vtiger_servicioscf`.`cf_2955` AS `Portatil`,
`vtiger_servicioscf`.`cf_3070` AS `Via`,
`vtiger_servicioscf`.`cf_3059` AS `AbrevServicio`,
`vtiger_servicioscf`.`cf_3057` AS `CategoriaServicio`,
`vtiger_servicioscf`.`cf_3451` AS `EquipoSahos`,
`vtiger_servicioscf`.`cf_3478` AS `MostrarEI`,
`vtiger_servicioscf`.`cf_3453` AS `MascaraSahos`,
`vtiger_servicioscf`.`cf_2951` AS `Concentrador`,
`vtiger_servicioscf`.`cf_3068` AS `ConcentradorPortartil`,
`vtiger_servicioscf`.`cf_2959` AS `TipoOSAsociada`,
`vtiger_servicioscf`.`cf_3511` AS `DXAsociados`,
left(`vtiger_servicioscf`.`cf_2959`, 3) AS `TipoOSAsociadaCod`,
`vtiger_servicioscf`.`cf_3066` AS `EPS`,
concat(`vtiger_servicio_contrato`.`contrato`, '-', `vtiger_servicio_contrato`.`servicio`) AS `ServicioContrato`,
`vtiger_servicios`.`linea_servicio` AS `LineaServicio`,
left(`vtiger_servicios`.`tipopaquete`, 3) AS `IdPaquete`
JOIN ` vtiger_servicioscf` on((`vtiger_servicios`.`serviciosid` = `vtiger_servicioscf`.`serviciosid`)))
JOIN ` vtiger_contrato` on((`vtiger_servicio_contrato`.`contrato` = `vtiger_contrato`.`contratoid`)))
WHERE ((`vtiger_contrato`.`estado_contrato` = 'Vigente')
AND (`vtiger_servicio_contrato`.`activoencontrato` = '1')
AND (`vtiger_servicios`.`activoencontrato` = '1'))
|