The flying blue site is your friend (see example for ITA) - that gives the booking classes and partners eligible for XP (in general Skyteam partners are for all booking classes with some exceptions; from April all non-Skyteam partners do not earn XP). Check booking class first via ITA matrix or the like to avoid you book something that gives no miles and no XP. THen look at distances via some air mile calculator and presto

XP per distance: https://thepointsguy.com/news/the-cr...s-la-premiere/
Distance calculator https://www.airmilescalculator.com/distance/cdg-to-mad/
ITA matrix for booking classes https://matrix.itasoftware.com/search
Example of partner page that indicate which booking classes are eligible for XP and how many miles you score: ITA Airways | Flying Blue