Christian Traditional Music
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 = '29' and pd.language_id = '1' AND (zp2.products_type = 7 or zp2.products_type is null) GROUP BY p.products_id
SELECT p.*, pd.products_name FROM zen_products p, zen_products_description pd WHERE p.products_id = pd.products_id AND 1=2 ORDER BY p.products_importance_europe DESC
