"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 = '426') 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 = '426') 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 = '426') 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 = '426') 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 = '426') 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
12930 4 71 0 426 CLOVIS • BUREAU
12931 4 82 0 426 CLOVIS • BUREAU
12932 4 84 0 426 CORDELIA • SECRETAIRE - East meets West with our Cordelia secretary desk. Beautifully painted Chinoiserie, this desk has ample nooks and dividers to get you organized. - EL-12-F054
12933 4 85 0 426 /E/L/EL-12-F054.jpg
12934 4 86 0 426 /E/L/EL-12-F054.jpg
12935 4 87 0 426 /E/L/EL-12-F054.jpg
12936 4 97 0 426 clovis-bureau
12937 4 98 0 426 clovis-bureau.html
15804 4 103 0 426
12938 4 107 0 426
12939 4 109 0 426 container1
12940 4 112 0 426 CLOVIS • BUREAU
12941 4 113 0 426 CLOVIS • BUREAU
12942 4 114 0 426 CLOVIS • BUREAU
15803 4 117 0 426
12943 4 118 0 426 2
12944 4 119 0 426 4
12945 4 122 0 426 0
21463 4 144 0 426 INDEX,FOLLOW
4326 4 75 0 426 188000.0000
4327 4 76 0 426
4328 4 80 0 426
4329 4 120 0 426
3076 4 96 0 426 1
3077 4 100 0 426 0
3078 4 102 0 426 4
4018 4 121 0 426
3079 4 137 0 426 0
4017 4 141 0 426 0
3377 4 72 0 426 Clovis is an English Queen Anne Chinoiserie bureau bookcase featuring 18th century double-domed upper section with finials and central cartouche. This bureau is spectacular when the front panels are opened to reveal an interior with multiple drawers and cupboards. The base of the bureau has 3 larger drawers for additional storage.
3378 4 73 0 426 102x61x218 cm
3379 4 83 0 426
3380 4 106 0 426
6577 4 77 0 426
6578 4 78 0 426
6579 4 93 0 426
6580 4 94 0 426
6581 4 104 0 426
6582 4 105 0 426