gistfile1.txt

mysql> select ringer_performances.credit, concat_ws(' ',ringers.first_name, ringers.middle_names, ringers.last_name) as name from ringer_performances, ringers where ringers.id = ringer_performances.ringer_id and ascii(ringers.middle_names) != 0 having credit != name;
+-------------------------+-----------------------+
| credit                  | name                  |
+-------------------------+-----------------------+
| Nicholas W. Jones       | Nicholas W Jones      |
| Mark A. S. Jones        | Mark A S Jones        |
| Peter J. Bennett        | Peter J Bennett       |
| Andrew J. Graham        | Andrew J Graham       |
| Richard S. J. Saddleton | Richard S J Saddleton |
| James R. S. Sawle       | James R S Sawle       |
| Katherine L. Town       | Katherine L Town      |
| Michael J. Trimm        | Michael J Trimm       |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Terry M. Astill         | Terry M Astill        |
| William H. J. Norton    | William H J Norton    |
| Alison R. Clarke        | Alison R Clarke       |
| James R. S. Sawle       | James R S Sawle       |
| Andrew P. F. Bradford   | Andrew P F Bradford   |
| Rebecca S. Bruce        | Rebecca S Bruce       |
| Andrew J. Graham        | Andrew J Graham       |
| Mark C. Bennett         | Mark C Bennett        |
| Gregory Watson          | Gregory J Watson      |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Jon Waters              | Jon A Waters          |
| Roger Bailey            | Roger D Bailey        |
| Paul CL Bradford        | Paul C L Bradford     |
| Quentin SA Jackson      | Quentin S A Jackson   |
| David HW Ottley         | David H W Ottley      |
| Jon Waters              | Jon A Waters          |
| James RS Sawle          | James R S Sawle       |
| Edward Webb             | Edward J Webb         |
| Andrew PF Bradford      | Andrew P F Bradford   |
| Garry Barr              | Garry S Barr          |
| Roger Bailey            | Roger D Bailey        |
| David HW Ottley         | David H W Ottley      |
| Quentin SA Jackson      | Quentin S A Jackson   |
| Andrew PF Bradford      | Andrew P F Bradford   |
| Roger Bailey            | Roger D Bailey        |
| Andrew PF Bradford      | Andrew P F Bradford   |
| John PW Taylor          | John P W Taylor       |
| Jon Waters              | Jon A Waters          |
| David HW Ottley         | David H W Ottley      |
| John PW Taylor          | John P W Taylor       |
| Andrew PF Bradford      | Andrew P F Bradford   |
| Quentin SA Jackson      | Quentin S A Jackson   |
| David HW Ottley         | David H W Ottley      |
| Paul CL Bradford        | Paul C L Bradford     |
| Quentin SA Jackson      | Quentin S A Jackson   |
| Andrew PF Bradford      | Andrew P F Bradford   |
| John PW Taylor          | John P W Taylor       |
| Jon Waters              | Jon A Waters          |
| Roger  Bailey           | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Quentin SA Jackson      | Quentin S A Jackson   |
| Andrew PF Bradford      | Andrew P F Bradford   |
| David HW Ottley         | David H W Ottley      |
| Quentin SA Jackson      | Quentin S A Jackson   |
| Kelly Barnes            | Kelly N Barnes        |
| Jon Waters              | Jon A Waters          |
| Garry Barr              | Garry S Barr          |
| David HW Ottley         | David H W Ottley      |
| Gregory Watson          | Gregory J Watson      |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Jon Waters              | Jon A Waters          |
| Quentin SA Jackson      | Quentin S A Jackson   |
| Martin Cansdale         | Martin J Cansdale     |
| Richard PG Hayhoe       | Richard P G Hayhoe    |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Charles Herriott        | Charles W G Herriott  |
| Rupert Littlewood       | Rupert H J Littlewood |
| Lucy Bricheno           | Lucy M Bricheno       |
| Garry Barr              | Garry S Barr          |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Clare E. F. Dyer        | Clare E F Dyer        |
| Rebecca L. Sugden       | Rebecca L Sugden      |
| Charles W. G. Herriott  | Charles W G Herriott  |
| Katherine L. Town       | Katherine L Town      |
| Jennifer A. Holden      | Jennifer A Holden     |
| Andrew P. F. Bradford   | Andrew P F Bradford   |
| David H. Stone          | David H Stone         |
| Martin J. Cansdale      | Martin J Cansdale     |
| Andrew P. Sparling      | Andrew P Sparling     |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Jon Waters              | Jon A Waters          |
| Roger Bailey            | Roger D Bailey        |
| Jon Waters              | Jon A Waters          |
| Roger Bailey            | Roger D Bailey        |
| Kristine Fowler         | Kristine K Fowler     |
| Sebastian Lucas         | Sebastian B Lucas     |
| Andrew Sparling         | Andrew P Sparling     |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Clara Westlake          | Clara P Westlake      |
| Helen Mansfield         | Helen J Mansfield     |
| Peter Jasper            | Peter M Jasper        |
| Richard Hayhoe          | Richard P G Hayhoe    |
| Nicholas Jones          | Nicholas W Jones      |
| Roger Bailey            | Roger D Bailey        |
| James Eggleston         | James K Eggleston     |
| Samantha Hovey          | Samantha J Hovey      |
| Jason Hughes            | Jason W Hughes        |
| Roger Bailey            | Roger D Bailey        |
| Samantha Hovey          | Samantha J Hovey      |
| James Eggleston         | James K Eggleston     |
| James Eggleston         | James K Eggleston     |
| Roger Bailey            | Roger D Bailey        |
| Jason Hughes            | Jason W Hughes        |
| Ed Webb                 | Ed J Webb             |
| Jason Hughes            | Jason W Hughes        |
| Charles WG Herriott     | Charles W G Herriott  |
| Andrew RC Kelso         | Andrew R C Kelso      |
| Philip RJ Barnes        | Philip R J Barnes     |
| Roger Bailey            | Roger D Bailey        |
| Jon Waters              | Jon A Waters          |
| Roger Bailey            | Roger D Bailey        |
| Sebastian Lucas         | Sebastian B Lucas     |
| David Ottley            | David H W Ottley      |
| Alison Elwess           | Alison E Elwess       |
| Peter Blight            | Peter J Blight        |
| Andrew PF Bradford      | Andrew P F Bradford   |
| John PW Taylor          | John P W Taylor       |
| Charles WG Herriott     | Charles W G Herriott  |
| Andrew RC Kelso         | Andrew R C Kelso      |
| Charles WG Herriott     | Charles W G Herriott  |
| Andrew PF Bradford      | Andrew P F Bradford   |
| Roger Bailey            | Roger D Bailey        |
| Charles WG Herriott     | Charles W G Herriott  |
| Andrew PF Bradford      | Andrew P F Bradford   |
| Andrew RC Kelso         | Andrew R C Kelso      |
| Charles WG Herriott     | Charles W G Herriott  |
| Charles WG Herriott     | Charles W G Herriott  |
| Roger Bailey            | Roger D Bailey        |
| Charles WG Herriott     | Charles W G Herriott  |
| Clara Westlake          | Clara P Westlake      |
| Andrew PF Bradford      | Andrew P F Bradford   |
| Charles WG Herriott     | Charles W G Herriott  |
| Charles WG Herriott     | Charles W G Herriott  |
| Adrian Udal             | Adrian R Udal         |
| Charles WG Herriott     | Charles W G Herriott  |
| Andrew PF Bradford      | Andrew P F Bradford   |
| Andrew PF Bradford      | Andrew P F Bradford   |
| Charles WG Herriott     | Charles W G Herriott  |
| Quentin  S A Jackson    | Quentin S A Jackson   |
| Roger Bailey            | Roger D Bailey        |
| Jon Waters              | Jon A Waters          |
| Jennifer A  Holden      | Jennifer A Holden     |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Jon Waters              | Jon A Waters          |
| William Dawson          | William J Dawson      |
| Jon Waters              | Jon A Waters          |
| Rupert HJ Littlewood    | Rupert H J Littlewood |
| Andrew PF Bradford      | Andrew P F Bradford   |
| Clare EF Dyer           | Clare E F Dyer        |
| Charles WG Herriott     | Charles W G Herriott  |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Rona Joiner             | Rona M Joiner         |
| Roger Bailey            | Roger D Bailey        |
| Jon Waters              | Jon A Waters          |
| Jon Waters              | Jon A Waters          |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Jon Waters              | Jon A Waters          |
| Jon Waters              | Jon A Waters          |
| Jon Waters              | Jon A Waters          |
| Jon Waters              | Jon A Waters          |
| Jon Waters              | Jon A Waters          |
| Jon Waters              | Jon A Waters          |
| Jon Waters              | Jon A Waters          |
| Jon Waters              | Jon A Waters          |
| Roger Bailey            | Roger D Bailey        |
| Heather Forster         | Heather M Forster     |
| Sean Langton            | Sean D Langton        |
| Jon Waters              | Jon A Waters          |
| Jon Waters              | Jon A Waters          |
| Rachel Town             | Rachel S Town         |
| Jon Waters              | Jon A Waters          |
| Elizabeth LJ Stokoe     | Elizabeth L J Stokoe  |
| Clare EF Dyer           | Clare E F Dyer        |
| Andrew PF Bradford      | Andrew P F Bradford   |
| Rupert Littlewood       | Rupert H J Littlewood |
| Charles W G Herriott    | Charles W Herriott    |
| Charles W G Herriott    | Charles W Herriott    |
| Roger Bailey            | Roger D Bailey        |
| Charles W G Herriott    | Charles W Herriott    |
| Tessa Beadman           | Tessa K Beadman       |
| Heather Forster         | Heather M Forster     |
| Clare Dyer              | Clare E F Dyer        |
| Ian Fielding            | Ian R Fielding        |
| Elizabeth Stokoe        | Elizabeth L J Stokoe  |
| Jenny Holden            | Jenny A Holden        |
| Rupert Littlewood       | Rupert H J Littlewood |
| Nicholas Hartley        | Nicholas W Hartley    |
| Andrew Bradford         | Andrew P F Bradford   |
| Charles Herriott        | Charles W Herriott    |
| Oliver Cross            | Oliver 8 Cross        |
| Katie Town              | Katie L Town          |
| Nicholas Hartley        | Nicholas W Hartley    |
| Quentin Jackson         | Quentin S A Jackson   |
| Heather Forster         | Heather M Forster     |
| Clare Dyer              | Clare E F Dyer        |
| Tessa Beadman           | Tessa K Beadman       |
| Martin Cansdale         | Martin J Cansdale     |
| Jon Waters              | Jon A Waters          |
| Andrew Bradford         | Andrew P F Bradford   |
| Charles W G Herriott    | Charles W Herriott    |
| Annelise Felton         | Annelise O Felton     |
| Charles W G Herriott    | Charles W Herriott    |
| Charles W G Herriott    | Charles W Herriott    |
| Roger Bailey            | Roger D Bailey        |
| Jon Waters              | Jon A Waters          |
| Roger Bailey            | Roger D Bailey        |
| Charles W G Herriott    | Charles W Herriott    |
| Roger Bailey            | Roger D Bailey        |
| Charles W G Herriott    | Charles W Herriott    |
| Charles W G Herriott    | Charles W Herriott    |
| Charles W G Herriott    | Charles W Herriott    |
| Jon Waters              | Jon A Waters          |
| Roger Bailey            | Roger D Bailey        |
| Annelise Felton         | Annelise O Felton     |
| Ian Fielding            | Ian R Fielding        |
| Clare Dyer              | Clare E F Dyer        |
| Hugh Wilkinson          | Hugh J W Wilkinson    |
| David Maynard           | David G Maynard       |
| Heather Forster         | Heather M Forster     |
| Charles Herriott        | Charles W Herriott    |
| Andrew Graham           | Andrew J Graham       |
| Quentin SA Jackson      | Quentin S A Jackson   |
| Charles W G Herriott    | Charles W Herriott    |
| Guy Atchison            | Guy W Atchison        |
| Clara Westlake          | Clara P Westlake      |
| Peter Jasper            | Peter M Jasper        |
| Charles W G Herriott    | Charles W Herriott    |
| Andrew Bradford         | Andrew P F Bradford   |
| Jenny Holden            | Jenny A Holden        |
| James Egglestone        | James K Egglestone    |
| Jon Waters              | Jon A Waters          |
| Clare Dyer              | Clare E F Dyer        |
| Rachel Aland            | Rachel C Aland        |
| Alan Bain               | Alan F R Bain         |
| Charles W G Herriott    | Charles W Herriott    |
| Roger Bailey            | Roger D Bailey        |
| Charles W G Herriott    | Charles W Herriott    |
| Clara Westlake          | Clara P Westlake      |
| Guy Atchison            | Guy W Atchison        |
| Peter Jasper            | Peter M Jasper        |
| Helen Richardson        | Helen E Richardson    |
| Hellen Richardson       | Hellen V Richardson   |
| Nicholas Hartley        | Nicholas W Hartley    |
| Peter Jasper            | Peter M Jasper        |
| Andrew Hills            | Andrew M Hills        |
| Roger Bailey            | Roger D Bailey        |
| Charles W G Herriott    | Charles W Herriott    |
| Roger Bailey            | Roger D Bailey        |
| Charles W G Herriott    | Charles W Herriott    |
| Charles W G Herriott    | Charles W Herriott    |
| Roger Bailey            | Roger D Bailey        |
| Guy Atchison            | Guy W Atchison        |
| Peter Jasper            | Peter M Jasper        |
| Elizabeth Stokoe        | Elizabeth L J Stokoe  |
| Clara Westlake          | Clara P Westlake      |
| Jon Waters              | Jon A Waters          |
| Thomas Baldwin          | Thomas D Baldwin      |
| Peter Jasper            | Peter M Jasper        |
| Roger Bailey            | Roger D Bailey        |
| Elizabeth Stokoe        | Elizabeth L J Stokoe  |
| Andrew Hills            | Andrew M Hills        |
| Peter Jasper            | Peter M Jasper        |
| Quentin SA Jackson      | Quentin S A Jackson   |
| Quentin SA Jackson      | Quentin S A Jackson   |
| Peter Jasper            | Peter M Jasper        |
| Roger Bailey            | Roger D Bailey        |
| Roger Bailey            | Roger D Bailey        |
| Hugh Spalding           | Hugh J Spalding       |
| Guy Atchison            | Guy W Atchison        |
| Peter Jasper            | Peter M Jasper        |
| Roger Bailey            | Roger D Bailey        |
| Guy Atchison            | Guy W Atchison        |
| Peter Jasper            | Peter M Jasper        |
| Rachel Aland            | Rachel C Aland        |
| Charles W G Herriott    | Charles W Herriott    |
+-------------------------+-----------------------+
291 rows in set (0.02 sec)