There are several issues with multiple admin pages:
Detail page
Lubes show same lube multiple times
Industry Type shows all industries in table, though only a few are checked
Neither TDS nor SDS file names show up
Search results
Shows multiple listings of the same product
Clicking the Update button on the search page returns the following error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 10, 10' at line 6." (there's no URL parameter). There's no error when accessing the Update page by entering the URL manually.
Update page
Industry Type shows only one industry; not the correct one
Testimonial company only shows first record; not the correct one
On update, it deletes records out of multiple tables and shows 'this record has been deleted' on redirect page. When I search for the product again, it shows 'no records found'.
Attached all admin pages.