- Plesk 12.0 for Linux
phpMyAdmin 4.5 installed
Unable to export SQL query result if the query contains table aliases. For example, clicking on the export link, after executing query below, return back to the query screen.
SELECT field_name from db_table as tt where tt.b=yy
However, export function works as expected if running an equivalent query without table aliases:
SELECT field_name from db_table where b=yy
Bug in phpMyAdmin https://github.com/phpmyadmin/phpmyadmin/issues/11509
The issue was fixed in phpMyAdmin 4.6 which will be shipped in one of next Plesk updates.