"Back"

SQL Select

{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}
SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '471') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '471') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '471') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '471') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '471') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
value_id entity_type_id attribute_id store_id entity_id value
13650 4 71 0 471 CURIO II • DOME
13651 4 82 0 471 CURIO II • DOME
13652 4 84 0 471 AIDA • SIDE TABLE - Delicately crafted by artisans, with a graceful floral design, the Aida lacquer black side table evokes the bombée style of Paris in the mid-1700s. Bringing warmth to your living space with a solid wood countertop. - AG00000810
13653 4 85 0 471 /A/G/AG00000810.jpg
13654 4 86 0 471 /A/G/AG00000810.jpg
13655 4 87 0 471 /A/G/AG00000810.jpg
13656 4 97 0 471 curio-ii-dome
13657 4 98 0 471 curio-ii-dome.html
16092 4 103 0 471
13658 4 107 0 471
13659 4 109 0 471 container1
13660 4 112 0 471 CURIO II • DOME
13661 4 113 0 471 CURIO II • DOME
13662 4 114 0 471 CURIO II • DOME
16091 4 117 0 471
13663 4 118 0 471 2
13664 4 119 0 471 4
13665 4 122 0 471 0
21598 4 144 0 471 INDEX,FOLLOW
4506 4 75 0 471 1200.0000
4507 4 76 0 471
4508 4 80 0 471
4509 4 120 0 471
3256 4 96 0 471 1
3257 4 100 0 471 0
3258 4 102 0 471 4
4164 4 121 0 471
3259 4 137 0 471 0
4163 4 141 0 471 0
3557 4 72 0 471 Glass dome
3558 4 73 0 471 32x18x43 cm
3559 4 83 0 471
3560 4 106 0 471
6847 4 77 0 471
6848 4 78 0 471
6849 4 93 0 471
6850 4 94 0 471
6851 4 104 0 471
6852 4 105 0 471