select p.products_has_downloads, zp2.products_id AS mp3_album_id, zp2.products_status AS mp3_album_status, zp2.products_date_available AS mp3_date_available, p.products_has_downloads, p.products_image, ra.artists_name, p.products_id, pd.products_name, p.products_rrp, p.products_date_available as date_expected from zen_products_description pd, zen_product_music_extra me, zen_record_artists ra, zen_products_to_categories p2c, zen_products p LEFT JOIN zen_products zp2 ON zp2.parent_product_id = p.products_id where p.products_status = 1 AND p.products_id = pd.products_id AND me.products_id = p.products_id AND me.artists_id = ra.artists_id and p.products_statustext != 'Discontinued' AND p.products_type != 7 AND p.products_type != 8 AND p.products_type != 9 AND p2c.products_id = p.products_id AND ( p2c.categories_id='56' OR p2c.categories_id='57' OR p2c.categories_id='58' OR p2c.categories_id='59' OR p2c.categories_id='60' OR p2c.categories_id='61' OR p2c.categories_id='67' OR p2c.categories_id='68' OR p2c.categories_id='69' OR p2c.categories_id='70' OR p2c.categories_id='94' OR p2c.categories_id='95' OR p2c.categories_id='96' OR p2c.categories_id='97' OR p2c.categories_id='98' OR p2c.categories_id='99' OR p2c.categories_id='100' ) and pd.language_id = '1' AND (zp2.products_type = 7 or zp2.products_type is null) GROUP BY p.products_id