"Back"

SQL Select

{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}
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 (380, 521, 520, 430, 429, 428, 427, 426, 425, 424, 423, 422)) 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 (380, 521, 520, 430, 429, 428, 427, 426, 425, 424, 423, 422)) 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 (380, 521, 520, 430, 429, 428, 427, 426, 425, 424, 423, 422)) 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 (380, 521, 520, 430, 429, 428, 427, 426, 425, 424, 423, 422)) 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 (380, 521, 520, 430, 429, 428, 427, 426, 425, 424, 423, 422)) 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
380 71 MALCOLM ROUGE • DESK MALCOLM ROUGE • DESK
380 86 /E/L/EL-12-F155R.jpg /E/L/EL-12-F155R.jpg
380 87 /E/L/EL-12-F155R.jpg /E/L/EL-12-F155R.jpg
380 97 malcolm-rouge-desk malcolm-rouge-desk
380 112 MALCOLM ROUGE • DESK MALCOLM ROUGE • DESK
380 113 MALCOLM ROUGE • DESK MALCOLM ROUGE • DESK
380 114 MALCOLM ROUGE • DESK MALCOLM ROUGE • DESK
380 118 2 2
380 119 4 4
380 144 INDEX,FOLLOW INDEX,FOLLOW
422 71 LOUIS • SHELF LOUIS • SHELF
422 86 /E/L/EL-F6005B.jpg /E/L/EL-F6005B.jpg
422 87 /E/L/EL-F6005B.jpg /E/L/EL-F6005B.jpg
422 97 louis-shelf louis-shelf
422 112 LOUIS • SHELF LOUIS • SHELF
422 113 LOUIS • SHELF LOUIS • SHELF
422 114 LOUIS • SHELF LOUIS • SHELF
422 118 2 2
422 119 4 4
422 144 INDEX,FOLLOW INDEX,FOLLOW
423 71 CHARLEMAGNE • SHELF CHARLEMAGNE • SHELF
423 86 /E/L/EL-F6007.jpg /E/L/EL-F6007.jpg
423 87 /E/L/EL-F6007.jpg /E/L/EL-F6007.jpg
423 97 charlemagne-shelf charlemagne-shelf
423 112 CHARLEMAGNE • SHELF CHARLEMAGNE • SHELF
423 113 CHARLEMAGNE • SHELF CHARLEMAGNE • SHELF
423 114 CHARLEMAGNE • SHELF CHARLEMAGNE • SHELF
423 118 2 2
423 119 4 4
423 144 INDEX,FOLLOW INDEX,FOLLOW
424 71 PUYI • SHELF PUYI • SHELF
424 86 /E/L/EL-14-F392.jpg /E/L/EL-14-F392.jpg
424 87 /E/L/EL-14-F392.jpg /E/L/EL-14-F392.jpg
424 97 puyi-shelf puyi-shelf
424 112 PUYI • SHELF PUYI • SHELF
424 113 PUYI • SHELF PUYI • SHELF
424 114 PUYI • SHELF PUYI • SHELF
424 118 2 2
424 119 4 4
424 144 INDEX,FOLLOW INDEX,FOLLOW
425 71 QIANLONG • CABINET ON STAND QIANLONG • CABINET ON STAND
425 86 /E/L/EL-14-F302.jpg /E/L/EL-14-F302.jpg
425 87 /E/L/EL-14-F302.jpg /E/L/EL-14-F302.jpg
425 97 qianlong-cabinet-on-stand qianlong-cabinet-on-stand
425 112 QIANLONG • CABINET ON STAND QIANLONG • CABINET ON STAND
425 113 QIANLONG • CABINET ON STAND QIANLONG • CABINET ON STAND
425 114 QIANLONG • CABINET ON STAND QIANLONG • CABINET ON STAND
425 118 2 2
425 119 4 4
425 144 INDEX,FOLLOW INDEX,FOLLOW
426 71 CLOVIS • BUREAU CLOVIS • BUREAU
426 86 /E/L/EL-12-F054.jpg /E/L/EL-12-F054.jpg
426 87 /E/L/EL-12-F054.jpg /E/L/EL-12-F054.jpg
426 97 clovis-bureau clovis-bureau
426 112 CLOVIS • BUREAU CLOVIS • BUREAU
426 113 CLOVIS • BUREAU CLOVIS • BUREAU
426 114 CLOVIS • BUREAU CLOVIS • BUREAU
426 118 2 2
426 119 4 4
426 144 INDEX,FOLLOW INDEX,FOLLOW
427 71 CHILDERIC • BUREAU CHILDERIC • BUREAU
427 86 /E/L/EL-14-F300.jpg /E/L/EL-14-F300.jpg
427 87 /E/L/EL-14-F300.jpg /E/L/EL-14-F300.jpg
427 97 childeric-bureau childeric-bureau
427 112 CHILDERIC • BUREAU CHILDERIC • BUREAU
427 113 CHILDERIC • BUREAU CHILDERIC • BUREAU
427 114 CHILDERIC • BUREAU CHILDERIC • BUREAU
427 118 2 2
427 119 4 4
427 144 INDEX,FOLLOW INDEX,FOLLOW
428 71 YONGLE • WARDROBE YONGLE • WARDROBE
428 86 /E/L/EL-14-F314.jpg /E/L/EL-14-F314.jpg
428 87 /E/L/EL-14-F314.jpg /E/L/EL-14-F314.jpg
428 97 yongle-wardrobe yongle-wardrobe
428 112 YONGLE • WARDROBE YONGLE • WARDROBE
428 113 YONGLE • WARDROBE YONGLE • WARDROBE
428 114 YONGLE • WARDROBE YONGLE • WARDROBE
428 118 2 2
428 119 4 4
428 144 INDEX,FOLLOW INDEX,FOLLOW
429 71 TIBERIUS • SHELF TIBERIUS • SHELF
429 86 /E/L/EL-12-F089.jpg /E/L/EL-12-F089.jpg
429 87 /E/L/EL-12-F089.jpg /E/L/EL-12-F089.jpg
429 97 tiberius-shelf tiberius-shelf
429 112 TIBERIUS • SHELF TIBERIUS • SHELF
429 113 TIBERIUS • SHELF TIBERIUS • SHELF
429 114 TIBERIUS • SHELF TIBERIUS • SHELF
429 118 2 2
429 119 4 4
429 144 INDEX,FOLLOW INDEX,FOLLOW
430 71 WANLI • SHELF WANLI • SHELF
430 86 /E/L/EL-13-F262.jpg /E/L/EL-13-F262.jpg
430 87 /E/L/EL-13-F262.jpg /E/L/EL-13-F262.jpg
430 97 wanli-shelf wanli-shelf
430 112 WANLI • SHELF WANLI • SHELF
430 113 WANLI • SHELF WANLI • SHELF
430 114 WANLI • SHELF WANLI • SHELF
430 118 2 2
430 119 4 4
430 144 INDEX,FOLLOW INDEX,FOLLOW
520 71 EDWARD • TABLE EDWARD • TABLE
520 86 /A/F/AF00001645.jpg /A/F/AF00001645.jpg
520 87 /A/F/AF00001645.jpg /A/F/AF00001645.jpg
520 97 edward-table edward-table
520 112 EDWARD • TABLE EDWARD • TABLE
520 113 EDWARD • TABLE EDWARD • TABLE
520 114 EDWARD • TABLE EDWARD • TABLE
520 118 2 2
520 119 4 4
520 144 INDEX,FOLLOW INDEX,FOLLOW
521 71 BIANCA • TABLE BIANCA • TABLE
521 86 /A/F/AF00001652.jpg /A/F/AF00001652.jpg
521 87 /A/F/AF00001652.jpg /A/F/AF00001652.jpg
521 97 bianca-table bianca-table
521 112 BIANCA • TABLE BIANCA • TABLE
521 113 BIANCA • TABLE BIANCA • TABLE
521 114 BIANCA • TABLE BIANCA • TABLE
521 118 2 2
521 119 4 4
521 144 INDEX,FOLLOW INDEX,FOLLOW
380 73 122x62x76 cm 122x62x76 cm
422 73 127x46x208 cm 127x46x208 cm
423 73 107x38x204 cm 107x38x204 cm
424 73 48x28x108 cm 48x28x108 cm
425 73 117x37x231 cm 117x37x231 cm
426 73 102x61x218 cm 102x61x218 cm
427 73 110x56x229 cm 110x56x229 cm
428 73 140x47x242 cm 140x47x242 cm
429 73 80x38x196 cm 80x38x196 cm
430 73 63x21x95 cm 63x21x95 cm
520 73 125x55x85 cm 125x55x85 cm
521 73 190x55x95 cm 190x55x95 cm
380 75 21500.0000 21500.0000
380 76
380 120
422 75 55000.0000 55000.0000
422 76
422 120
423 75 65000.0000 65000.0000
423 76
423 120
424 75 42000.0000 42000.0000
424 76
424 120
425 75 85000.0000 85000.0000
425 76
425 120
426 75 188000.0000 188000.0000
426 76
426 120
427 75 188000.0000 188000.0000
427 76
427 120
428 75 70000.0000 70000.0000
428 76
428 120
429 75 55000.0000 55000.0000
429 76
429 120
430 75 22000.0000 22000.0000
430 76
430 120
520 75 8500.0000 8500.0000
520 76
520 120
521 75 12000.0000 12000.0000
521 76
521 120
380 77
380 78
380 93
380 94
422 77
422 78
422 93
422 94
423 77
423 78
423 93
423 94
424 77
424 78
424 93
424 94
425 77
425 78
425 93
425 94
426 77
426 78
426 93
426 94
427 77
427 78
427 93
427 94
428 77
428 78
428 93
428 94
429 77
429 78
429 93
429 94
430 77
430 78
430 93
430 94
520 77
520 78
520 93
520 94
521 77
521 78
521 93
521 94
380 96 1 1
380 137 0 0
380 121
422 96 1 1
422 137 0 0
422 121
423 96 1 1
423 137 0 0
423 121
424 96 1 1
424 137 0 0
424 121
425 96 1 1
425 137 0 0
425 121
426 96 1 1
426 137 0 0
426 121
427 96 1 1
427 137 0 0
427 121
428 96 1 1
428 137 1 1
428 121
429 96 1 1
429 137 0 0
429 121
430 96 1 1
430 137 0 0
430 121
520 96 1 1
520 137 0 0
520 121
521 96 1 1
521 137 0 0
521 121