"Back"

SQL Select

Executed SQL
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 = '401') 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 = '401') 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 = '401') 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 = '401') 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 = '401') 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
12530 4 71 0 401 OPHELIA • COFFEE TABLE
12531 4 82 0 401 OPHELIA • COFFEE TABLE
12532 4 84 0 401 - - EL-14-F362
12533 4 85 0 401 /E/L/EL-14-F362.jpg
12534 4 86 0 401 /E/L/EL-14-F362.jpg
12535 4 87 0 401 /E/L/EL-14-F362.jpg
12536 4 97 0 401 ophelia-coffee-table
12537 4 98 0 401 ophelia-coffee-table.html
15534 4 103 0 401
12538 4 107 0 401
12539 4 109 0 401 container1
12540 4 112 0 401 OPHELIA • COFFEE TABLE
12541 4 113 0 401 OPHELIA • COFFEE TABLE
12542 4 114 0 401 OPHELIA • COFFEE TABLE
15533 4 117 0 401
12543 4 118 0 401 2
12544 4 119 0 401 4
12545 4 122 0 401 0
21388 4 144 0 401 INDEX,FOLLOW
4226 4 75 0 401 17500.0000
4227 4 76 0 401
4228 4 80 0 401
4229 4 120 0 401
2976 4 96 0 401 1
2977 4 100 0 401 0
2978 4 102 0 401 4
3856 4 121 0 401
2979 4 137 0 401 0
3855 4 141 0 401 0
3277 4 72 0 401 Brighten up a dull iiving space with our rectangular Ophelia coffee table. Handcrafted using ancient techniques, this ornate coffee table catches your eye from every angle. Matching side table will add additional luxury to any space.
3278 4 73 0 401 125x71x51 cm
3279 4 83 0 401
3280 4 106 0 401
6427 4 77 0 401
6428 4 78 0 401
6429 4 93 0 401
6430 4 94 0 401
6431 4 104 0 401
6432 4 105 0 401