"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 = '507') 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 = '507') 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 = '507') 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 = '507') 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 = '507') 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
14240 4 71 0 507 MALACHITE • JAR
14241 4 82 0 507 MALACHITE • JAR
14242 4 84 0 507 BAKER • BOOKEND - Bookend - QJY150431
14243 4 85 0 507 /Q/J/QJY150431.jpg
14244 4 86 0 507 /Q/J/QJY150431.jpg
14245 4 87 0 507 /Q/J/QJY150431.jpg
14246 4 97 0 507 malachite-jar
14247 4 98 0 507 malachite-jar.html
14248 4 107 0 507
14249 4 109 0 507 container1
14250 4 112 0 507 MALACHITE • JAR
14251 4 113 0 507 MALACHITE • JAR
14252 4 114 0 507 MALACHITE • JAR
14253 4 118 0 507 2
14254 4 119 0 507 4
14255 4 122 0 507 0
21706 4 144 0 507 INDEX,FOLLOW
4654 4 75 0 507 3000.0000
4655 4 76 0 507
4656 4 80 0 507
4657 4 120 0 507
3404 4 96 0 507 1
3405 4 100 0 507 0
3406 4 102 0 507 4
3407 4 137 0 507
3705 4 72 0 507 An exquisite and gorgeous jar handpainted with the natural patterns of malachite stone. Multicoloured hues of grey to more neutral tones reflect the intense concentric bands and eye shaped forms as seen in nature. The lid can be removed to place flowers or keepsakes inside.
3706 4 73 0 507 27x27x48 cm
3707 4 83 0 507
3708 4 106 0 507
7069 4 77 0 507
7070 4 78 0 507
7071 4 93 0 507
7072 4 94 0 507
7073 4 104 0 507
7074 4 105 0 507