Previously answered correctly here:
Execute your sql query in the SQL tab of phpMyAdmin.
After execution, scroll down the page and look for “Query results operations”
Click “Export” link from the above and you will get the page to export all the results of the queries to desired format. That’s it.
Note: The ...
The warning explains it all. None of the columns you are trying to join are unique which means there is a possible ambiguity in the statement. i.e.
JOIN notice_insolvency_practitioners ni
ON ni.notice_id = n.id
Because the columns aren't unique, there can be more than one identical value for n.id or ni.notice.id (or maybe others, it is impossible ...
Have you used the export function? Click the format drop down and select csv
[UPDATE] OK, I see what you are after. I have just tested this other way of doing it and it works. Same sort of thing, but at the bottom of your list, select all records and then click export then choose the format.
You can test it by first viewing the output as text before ...