"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 = '371') 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 = '371') 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 = '371') 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 = '371') 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 = '371') 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
12050 4 71 0 371 ROSALIND • SIDE TABLE
12051 4 82 0 371 ROSALIND • SIDE TABLE
12052 4 84 0 371 chair - - EL-14-F375
12053 4 85 0 371 /E/L/EL-14-F375.jpg
12054 4 86 0 371 /E/L/EL-14-F375.jpg
12055 4 87 0 371 /E/L/EL-14-F375.jpg
12056 4 97 0 371 rosalind-side-table
12057 4 98 0 371 rosalind-side-table.html
15684 4 103 0 371
12058 4 107 0 371
12059 4 109 0 371 container1
12060 4 112 0 371 ROSALIND • SIDE TABLE
12061 4 113 0 371 ROSALIND • SIDE TABLE
12062 4 114 0 371 ROSALIND • SIDE TABLE
15683 4 117 0 371
12063 4 118 0 371 2
12064 4 119 0 371 4
12065 4 122 0 371 0
21298 4 144 0 371 INDEX,FOLLOW
4106 4 75 0 371 9500.0000
4107 4 76 0 371
4108 4 80 0 371
4109 4 120 0 371
2856 4 96 0 371 1
2857 4 100 0 371 0
2858 4 102 0 371 4
3946 4 121 0 371
2859 4 137 0 371 0
3945 4 141 0 371 0
3157 4 72 0 371 Our slender Rosalind side table is ideal next to the sofa, hallway, entry way and bedroom to place magazines, vases, potted plants and decorative objects ontop of. The beautifully carved scalloped tabletop is timeless.
3158 4 73 0 371 66x66x69 cm
3159 4 83 0 371
3160 4 106 0 371
6247 4 77 0 371
6248 4 78 0 371
6249 4 93 0 371
6250 4 94 0 371
6251 4 104 0 371
6252 4 105 0 371