Select the top 10 of drugs reported on for substances for the concomitant drug list table.
select drugs, COUNT(DISTINCT local_number) from import.substance_concomitant_drug_list GROUP BY drugs order by COUNT(DISTINCT local_number) desc limit 10;
|[METFORMIN, METFORMIN HYDROCHLORIDE, METFORMIN HYDROCHLORIDE BP]||106566|
It seems from the suspect drug list that medicine names have no square brackets in their name and that the content between square brackets is a substance. Paracetamol comes from a lot of different brands and maybe the EMA decided to group them and omit the name. This can however not be concluded from the data.