"Back"

SQL Select

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