Hi @remi_okarito, I see one small difference between the sql count query and the sql export query, there is a
LEFT OUTER JOIN "searches" ON "searches"."id" = "roundtrips"."search_id"
more on the count query.
Can you launch this query below and give me the result please?
SELECT COUNT(DISTINCT "roundtrips"."id") FROM "roundtrips" LEFT OUTER JOIN "users" "validators_roundtrips" ON "validators_roundtrips"."id" = "roundtrips"."validator_id" LEFT OUTER JOIN "roundtrips" "parents_roundtrips" ON "parents_roundtrips"."id" = "roundtrips"."parent_id" INNER JOIN "trips" ON "roundtrips"."id" = "trips"."roundtrip_id" INNER JOIN "user_bookings" ON "trips"."id" = "user_bookings"."trip_id" INNER JOIN "users" ON "user_bookings"."user_id" = "users"."id" INNER JOIN "teams" ON "users"."team_id" = "teams"."id" WHERE "teams"."organization_id" = 405;