The best way to download target-drug data in csv format from ChEMBL

Question

[little_more]

I need data on drug targets in humans and information about max_phase of drugs for each target. If I use their target browser, it shows a number of associated drugs, but there is no information about the drug's approval status if I download .csv file with all targets. If I use their compounds browser, there is no information about targets IDs, only a number of targets for each compound.

Is there a way to map these two datasets between each other? In the end, I need to divide targets into a few groups like: 'has 1 approved drug', 'has only experimental drugs' and so on.