"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 = '474') 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 = '474') 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 = '474') 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 = '474') 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 = '474') 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
13698 4 71 0 474 AMMONITE BOOKENDS
13699 4 82 0 474 AMMONITE BOOKENDS
13700 4 84 0 474 WANLI • WARDROBE - A minimalist wardrobe, Wanli is a modern twist on the Chinese wedding cabinet design. The round gold handle in the front brings balance, zen and calmness to a room. - AM00000909
13701 4 85 0 474 /A/M/AM00000909.jpg
13702 4 86 0 474 /A/M/AM00000909.jpg
13703 4 87 0 474 /A/M/AM00000909.jpg
13704 4 97 0 474 ammonite-bookends
13705 4 98 0 474 ammonite-bookends.html
16112 4 103 0 474
13706 4 107 0 474
13707 4 109 0 474 container1
13708 4 112 0 474 AMMONITE BOOKENDS
13709 4 113 0 474 AMMONITE BOOKENDS
13710 4 114 0 474 AMMONITE BOOKENDS
16111 4 117 0 474
13711 4 118 0 474 2
13712 4 119 0 474 4
13713 4 122 0 474 0
21607 4 144 0 474 INDEX,FOLLOW
4518 4 75 0 474 850.0000
4519 4 76 0 474
4520 4 80 0 474
4521 4 120 0 474
3268 4 96 0 474 1
3269 4 100 0 474 0
3270 4 102 0 474 4
4174 4 121 0 474
3271 4 137 0 474 0
4173 4 141 0 474 0
3569 4 72 0 474 Ammonite bookends
3570 4 73 0 474 13.5x11x12.5 cm
3571 4 83 0 474
3572 4 106 0 474
6865 4 77 0 474
6866 4 78 0 474
6867 4 93 0 474
6868 4 94 0 474
6869 4 104 0 474
6870 4 105 0 474