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`