"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 = '367') 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 = '367') 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 = '367') 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 = '367') 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 = '367') 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
11986 4 71 0 367 BELGRAVIA • SOFA
11987 4 82 0 367 BELGRAVIA • SOFA
11988 4 84 0 367 Wall lantern - - NSSF-5139-60
11989 4 85 0 367 /N/S/NSSF-5139-60.jpg
11990 4 86 0 367 /N/S/NSSF-5139-60.jpg
11991 4 87 0 367 /N/S/NSSF-5139-60.jpg
11992 4 97 0 367 belgravia-sofa
11993 4 98 0 367 belgravia-sofa.html
15299 4 103 0 367
11994 4 107 0 367
11995 4 109 0 367 container1
11996 4 112 0 367 BELGRAVIA • SOFA
11997 4 113 0 367 BELGRAVIA • SOFA
11998 4 114 0 367 BELGRAVIA • SOFA
15298 4 117 0 367
11999 4 118 0 367 2
12000 4 119 0 367 4
12001 4 122 0 367 0
21286 4 144 0 367 INDEX,FOLLOW
4090 4 75 0 367 85000.0000
4091 4 76 0 367
4092 4 80 0 367
4093 4 120 0 367
2840 4 96 0 367 1
2841 4 100 0 367 0
2842 4 102 0 367 4
3718 4 121 0 367
2843 4 137 0 367 0
3717 4 141 0 367 0
3141 4 72 0 367 Our twist on the classic Chesterfield, the Belgravia T-Arm sofa has a sensual and luxurious presence. A curved back and all-over button tufting make this a comfortable and glamorous addition to any modern home.
3142 4 73 0 367 240x95x75 cm
3143 4 83 0 367
3144 4 106 0 367
6223 4 77 0 367
6224 4 78 0 367
6225 4 93 0 367
6226 4 94 0 367
6227 4 104 0 367
6228 4 105 0 367