"Back"

SQL Select

Executed SQL
SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (501, 507)) AND (t_d.attribute_id IN ('71', '86', '87', '97', '112', '113', '114', '118', '119', '144')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (501, 507)) AND (t_d.attribute_id IN ('73')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_decimal` AS `t_d` LEFT JOIN `catalog_product_entity_decimal` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (501, 507)) AND (t_d.attribute_id IN ('75', '76', '120')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_datetime` AS `t_d` LEFT JOIN `catalog_product_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (501, 507)) AND (t_d.attribute_id IN ('77', '78', '93', '94')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 4) AND (t_d.entity_id IN (501, 507)) AND (t_d.attribute_id IN ('96', '121', '123', '125', '126', '127', '128', '131', '137')) AND (t_d.store_id = 0)
entity_id attribute_id default_value store_value value
501 71 FUSCHIA • VASE FUSCHIA • VASE
501 86 /Q/J/QJY150053-S.jpg /Q/J/QJY150053-S.jpg
501 87 /Q/J/QJY150053-S.jpg /Q/J/QJY150053-S.jpg
501 97 fuschia-vase fuschia-vase
501 112 FUSCHIA • VASE FUSCHIA • VASE
501 113 FUSCHIA • VASE FUSCHIA • VASE
501 114 FUSCHIA • VASE FUSCHIA • VASE
501 118 2 2
501 119 4 4
501 144 INDEX,FOLLOW INDEX,FOLLOW
507 71 MALACHITE • JAR MALACHITE • JAR
507 86 /Q/J/QJY150431.jpg /Q/J/QJY150431.jpg
507 87 /Q/J/QJY150431.jpg /Q/J/QJY150431.jpg
507 97 malachite-jar malachite-jar
507 112 MALACHITE • JAR MALACHITE • JAR
507 113 MALACHITE • JAR MALACHITE • JAR
507 114 MALACHITE • JAR MALACHITE • JAR
507 118 2 2
507 119 4 4
507 144 INDEX,FOLLOW INDEX,FOLLOW
501 73 24x24x41.5 cm 24x24x41.5 cm
507 73 27x27x48 cm 27x27x48 cm
501 75 2600.0000 2600.0000
501 76
501 120
507 75 3000.0000 3000.0000
507 76
507 120
501 77
501 78
501 93
501 94
507 77
507 78
507 93
507 94
501 96 1 1
501 137
507 96 1 1
507 137