"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 = '242') 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 = '242') 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 = '242') 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 = '242') 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 = '242') 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
9087 4 71 0 242 CROSBY • SOFA
9088 4 82 0 242 CROSBY • SOFA
9089 4 84 0 242 - - F90120002
9090 4 85 0 242 /F/9/F90120002_1.jpg
9091 4 86 0 242 /F/9/F90120002_1.jpg
9092 4 87 0 242 /F/9/F90120002_1.jpg
9093 4 97 0 242 crosby-sofa
9094 4 98 0 242 crosby-sofa.html
15125 4 103 0 242
9095 4 107 0 242
9096 4 109 0 242 container1
9097 4 112 0 242 CROSBY • SOFA
9098 4 113 0 242 CROSBY • SOFA
9099 4 114 0 242 CROSBY • SOFA
15124 4 117 0 242
9100 4 118 0 242 2
9101 4 119 0 242 4
9102 4 122 0 242 1
20911 4 144 0 242 INDEX,FOLLOW
3114 4 75 0 242 25000.0000
3115 4 76 0 242
3116 4 80 0 242
3117 4 120 0 242
2069 4 96 0 242 1
2070 4 100 0 242 0
2071 4 102 0 242 4
3652 4 121 0 242
2072 4 137 0 242 0
2277 4 72 0 242 Our Crosby sofa is comfy, cozy and loungey, the perfect solution for those looking for a place to curl up to read a book, entertain friends or just watch television. Open stitched seams and linen make it the most versatile and relaxed.
2278 4 73 0 242 220X120X83 cm
2279 4 83 0 242
2280 4 106 0 242
4810 4 77 0 242
4811 4 78 0 242
4812 4 93 0 242
4813 4 94 0 242
4814 4 104 0 242
4815 4 105 0 242
10687 4 98 1 242 crosby-sofa.html