Database Locking Issues

my site is frozen sporadically due to the problems with this plugin locking up the database. my server admin identified the issue and sent me this:

The query that caused problems was this one:

SELECT pid , wp_options.option_value AS ‘custom_post_id’, GROUP_CONCAT(CONCAT_WS(‘@@’, meta_key, meta_value)) AS ‘extras’ FROM wp_ngg_pictures LEFT OUTER JOIN wp_options ON wp_options.option_name = CONCAT(‘wp_ngg_pictures_’, wp_ngg_pictures.pid) LEFT OUTER JOIN wp_postmeta ON wp_postmeta.post_id = wp_options.option_value WHERE (exclude = 0) GROUP BY wp_ngg_pictures.pid ORDER BY rand()

i have paying members and this plugin will make me lose them at this rate 🙁