"Back"

SQL Select

Executed SQL
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 = '464') 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 = '464') 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 = '464') 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 = '464') 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 = '464') 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
13538 4 71 0 464 BEAM • BOOKEND
13539 4 82 0 464 BEAM • BOOKEND
13540 4 84 0 464 CHARLEMAGNE • SHELF - Our most popular solid wood Charlemagne cabinet has easily accesible glass shelving to display your most precious items. Hand painted gold rimming adds to it's subtle elegance. A useful side cabinet for all your keepsakes and books.
13541 4 85 0 464 /D/4/D42110131.jpg
13542 4 86 0 464 /D/4/D42110131.jpg
13543 4 87 0 464 /D/4/D42110131.jpg
13544 4 97 0 464 beam-bookend
13545 4 98 0 464 beam-bookend.html
16057 4 103 0 464
13546 4 107 0 464
13547 4 109 0 464 container1
13548 4 112 0 464 BEAM • BOOKEND
13549 4 113 0 464 BEAM • BOOKEND
13550 4 114 0 464 BEAM • BOOKEND
16056 4 117 0 464
13551 4 118 0 464 2
13552 4 119 0 464 4
13553 4 122 0 464 0
21577 4 144 0 464 INDEX,FOLLOW
4478 4 75 0 464 1400.0000
4479 4 76 0 464
4480 4 80 0 464
4481 4 120 0 464
3228 4 96 0 464 1
3229 4 100 0 464 0
3230 4 102 0 464 4
4143 4 121 0 464
3231 4 137 0 464 0
4142 4 141 0 464 0
3529 4 72 0 464 Bookend
3530 4 73 0 464 16x11x17 cm
3531 4 83 0 464
3532 4 106 0 464
6805 4 77 0 464
6806 4 78 0 464
6807 4 93 0 464
6808 4 94 0 464
6809 4 104 0 464
6810 4 105 0 464