"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 = '450') 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 = '450') 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 = '450') 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 = '450') 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 = '450') 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
13314 4 71 0 450 LIA • CLOISONNE TILE BOX
13315 4 82 0 450 LIA • CLOISONNE TILE BOX
13316 4 84 0 450 AUGUSTINE • ARMCHAIR - Our Augustine Chair reimagines formal lines of the Victorian era upolstered in elegant damask fabric. The wooden arm rests and trumpet legs are beautifully hand carved and polished. - AW00000565
13317 4 85 0 450 /A/W/AW00000565.jpg
13318 4 86 0 450 /A/W/AW00000565.jpg
13319 4 87 0 450 /A/W/AW00000565.jpg
13320 4 97 0 450 lia-cloisonne-tile-box
13321 4 98 0 450 lia-cloisonne-tile-box.html
13322 4 107 0 450
13323 4 109 0 450 container1
13324 4 112 0 450 LIA • CLOISONNE TILE BOX
13325 4 113 0 450 LIA • CLOISONNE TILE BOX
13326 4 114 0 450 LIA • CLOISONNE TILE BOX
13327 4 118 0 450 2
13328 4 119 0 450 4
13329 4 122 0 450 0
21535 4 144 0 450 INDEX,FOLLOW
4422 4 75 0 450 2200.0000
4423 4 76 0 450
4424 4 80 0 450
4425 4 120 0 450
3172 4 96 0 450 1
3173 4 100 0 450 0
3174 4 102 0 450 4
3175 4 137 0 450
3473 4 72 0 450 Part of our cloisonné tile box series, Lia is a sumptuous square box wrapped in tangerine orange leather with a tan canvas interior. The lid features a singular cloisonné tile for a handle. Place it on a coffee table to bring warmth and delight to your home.
3474 4 73 0 450 21.5x21.5x6.5 cm
3475 4 83 0 450
3476 4 106 0 450
6721 4 77 0 450
6722 4 78 0 450
6723 4 93 0 450
6724 4 94 0 450
6725 4 104 0 450
6726 4 105 0 450