"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 = '470') 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 = '470') 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 = '470') 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 = '470') 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 = '470') 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
13634 4 71 0 470 BLOW FIST • FLAT DOME
13635 4 82 0 470 BLOW FIST • FLAT DOME
13636 4 84 0 470 PEPIN • COMMODE - The commode that every house needs is Pepin. Intricately hand detailed with laurels and filigree transports you to the French countryside. 2 larger side panels open up to store tall items while 3 pull out drawers are perfect to keep you
13637 4 85 0 470 /A/G/AG00000776.jpg
13638 4 86 0 470 /A/G/AG00000776.jpg
13639 4 87 0 470 /A/G/AG00000776.jpg
13640 4 97 0 470 blow-fist-flat-dome
13641 4 98 0 470 blow-fist-flat-dome.html
16087 4 103 0 470
13642 4 107 0 470
13643 4 109 0 470 container1
13644 4 112 0 470 BLOW FIST • FLAT DOME
13645 4 113 0 470 BLOW FIST • FLAT DOME
13646 4 114 0 470 BLOW FIST • FLAT DOME
16086 4 117 0 470
13647 4 118 0 470 2
13648 4 119 0 470 4
13649 4 122 0 470 0
21595 4 144 0 470 INDEX,FOLLOW
4502 4 75 0 470 3000.0000
4503 4 76 0 470
4504 4 80 0 470
4505 4 120 0 470
3252 4 96 0 470 1
3253 4 100 0 470 0
3254 4 102 0 470 4
4161 4 121 0 470
3255 4 137 0 470 0
4160 4 141 0 470 0
3553 4 72 0 470 Stunning specimens and delightful accents add a whimsical touch to any space. Natural specimens are beautifully encased to add sophistication and fascination.
3554 4 73 0 470 43x22x53 cm
3555 4 83 0 470
3556 4 106 0 470
6841 4 77 0 470
6842 4 78 0 470
6843 4 93 0 470
6844 4 94 0 470
6845 4 104 0 470
6846 4 105 0 470