GET TID and PREF_NAME from CHEMBL

I want to retrieve relationship between TID and PREF_NAME in specific case from ChEMBL DB. SQL query is following. I ran the sql and got result like …. :-)