D
--
SELECT DISTINCT t.id, t.company_id, t.nume, t.pentru, t.tipTarif, p.pret, p.traseu_id, p.moneda
FROM preturi p
JOIN tarife t ON tarif_id=t.id AND tipTarif=1
WHERE p.loc_plecare_id=714 and p.loc_sosire_id=260
AND p.dtStart <= '2025-03-26' AND p.dtEnd > '2025-03-26'
ORDER BY p.traseu_id DESC, t.company_id, p.pret
