optimize the query

As I said, try having an index by (string, text, code). That would apply to both tables.

---

AMB

Some guidelines for posting questions...