SELECT DISTINCT(product_categories.product_id) AS product_id,products.name,products.product_code,products.id,images.image AS image,products.release AS release, artist.profile_name AS artist_name FROM `catalog_module-product_categories` AS product_categories, `catalog_module-products` AS products, `catalog_module-product_images` AS images, `profile_module-artist` AS artistWHERE product_categories.product_id = products.id AND images.product_id = products.id AND images.default_image = '1' AND products.profile_id = artist.id ORDER BY products.release