Voila, instant ERD! The only problem is that you will need to KNOW which objects to drag and drop. The Data Modeler will not automatically recursively search for related objects by foreign key constraint and add those tables. However, if you do add tables one at a time, it will auto...
Create an index on (gepubliceerd,datum_public,tijd_public) in the table n. The only way to remove the temporary and filesort is to have table n appear as the first table in the explain and using the above index so that no sorting is required. ...