This website uses cookies/beacons to provide you with the best experience. Carry on using the site without changing your settings to consent to this. You can change your cookie settings at any time using the link on the page footer.
Change cookie settings Learn More
RE-VIVED.com

Christian Business/Culture/General Books

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 = '47' and pd.language_id = '1' AND (zp2.products_type = 7 or zp2.products_type is null) GROUP BY p.products_id