possible slow query

This is showing up on the groups.drupal.org slow query log. uses some non standard (for drupal) constructs. note that i only have 5 helptips.

SELECT ht.* FROM node n LEFT JOIN helptip ht ON ht.nid = n.nid LEFT JOIN helptip_user_data ht_hidden ON ht_hidden.uid=1 AND ht_hidden.nid=n.nid AND ht_hidden.relation='hidden' WHERE n.status = 1 AND ht_hidden.relation IS NULL AND ('node' LIKE ht.path) AND weight >= -10 AND weight <= 10 ORDER BY ht.weight, RAND() LIMIT 1;