"Back"

SQL Select

Executed SQL
SELECT `attr_table`.* FROM `catalog_category_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 = '3' WHERE (attr_table.entity_id = '70') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_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 = '3' WHERE (attr_table.entity_id = '70') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_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 = '3' WHERE (attr_table.entity_id = '70') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_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 = '3' WHERE (attr_table.entity_id = '70') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_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 = '3' WHERE (attr_table.entity_id = '70') 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
1450 3 41 0 70 (Craftsmanship)
1451 3 43 0 70 craftsmanship
1452 3 46 0 70 Craftsmanship, Ancient Chinese Arts & Crafts
1453 3 49 0 70 PAGE
1454 3 58 0 70
1455 3 61 0 70 one_column
1456 3 133 0 70
1457 3 134 0 70
1459 3 57 0 70 about-us/discover/craftsmanship.html
4984 3 145 0 70 INDEX,FOLLOW
558 3 42 0 70 1
559 3 67 0 70 1
560 3 50 0 70 45
561 3 51 0 70 0
562 3 68 0 70 1
563 3 69 0 70 0
564 3 132 0 70 1
682 3 44 0 70
683 3 47 0 70 craftsmanship, Chinese craft, Chinese crafts, Chinese art and craft, Chinese arts and crafts, china craft, china crafts, ancient crafts, china arts and crafts, Chinese arts & crafts
684 3 48 0 70 Reinventing ancient Craftsmanship is our purpose at LALA CURIO. Come explore lost Chinese art & crafts with a 21st century twist.
685 3 62 0 70
686 3 65 0 70
273 3 59 0 70
274 3 60 0 70
69 3 70 0 70
1458 3 57 1 70 about-us/discover/craftsmanship.html