SELECT DISTINCT `t0`.`id` AS `id` ,
 `t0`.`numero` AS `numero` ,
 `t0`.`fecha` AS `fecha` ,
 `t0`.`entrega` AS `entrega` ,
 `t0`.`comprador_id` AS `comprador_id` ,
 `t0`.`nota` AS `nota` ,
 `t0`.`usr_reconfirma` AS `usr_reconfirma` ,
 `t0`.`fch_reconfirma` AS `fch_reconfirma` ,
 `t0`.`cod_reconfirma` AS `cod_reconfirma` ,
 `t0`.`embarca_id` AS `embarca_id` ,
 `t0`.`tipo` AS `tipo` ,
 `t1`.`nombre` AS `nombre` ,
 `t1`.`chip_marc` AS `chip_marc` ,
 `t2`.`orden_id` AS `orden_id` ,
 `t2`.`cajas_total` AS `cajas_total` ,
 `t2`.`precio_total` AS `precio_total` ,
 `t2`.`peso_total` AS `peso_total` ,
 `t2`.`cubicaje_total` AS `cubicaje_total` ,
 `t3`.`nombre` AS `nom_embarca` ,
 ifnull(`t5`.`fnd` , 1) AS `fnd`
FROM
    (
        (
            (
                (
                    `ordencompra_enc` `t0`
                    JOIN `usuarios` `t1` ON(
                        (`t0`.`comprador_id` = `t1`.`id`)
                    )
                )
                JOIN `usuarios` `t3` ON((`t0`.`embarca_id` = `t3`.`id`))
            )
            JOIN `v_ordenreconfirmada` `t2` ON((`t0`.`id` = `t2`.`orden_id`))
        )
        LEFT JOIN `v_contratos_fnd` `t5` ON(
            (
                `t0`.`id` = `t5`.`ordencompra_id`
            )
        )
    )