select `enjoit_bd`.`pedidos`.`idPedido` AS `idPedido`, `enjoit_bd`.`pedidos`.`referencia` AS `referencia`, `enjoit_bd`.`pedidos`.`idCliente` AS `idCliente`, `enjoit_bd`.`pedidos`.`idRestaurante` AS `idRestaurante`, ( select `rest`.`userName` from `enjoit_bd`.`usuarios` `rest` where ( `rest`.`idUsuario` = `enjoit_bd`.`pedidos`.`idRestaurante` ) ) AS `nombre`, `enjoit_bd`.`pedidos`.`fromPedido` AS `fromPedido`, `enjoit_bd`.`pedidos`.`idPropina` AS `idPropina`, `enjoit_bd`.`pedidos`.`valorPropina` AS `valorPropina`, `enjoit_bd`.`pedidos`.`valorDomicilio` AS `valorDomicilio`, `enjoit_bd`.`pedidos`.`estadoGlobal` AS `estadoGlobal`, `enjoit_bd`.`pedidos`.`fecha` AS `fecha`, `enjoit_bd`.`pedidos`.`tipoPedido` AS `tipoPedido`, `enjoit_bd`.`pedidos`.`tipoPago` AS `tipoPago`, `enjoit_bd`.`pedidos`.`idPadre` AS `idPadre`, `enjoit_bd`.`pedidos`.`notificacion` AS `notificacion`, ( select ( sum(`enjoit_bd`.`detalle_pedidos`.`valorTotal`) - 100) AS `total` from `enjoit_bd`.`detalle_pedidos` where ( ( `enjoit_bd`.`detalle_pedidos`.`idPedido` = `enjoit_bd`.`pedidos`.`idPedido` ) and (`enjoit_bd`.`detalle_pedidos`.`state` = 1) ) ) AS `total`, `enjoit_bd`.`pedidos`.`created_at` AS `created_at`, `enjoit_bd`.`pedidos`.`updated_at` AS `updated_at` from `enjoit_bd`.`pedidos`