[Diego Web Design]

Galera estou com um problema em um aquery q me retorna registro duplicados la vai a query


select
od.orders_id as Pedido,
od.customers_id as Cod_Cliente,
od.customers_name as Cliente_Nome,
od.customers_street_address as Cliente_Endereco,
od.customers_suburb as Cliente_Bairro,
od.customers_city as Cliente_Cidade,
od.customers_postcode as Cliente_Cep,
od.customers_state as Cliente_Categoria,
od.payment_method as Forma_de_Pagamento,
od.cc_type as Cartao,
op.products_name as Produto,
op.products_price as Valor_Produto,
op.data_entrada as Data_Entrada,
op.data_saida as Data_Saida,
ot.text Valor_Total,
od.cc_type as Bandeira_Cartao,
od.cc_owner as Cod_Transacao,
od.cc_number as Cod_Transacao,
od.cc_number_x as Prestacao_Cartao,
bl.datavencimento as Vencimento_Boleto,
bl.valor_documento as Valor_Boleto,
bl.parcela as Parcela,
bl.parcela_total as Total_de_Parcelas,
ac.acompanhante_nome1,
ac.acompanhante_data2,
ac.acompanhante_nome2,
ac.acompanhante_nome3,
ac.acompanhante_data3,
ac.acompanhante_nome4,
ac.acompanhante_data4,
ac.acompanhante_nome5,
ac.acompanhante_data5,
ac.acompanhante_nome6,
ac.acompanhante_data6
FROM customers ct
INNER JOIN orders od ON od.customers_id = ct.customers_id
INNER JOIN orders_products op ON op.orders_id = od.orders_id
INNER JOIN orders_total ot ON ot.orders_id = od.orders_id
LEFT JOIN acompanhantes ac ON ct.customers_id = ac.customers_id
and ac.orders_id = od.orders_id
and ac.products_id = op.products_id
LEFT JOIN boleto bl ON bl.numero_pedido = od.orders_id
and bl.customers_id = ct.customers_id
WHERE od.orders_status = '1'
and od.payment_method = 'Boleto Bancario'
AND (od.date_purchased) Between '2009-12-01 00:00:00' And '2009-12-09 23:59:59' and (op.products_id = '64' or op.products_id = '65' or op.products_id = '66' or op.products_id = '73' or op.products_id = '74')
order by od.customers_id,od.orders_id,bl.parcela

ela me retorna assim

4625 59 Rodrigo Paiva 540 1 4 etc
4625 59 Rodrigo Paiva 540 1 4 etc
4625 59 Rodrigo Paiva 540 2 4 etc
4625 59 Rodrigo Paiva 540 2 4 etc

como faço pra ela me retornar somente???

4625 59 Rodrigo Paiva 540 1 4 etc
4625 59 Rodrigo Paiva 540 2 4 etc

ja tentei com distinct , com group by e nada...


alguem sabe?

agradeço desde já !


Abraços