"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 (464, 465, 466, 467, 474)) 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 (464, 465, 466, 467, 474)) 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 (464, 465, 466, 467, 474)) 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 (464, 465, 466, 467, 474)) 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 (464, 465, 466, 467, 474)) 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
464 71 BEAM • BOOKEND BEAM • BOOKEND
464 86 /D/4/D42110131.jpg /D/4/D42110131.jpg
464 87 /D/4/D42110131.jpg /D/4/D42110131.jpg
464 97 beam-bookend beam-bookend
464 112 BEAM • BOOKEND BEAM • BOOKEND
464 113 BEAM • BOOKEND BEAM • BOOKEND
464 114 BEAM • BOOKEND BEAM • BOOKEND
464 118 2 2
464 119 4 4
464 144 INDEX,FOLLOW INDEX,FOLLOW
465 71 BAKER • BOOKEND BAKER • BOOKEND
465 86 /D/4/D42110132.jpg /D/4/D42110132.jpg
465 87 /D/4/D42110132.jpg /D/4/D42110132.jpg
465 97 baker-bookend baker-bookend
465 112 BAKER • BOOKEND BAKER • BOOKEND
465 113 BAKER • BOOKEND BAKER • BOOKEND
465 114 BAKER • BOOKEND BAKER • BOOKEND
465 118 2 2
465 119 4 4
465 144 INDEX,FOLLOW INDEX,FOLLOW
466 71 ECHO • BOOKEND ECHO • BOOKEND
466 86 /D/4/D42110133.jpg /D/4/D42110133.jpg
466 87 /D/4/D42110133.jpg /D/4/D42110133.jpg
466 97 echo-bookend echo-bookend
466 112 ECHO • BOOKEND ECHO • BOOKEND
466 113 ECHO • BOOKEND ECHO • BOOKEND
466 114 ECHO • BOOKEND ECHO • BOOKEND
466 118 2 2
466 119 4 4
466 144 INDEX,FOLLOW INDEX,FOLLOW
467 71 PARKER • TABLE DÉCOR PARKER • TABLE DÉCOR
467 86 /D/4/D42110135.jpg /D/4/D42110135.jpg
467 87 /D/4/D42110135.jpg /D/4/D42110135.jpg
467 97 parker-table-decor parker-table-decor
467 112 PARKER • TABLE DÉCOR PARKER • TABLE DÉCOR
467 113 PARKER • TABLE DÉCOR PARKER • TABLE DÉCOR
467 114 PARKER • TABLE DÉCOR PARKER • TABLE DÉCOR
467 118 2 2
467 119 4 4
467 144 INDEX,FOLLOW INDEX,FOLLOW
474 71 AMMONITE BOOKENDS AMMONITE BOOKENDS
474 86 /A/M/AM00000909.jpg /A/M/AM00000909.jpg
474 87 /A/M/AM00000909.jpg /A/M/AM00000909.jpg
474 97 ammonite-bookends ammonite-bookends
474 112 AMMONITE BOOKENDS AMMONITE BOOKENDS
474 113 AMMONITE BOOKENDS AMMONITE BOOKENDS
474 114 AMMONITE BOOKENDS AMMONITE BOOKENDS
474 118 2 2
474 119 4 4
474 144 INDEX,FOLLOW INDEX,FOLLOW
464 73 16x11x17 cm 16x11x17 cm
465 73 16x10x17 cm 16x10x17 cm
466 73 16x10x17 cm 16x10x17 cm
467 73 8x6x21 cm 8x6x21 cm
474 73 13.5x11x12.5 cm 13.5x11x12.5 cm
464 75 1400.0000 1400.0000
464 76
464 120
465 75 1400.0000 1400.0000
465 76
465 120
466 75 1700.0000 1700.0000
466 76
466 120
467 75 500.0000 500.0000
467 76
467 120
474 75 850.0000 850.0000
474 76
474 120
464 77
464 78
464 93
464 94
465 77
465 78
465 93
465 94
466 77
466 78
466 93
466 94
467 77
467 78
467 93
467 94
474 77
474 78
474 93
474 94
464 96 1 1
464 137 0 0
464 121
465 96 1 1
465 137 0 0
465 121
466 96 1 1
466 137 0 0
466 121
467 96 1 1
467 137 0 0
467 121
474 96 1 1
474 137 0 0
474 121