"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 = '369') 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 = '369') 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 = '369') 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 = '369') 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 = '369') 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
12018 4 71 0 369 ESCAMILLO • SIDE TABLE
12019 4 82 0 369 ESCAMILLO • SIDE TABLE
12020 4 84 0 369 Love Seat - - D72130010
12021 4 85 0 369 /D/7/D72130010.jpg
12022 4 86 0 369 /D/7/D72130010.jpg
12023 4 87 0 369 /D/7/D72130010.jpg
12024 4 97 0 369 escamillo-side-table
12025 4 98 0 369 escamillo-side-table.html
15694 4 103 0 369
12026 4 107 0 369
12027 4 109 0 369 container1
12028 4 112 0 369 ESCAMILLO • SIDE TABLE
12029 4 113 0 369 ESCAMILLO • SIDE TABLE
12030 4 114 0 369 ESCAMILLO • SIDE TABLE
15693 4 117 0 369
12031 4 118 0 369 2
12032 4 119 0 369 4
12033 4 122 0 369 0
21292 4 144 0 369 INDEX,FOLLOW
4098 4 75 0 369 2500.0000
4099 4 76 0 369
4100 4 80 0 369
4101 4 120 0 369
2848 4 96 0 369 1
2849 4 100 0 369 0
2850 4 102 0 369 4
3952 4 121 0 369
2851 4 137 0 369 0
3951 4 141 0 369 0
3149 4 72 0 369 Prismatic and hand polished, our brass Escamillo functions well as a side tabe, plant pedestal or sculptural stand. The clean lines and industrial finishing appeals to those looking for a conversation piece.
3150 4 73 0 369 41x41x68 cm
3151 4 83 0 369
3152 4 106 0 369
6235 4 77 0 369
6236 4 78 0 369
6237 4 93 0 369
6238 4 94 0 369
6239 4 104 0 369
6240 4 105 0 369