Query causing server/database load issues

[JSWeb]

Hi Zenners,

We have a sitewhich seems to be causing a lot of server and database problems. They have been upgraded to 1.3.8a but their site is still causing a lot of problems (especially on the database queries).

# Time: 080817 10:53:35
# Query_time: 1308  Lock_time: 0  Rows_sent: 22  Rows_examined: 47187469
select distinct c.categories_id as id, cd.categories_name as name
        from zen_products p, zen_products_to_categories p2c, zen_categories c, z                                      en_categories_description cd, zen_product_music_extra pme
        where p.products_status = 1
          and pme.products_id = p2c.products_id
          and p2c.categories_id = c.categories_id
          and p2c.categories_id = cd.categories_id
          and cd.language_id = '1'
          and pme.record_company_id = '7'
        order by cd.categories_name;

The website url is: www.reggae.co.uk

Any advice on where this is stemming from would be a real help.

Kind Regards

Jamie