Thank you Mike, that worked brilliantly! All my machines updated
Rule #1 - Be Patient - Rule #2 - Don't ask when, if you don't contribute - Rule #3 - You have coding skills - LinuxMCE's small brother is available: http://www.agocontrol.com
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Show posts Menu
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+----------------+--------+--------------------+---------+---------+-----------------------------------------+------+-------------+
| 1 | PRIMARY | <derived2> | ALL | NULL | NULL | NULL | NULL | 542 | |
| 1 | PRIMARY | File | eq_ref | PRIMARY,FatGroupBy | PRIMARY | 4 | s.PK_File | 1 | |
| 2 | DERIVED | File | index | Path,Filename | PRIMARY | 4 | NULL | 162 | Using where |
| 2 | DERIVED | Bookmark | ref | FK_File | FK_File | 5 | pluto_media.File.PK_File | 1 | |
| 2 | DERIVED | File_Attribute | ref | PRIMARY,FK_File | FK_File | 4 | pluto_media.File.PK_File | 3 | Using index |
| 2 | DERIVED | Attribute | eq_ref | PRIMARY | PRIMARY | 4 | pluto_media.File_Attribute.FK_Attribute | 1 | |
| 2 | DERIVED | LongAttribute | ref | FK_File | FK_File | 5 | pluto_media.File.PK_File | 1 | |
| 2 | DERIVED | Picture_File | ref | FK_File | FK_File | 4 | pluto_media.File.PK_File | 1 | |
+----+-------------+----------------+--------+--------------------+---------+---------+-----------------------------------------+------+-------------+
8 rows in set (0.02 sec)
Jamo asked me to post this link to his explain code: http://pastebin.com/jnQsJGAc