Executed SQL

SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (337, 341, 406, 523)) AND (t_d.attribute_id IN ('71', '86', '87', '97', '112', '113', '114', '118', '119', '144')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (337, 341, 406, 523)) AND (t_d.attribute_id IN ('73')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (337, 341, 406, 523)) AND (t_d.attribute_id IN ('75', '76', '120')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (337, 341, 406, 523)) AND (t_d.attribute_id IN ('77', '78', '93', '94')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (337, 341, 406, 523)) AND (t_d.attribute_id IN ('96', '121', '123', '125', '126', '127', '128', '131', '137')) AND (t_d.store_id = 0)

entity_id	attribute_id	default_value	store_value	value
337	71	chair		chair
337	86	/A/F/AF00001648_1.jpg		/A/F/AF00001648_1.jpg
337	87	/A/F/AF00001648_1.jpg		/A/F/AF00001648_1.jpg
337	97	chair		chair
337	112	chair		chair
337	113	chair		chair
337	114	chair		chair
337	118	2		2
337	119	4		4
337	144	INDEX,FOLLOW		INDEX,FOLLOW
341	71	Chinese Stool		Chinese Stool
341	86	/A/F/AF00001656_1.jpg		/A/F/AF00001656_1.jpg
341	87	/A/F/AF00001656_1.jpg		/A/F/AF00001656_1.jpg
341	97	chinese-stool		chinese-stool
341	112	Chinese Stool		Chinese Stool
341	113	Chinese Stool		Chinese Stool
341	114	Chinese Stool		Chinese Stool
341	118	2		2
341	119	4		4
341	144	INDEX,FOLLOW		INDEX,FOLLOW
406	71	TOLPUDDLE • ARMCHAIR		TOLPUDDLE • ARMCHAIR
406	86	/E/L/EL-14-F367.jpg		/E/L/EL-14-F367.jpg
406	87	/E/L/EL-14-F367.jpg		/E/L/EL-14-F367.jpg
406	97	tolpuddle-armchair		tolpuddle-armchair
406	112	TOLPUDDLE • ARMCHAIR		TOLPUDDLE • ARMCHAIR
406	113	TOLPUDDLE • ARMCHAIR		TOLPUDDLE • ARMCHAIR
406	114	TOLPUDDLE • ARMCHAIR		TOLPUDDLE • ARMCHAIR
406	118	2		2
406	119	4		4
406	144	INDEX,FOLLOW		INDEX,FOLLOW
523	71	CAPULET • TABLE		CAPULET • TABLE
523	86	/A/F/AF00001657.jpg		/A/F/AF00001657.jpg
523	87	/A/F/AF00001657.jpg		/A/F/AF00001657.jpg
523	97	capulet-table		capulet-table
523	112	CAPULET • TABLE		CAPULET • TABLE
523	113	CAPULET • TABLE		CAPULET • TABLE
523	114	CAPULET • TABLE		CAPULET • TABLE
523	118	2		2
523	119	4		4
523	144	INDEX,FOLLOW		INDEX,FOLLOW
337	73	60X60X80 cm		60X60X80 cm
341	73	48X48X48 cm		48X48X48 cm
406	73	56x60x108 cm		56x60x108 cm
523	73	65x65x58 cm		65x65x58 cm
337	75	6500.0000		6500.0000
337	76
337	120
341	75	2800.0000		2800.0000
341	76
341	120
406	75	15000.0000		15000.0000
406	76
406	120
523	75	8500.0000		8500.0000
523	76
523	120
337	77
337	78
337	93
337	94
341	77
341	78
341	93
341	94
406	77
406	78
406	93
406	94
523	77
523	78
523	93
523	94
337	96	1		1
337	137	0		0
337	121
341	96	1		1
341	137	0		0
341	121
406	96	1		1
406	137	0		0
406	121
523	96	1		1
523	137	0		0
523	121