– Product entity type ID SET @etype = (SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code = 'catalog_product'); – Product name attribute ID SET @name = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'name' AND entity_type_id = @etype); – Product name attribute ID SET @artist_name = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'artist_name' AND entity_type_id = @etype); SET @country_of_manufacture = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'country_of_manufacture' AND entity_type_id = @etype); SET @cs_sort_order = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'cs_sort_order' AND entity_type_id = @etype); SET @custom_design = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'custom_design' AND entity_type_id = @etype); SET @feed_dimensions = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'feed_dimensions' AND entity_type_id = @etype); SET @feed_product_image = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'feed_product_image' AND entity_type_id = @etype); SET @height = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'height' AND entity_type_id = @etype); SET @image = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'image' AND entity_type_id = @etype); SET @image_label = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'image_label' AND entity_type_id = @etype); SET @links_title = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'links_title' AND entity_type_id = @etype); SET @meta_description = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'meta_description' AND entity_type_id = @etype); SET @meta_title = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'meta_title' AND entity_type_id = @etype); SET @msrp_display_actual_price_type = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'msrp_display_actual_price_type' AND entity_type_id = @etype); SET @msrp_enabled = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'msrp_enabled' AND entity_type_id = @etype); SET @name = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'name' AND entity_type_id = @etype); SET @number_of_sales = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'number_of_sales' AND entity_type_id = @etype); SET @options_container = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'options_container' AND entity_type_id = @etype); SET @rating = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'rating' AND entity_type_id = @etype); SET @rf123_id = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'rf123_id' AND entity_type_id = @etype); SET @rf123_url = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'rf123_url' AND entity_type_id = @etype); SET @sale_price = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'sale_price' AND entity_type_id = @etype); SET @samples_title = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'samples_title' AND entity_type_id = @etype); SET @small_image = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'small_image' AND entity_type_id = @etype); SET @small_image_label = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'small_image_label' AND entity_type_id = @etype); SET @small_price = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'small_price' AND entity_type_id = @etype); SET @thumbnail = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'thumbnail' AND entity_type_id = @etype); SET @thumbnail_label = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'thumbnail_label' AND entity_type_id = @etype); SET @url_key = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'url_key' AND entity_type_id = @etype); SET @url_path = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'url_path' AND entity_type_id = @etype); SET @width = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'width' AND entity_type_id = @etype); – Product name attribute ID SET @description = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'description' AND entity_type_id = @etype); – Product price attribute ID SET @price = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'price' AND entity_type_id = @etype); – Admin store ID SET @store = 0;

– Query SELECT

e.entity_id AS 'id',
e.sku,
v1.value AS 'name',
v2.value AS 'artist_name',
v3.value AS 'width',
v4.value AS 'country_of_manufacture',
v5.value AS 'cs_sort_order',
v6.value AS 'custom_design',
v7.value AS 'feed_dimensions',
v8.value AS 'feed_product_image',
v9.value AS 'height',
v10.value AS 'image',
v11.value AS 'image_label',
v12.value AS 'links_title',
v13.value AS 'meta_description',
v14.value AS 'meta_title',
v15.value AS 'msrp_display_actual_price_type',
v16.value AS 'msrp_enabled',
v17.value AS 'description',
v18.value AS 'number_of_sales',
v19.value AS 'options_container',
v20.value AS 'rating',
v21.value AS 'rf123_id',
v22.value AS 'rf123_url',
v23.value AS 'sale_price',
v24.value AS 'samples_title',
v25.value AS 'small_image',
v26.value AS 'small_image_label',
v27.value AS 'small_price',
v28.value AS 'thumbnail',
v29.value AS 'thumbnail_label',
v30.value AS 'url_key',
v31.value AS 'url_path',
si.qty AS 'stock qty',
d1.value AS 'price'

FROM

catalog_product_entity e
LEFT JOIN cataloginventory_stock_item si
  ON e.entity_id = si.product_id
LEFT JOIN catalog_product_entity_varchar v1
  ON e.entity_id = v1.entity_id AND v1.store_id = @store AND v1.attribute_id = @name
LEFT JOIN catalog_product_entity_varchar v2
  ON e.entity_id = v2.entity_id AND v2.store_id = @store AND v2.attribute_id = @artist_name
LEFT JOIN catalog_product_entity_varchar v3
  ON e.entity_id = v3.entity_id AND v3.store_id = @store AND v3.attribute_id = @width
LEFT JOIN catalog_product_entity_varchar v4
  ON e.entity_id = v4.entity_id AND v4.store_id = @store AND v4.attribute_id = @country_of_manufacture
LEFT JOIN catalog_product_entity_varchar v5
  ON e.entity_id = v5.entity_id AND v5.store_id = @store AND v5.attribute_id = @cs_sort_order
