select p.products_has_downloads, zp2.products_id AS mp3_album_id,p.products_type, zp2.products_status AS mp3_album_status, zp2.products_date_available AS mp3_date_available, p.products_importance_europe, p.products_date_available, p.products_loyalty_points, p.products_id, p.products_image, p.products_tax_class_id, p.products_price, p.products_rrp, p.products_date_added, ra.artists_name
from (((zen_products p join zen_products_description pd on p.products_id = pd.products_id) left join zen_product_music_extra me on me.products_id = p.products_id) left join zen_record_artists ra on ra.artists_id = me.artists_id)
LEFT JOIN zen_products zp2 ON zp2.parent_product_id = p.products_id
where pd.language_id = '1'
and (zp2.products_type = 7 or zp2.products_type is null)
and p.products_id IN (16846,16598,16977,16129,16699,16630,15653,16610,16671,16611,16997,16672) GROUP BY p.products_id ORDER BY p.products_importance_europe DESC
