gistfile1.txt

mysql> select ttd.tid Term_ID, tv.name AS Vocabulary, ttd.name as Term_Name from taxonomy_term_data ttd, taxonomy_vocabulary tv where tv.vid = ttd.vid and ttd.name in (select name from taxonomy_term_data ttd2 group by name having count(*) > 1) order by Term_Name;
+---------+-----------------------+-----------------------------------------+
| Term_ID | Vocabulary            | Term_Name                               |
+---------+-----------------------+-----------------------------------------+
|     601 | Article Tags          | Antitrust                               |
|     451 | Professional Practice | Antitrust                               |
|    1036 | Sectors               | Capital Markets                         |
|     214 | Professional Practice | Capital Markets                         |
|     456 | Sectors               | Consumer Discretionary                  |
|     443 | Article Tags          | Consumer Discretionary                  |
|     457 | Sectors               | Consumer Staples                        |
|     444 | Article Tags          | Consumer Staples                        |
|     606 | Article Tags          | Due Diligence                           |
|     466 | Topics                | Due Diligence                           |
|     458 | Sectors               | Energy                                  |
|     440 | Article Tags          | Energy                                  |
|     459 | Sectors               | Financials                              |
|     446 | Article Tags          | Financials                              |
|     373 | Article Tags          | Fraudulent Conveyance                   |
|     139 | Expertise Tags        | Fraudulent Conveyance                   |
|     460 | Sectors               | Health Care                             |
|     445 | Article Tags          | Health Care                             |
|     461 | Sectors               | Industrials                             |
|     442 | Article Tags          | Industrials                             |
|     462 | Sectors               | Information Technology                  |
|     447 | Article Tags          | Information Technology                  |
|      77 | Language(s)           | Italian                                 |
|      78 | Language(s)           | Italian                                 |
|     463 | Sectors               | Materials                               |
|     441 | Article Tags          | Materials                               |
|     547 | Article Tags          | Mergers & Acquisitions                  |
|     393 | Professional Practice | Mergers & Acquisitions                  |
|     145 | Expertise Tags        | Portfolio Valuation & Advisory Services |
|     265 | Professional Practice | Portfolio Valuation & Advisory Services |
|     464 | Sectors               | Telecommunication Services              |
|     448 | Article Tags          | Telecommunication Services              |
|     426 | Article Tags          | Transfer Pricing                        |
|     161 | Expertise Tags        | Transfer Pricing                        |
|    1131 | Sectors               | Utilities                               |
|     449 | Article Tags          | Utilities                               |
+---------+-----------------------+-----------------------------------------+
36 rows in set (0.44 sec)