"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 = '393') 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 = '393') 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 = '393') 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 = '393') 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 = '393') 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
12402 4 71 0 393 OBERON • COFFEE TABLE
12403 4 82 0 393 OBERON • COFFEE TABLE
12404 4 84 0 393 BIRDS & BEETLES • WALLPAPER I - - AF00001512
12405 4 85 0 393 /A/F/AF00001512.jpg
12406 4 86 0 393 /A/F/AF00001512.jpg
12407 4 87 0 393 /A/F/AF00001512.jpg
12408 4 97 0 393 oberon-coffee-table
12409 4 98 0 393 oberon-coffee-table.html
15574 4 103 0 393
12410 4 107 0 393
12411 4 109 0 393 container1
12412 4 112 0 393 OBERON • COFFEE TABLE
12413 4 113 0 393 OBERON • COFFEE TABLE
12414 4 114 0 393 OBERON • COFFEE TABLE
15573 4 117 0 393
12415 4 118 0 393 2
12416 4 119 0 393 4
12417 4 122 0 393 0
21364 4 144 0 393 INDEX,FOLLOW
4194 4 75 0 393 8500.0000
4195 4 76 0 393
4196 4 80 0 393
4197 4 120 0 393
2944 4 96 0 393 1
2945 4 100 0 393 0
2946 4 102 0 393 4
3880 4 121 0 393
2947 4 137 0 393 0
3879 4 141 0 393 0
3245 4 72 0 393 Display your stunning barware and glassware collection on our Oberon coffee table. A white tray with curved edges sits ontop solid gold legs creating a playful look.
3246 4 73 0 393 108x50x53 cm
3247 4 83 0 393
3248 4 106 0 393
6379 4 77 0 393
6380 4 78 0 393
6381 4 93 0 393
6382 4 94 0 393
6383 4 104 0 393
6384 4 105 0 393