LEFT JOIN catalog_product_entity_varchar v6
  ON e.entity_id = v6.entity_id AND v6.store_id = @store AND v6.attribute_id = @custom_design
LEFT JOIN catalog_product_entity_varchar v7
  ON e.entity_id = v7.entity_id AND v7.store_id = @store AND v7.attribute_id = @feed_dimensions
LEFT JOIN catalog_product_entity_varchar v8
  ON e.entity_id = v8.entity_id AND v8.store_id = @store AND v8.attribute_id = @feed_product_image
LEFT JOIN catalog_product_entity_varchar v9
  ON e.entity_id = v9.entity_id AND v9.store_id = @store AND v9.attribute_id = @height
LEFT JOIN catalog_product_entity_varchar v10
  ON e.entity_id = v10.entity_id AND v10.store_id = @store AND v10.attribute_id = @image
LEFT JOIN catalog_product_entity_varchar v11
  ON e.entity_id = v11.entity_id AND v11.store_id = @store AND v11.attribute_id = @image_label
LEFT JOIN catalog_product_entity_varchar v12
  ON e.entity_id = v12.entity_id AND v12.store_id = @store AND v12.attribute_id = @links_title
LEFT JOIN catalog_product_entity_varchar v13
  ON e.entity_id = v13.entity_id AND v13.store_id = @store AND v13.attribute_id = @meta_description
LEFT JOIN catalog_product_entity_varchar v14
  ON e.entity_id = v14.entity_id AND v14.store_id = @store AND v14.attribute_id = @meta_title
LEFT JOIN catalog_product_entity_varchar v15
  ON e.entity_id = v15.entity_id AND v15.store_id = @store AND v15.attribute_id = @msrp_display_actual_price_type
LEFT JOIN catalog_product_entity_varchar v16
  ON e.entity_id = v16.entity_id AND v16.store_id = @store AND v16.attribute_id = @msrp_enabled
LEFT JOIN catalog_product_entity_varchar v17
  ON e.entity_id = v17.entity_id AND v17.store_id = @store AND v17.attribute_id = @description
LEFT JOIN catalog_product_entity_varchar v18
  ON e.entity_id = v18.entity_id AND v18.store_id = @store AND v18.attribute_id = @number_of_sales
LEFT JOIN catalog_product_entity_varchar v19
  ON e.entity_id = v19.entity_id AND v19.store_id = @store AND v19.attribute_id = @options_container
LEFT JOIN catalog_product_entity_varchar v20
  ON e.entity_id = v20.entity_id AND v20.store_id = @store AND v20.attribute_id = @rating
LEFT JOIN catalog_product_entity_varchar v21
  ON e.entity_id = v21.entity_id AND v21.store_id = @store AND v21.attribute_id = @rf123_id
LEFT JOIN catalog_product_entity_varchar v22
  ON e.entity_id = v22.entity_id AND v22.store_id = @store AND v22.attribute_id = @rf123_url
LEFT JOIN catalog_product_entity_varchar v23
  ON e.entity_id = v23.entity_id AND v23.store_id = @store AND v23.attribute_id = @sale_price
LEFT JOIN catalog_product_entity_varchar v24
  ON e.entity_id = v24.entity_id AND v24.store_id = @store AND v24.attribute_id = @samples_title
LEFT JOIN catalog_product_entity_varchar v25
  ON e.entity_id = v25.entity_id AND v25.store_id = @store AND v25.attribute_id = @small_image
LEFT JOIN catalog_product_entity_varchar v26
  ON e.entity_id = v26.entity_id AND v26.store_id = @store AND v26.attribute_id = @small_image_label
LEFT JOIN catalog_product_entity_varchar v27
  ON e.entity_id = v27.entity_id AND v27.store_id = @store AND v27.attribute_id = @small_price
LEFT JOIN catalog_product_entity_varchar v28
  ON e.entity_id = v28.entity_id AND v28.store_id = @store AND v28.attribute_id = @thumbnail
LEFT JOIN catalog_product_entity_varchar v29
  ON e.entity_id = v29.entity_id AND v29.store_id = @store AND v29.attribute_id = @thumbnail_label
LEFT JOIN catalog_product_entity_varchar v30
  ON e.entity_id = v30.entity_id AND v30.store_id = @store AND v30.attribute_id = @url_key
LEFT JOIN catalog_product_entity_varchar v31
  ON e.entity_id = v31.entity_id AND v31.store_id = @store AND v31.attribute_id = @url_path
LEFT JOIN catalog_product_entity_decimal d1
  ON e.entity_id = d1.entity_id AND d1.store_id = @store AND d1.attribute_id = @price;