"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 (522, 399, 398, 397, 396, 395, 394, 393, 392, 391, 400, 401)) 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 (522, 399, 398, 397, 396, 395, 394, 393, 392, 391, 400, 401)) 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 (522, 399, 398, 397, 396, 395, 394, 393, 392, 391, 400, 401)) 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 (522, 399, 398, 397, 396, 395, 394, 393, 392, 391, 400, 401)) 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 (522, 399, 398, 397, 396, 395, 394, 393, 392, 391, 400, 401)) 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
391 71 CELIA • SIDE TABLE CELIA • SIDE TABLE
391 86 /A/F/AF00001477.jpg /A/F/AF00001477.jpg
391 87 /A/F/AF00001477.jpg /A/F/AF00001477.jpg
391 97 celia-side-table celia-side-table
391 112 CELIA • SIDE TABLE CELIA • SIDE TABLE
391 113 CELIA • SIDE TABLE CELIA • SIDE TABLE
391 114 CELIA • SIDE TABLE CELIA • SIDE TABLE
391 118 2 2
391 119 4 4
391 144 INDEX,FOLLOW INDEX,FOLLOW
392 71 FENGE • CONSOLE FENGE • CONSOLE
392 86 /A/F/AF00001494.jpg /A/F/AF00001494.jpg
392 87 /A/F/AF00001494.jpg /A/F/AF00001494.jpg
392 97 fenge-console fenge-console
392 112 FENGE • CONSOLE FENGE • CONSOLE
392 113 FENGE • CONSOLE FENGE • CONSOLE
392 114 FENGE • CONSOLE FENGE • CONSOLE
392 118 2 2
392 119 4 4
392 144 INDEX,FOLLOW INDEX,FOLLOW
393 71 OBERON • COFFEE TABLE OBERON • COFFEE TABLE
393 86 /A/F/AF00001512.jpg /A/F/AF00001512.jpg
393 87 /A/F/AF00001512.jpg /A/F/AF00001512.jpg
393 97 oberon-coffee-table oberon-coffee-table
393 112 OBERON • COFFEE TABLE OBERON • COFFEE TABLE
393 113 OBERON • COFFEE TABLE OBERON • COFFEE TABLE
393 114 OBERON • COFFEE TABLE OBERON • COFFEE TABLE
393 118 2 2
393 119 4 4
393 144 INDEX,FOLLOW INDEX,FOLLOW
394 71 PUCK • SIDE TABLE PUCK • SIDE TABLE
394 86 /A/F/AF00001513.jpg /A/F/AF00001513.jpg
394 87 /A/F/AF00001513.jpg /A/F/AF00001513.jpg
394 97 puck-side-table puck-side-table
394 112 PUCK • SIDE TABLE PUCK • SIDE TABLE
394 113 PUCK • SIDE TABLE PUCK • SIDE TABLE
394 114 PUCK • SIDE TABLE PUCK • SIDE TABLE
394 118 2 2
394 119 4 4
394 144 INDEX,FOLLOW INDEX,FOLLOW
395 71 TITANIA • ROUND TABLE TITANIA • ROUND TABLE
395 86 /A/F/AF00001514.jpg /A/F/AF00001514.jpg
395 87 /A/F/AF00001514.jpg /A/F/AF00001514.jpg
395 97 titania-round-table titania-round-table
395 112 TITANIA • ROUND TABLE TITANIA • ROUND TABLE
395 113 TITANIA • ROUND TABLE TITANIA • ROUND TABLE
395 114 TITANIA • ROUND TABLE TITANIA • ROUND TABLE
395 118 2 2
395 119 4 4
395 144 INDEX,FOLLOW INDEX,FOLLOW
396 71 FESTE • CONSOLE FESTE • CONSOLE
396 86 /A/F/AF00001515.jpg /A/F/AF00001515.jpg
396 87 /A/F/AF00001515.jpg /A/F/AF00001515.jpg
396 97 feste-console feste-console
396 112 FESTE • CONSOLE FESTE • CONSOLE
396 113 FESTE • CONSOLE FESTE • CONSOLE
396 114 FESTE • CONSOLE FESTE • CONSOLE
396 118 2 2
396 119 4 4
396 144 INDEX,FOLLOW INDEX,FOLLOW
397 71 LEPORELLO • SET OF 3 SIDE TABLES LEPORELLO • SET OF 3 SIDE TABLES
397 86 /A/M/AM00000855L.jpg /A/M/AM00000855L.jpg
397 87 /A/M/AM00000855L.jpg /A/M/AM00000855L.jpg
397 97 leporello-set-of-3-side-tables leporello-set-of-3-side-tables
397 112 LEPORELLO • SET OF 3 SIDE TABLES LEPORELLO • SET OF 3 SIDE TABLES
397 113 LEPORELLO • SET OF 3 SIDE TABLES LEPORELLO • SET OF 3 SIDE TABLES
397 114 LEPORELLO • SET OF 3 SIDE TABLES LEPORELLO • SET OF 3 SIDE TABLES
397 118 2 2
397 119 4 4
397 144 INDEX,FOLLOW INDEX,FOLLOW
398 71 BARDOLPH • COFFEE TABLE BARDOLPH • COFFEE TABLE
398 86 /E/L/EL-15-F402-1.jpg /E/L/EL-15-F402-1.jpg
398 87 /E/L/EL-15-F402-1.jpg /E/L/EL-15-F402-1.jpg
398 97 bardolph-coffee-table bardolph-coffee-table
398 112 BARDOLPH • COFFEE TABLE BARDOLPH • COFFEE TABLE
398 113 BARDOLPH • COFFEE TABLE BARDOLPH • COFFEE TABLE
398 114 BARDOLPH • COFFEE TABLE BARDOLPH • COFFEE TABLE
398 118 2 2
398 119 4 4
398 144 INDEX,FOLLOW INDEX,FOLLOW
399 71 BARDOLPH • SIDE TABLE BARDOLPH • SIDE TABLE
399 86 /E/L/EL-15-F403-1.jpg /E/L/EL-15-F403-1.jpg
399 87 /E/L/EL-15-F403-1.jpg /E/L/EL-15-F403-1.jpg
399 97 bardolph-side-table bardolph-side-table
399 112 BARDOLPH • SIDE TABLE BARDOLPH • SIDE TABLE
399 113 BARDOLPH • SIDE TABLE BARDOLPH • SIDE TABLE
399 114 BARDOLPH • SIDE TABLE BARDOLPH • SIDE TABLE
399 118 2 2
399 119 4 4
399 144 INDEX,FOLLOW INDEX,FOLLOW
400 71 BARDOLPH • CONSOLE BARDOLPH • CONSOLE
400 86 /E/L/EL-15-F404-1.jpg /E/L/EL-15-F404-1.jpg
400 87 /E/L/EL-15-F404-1.jpg /E/L/EL-15-F404-1.jpg
400 97 bardolph-console bardolph-console
400 112 BARDOLPH • CONSOLE BARDOLPH • CONSOLE
400 113 BARDOLPH • CONSOLE BARDOLPH • CONSOLE
400 114 BARDOLPH • CONSOLE BARDOLPH • CONSOLE
400 118 2 2
400 119 4 4
400 144 INDEX,FOLLOW INDEX,FOLLOW
401 71 OPHELIA • COFFEE TABLE OPHELIA • COFFEE TABLE
401 86 /E/L/EL-14-F362.jpg /E/L/EL-14-F362.jpg
401 87 /E/L/EL-14-F362.jpg /E/L/EL-14-F362.jpg
401 97 ophelia-coffee-table ophelia-coffee-table
401 112 OPHELIA • COFFEE TABLE OPHELIA • COFFEE TABLE
401 113 OPHELIA • COFFEE TABLE OPHELIA • COFFEE TABLE
401 114 OPHELIA • COFFEE TABLE OPHELIA • COFFEE TABLE
401 118 2 2
401 119 4 4
401 144 INDEX,FOLLOW INDEX,FOLLOW
522 71 BERKELEY • TABLE BERKELEY • TABLE
522 86 /A/F/AF00001653.jpg /A/F/AF00001653.jpg
522 87 /A/F/AF00001653.jpg /A/F/AF00001653.jpg
522 97 berkeley-table berkeley-table
522 112 BERKELEY • TABLE BERKELEY • TABLE
522 113 BERKELEY • TABLE BERKELEY • TABLE
522 114 BERKELEY • TABLE BERKELEY • TABLE
522 118 2 2
522 119 4 4
522 144 INDEX,FOLLOW INDEX,FOLLOW
391 73 64x64x68 cm 64x64x68 cm
392 73 152.5x48.3x81.3 cm 152.5x48.3x81.3 cm
393 73 108x50x53 cm 108x50x53 cm
394 73 76.2x76.2x53.4 cm 76.2x76.2x53.4 cm
395 73 106.7x106.7x78.7 cm 106.7x106.7x78.7 cm
396 73 139.7x48.3x88.9 cm 139.7x48.3x88.9 cm
397 73 76x76x51 cm 76x76x51 cm
398 73 122x91x51 cm 122x91x51 cm
399 73 58x58x64 cm 58x58x64 cm
400 73 132x45x90 cm 132x45x90 cm
401 73 125x71x51 cm 125x71x51 cm
522 73 85x85x53 cm 85x85x53 cm
391 75 8500.0000 8500.0000
391 76
391 120
392 75 25000.0000 25000.0000
392 76
392 120
393 75 8500.0000 8500.0000
393 76
393 120
394 75 15000.0000 15000.0000
394 76
394 120
395 75 50000.0000 50000.0000
395 76
395 120
396 75 21500.0000 21500.0000
396 76
396 120
397 75 5500.0000 5500.0000
397 76
397 120
398 75 18500.0000 18500.0000
398 76
398 120
399 75 12000.0000 12000.0000
399 76
399 120
400 75 18500.0000 18500.0000
400 76
400 120
401 75 17500.0000 17500.0000
401 76
401 120
522 75 8500.0000 8500.0000
522 76
522 120
391 77
391 78
391 93
391 94
392 77
392 78
392 93
392 94
393 77
393 78
393 93
393 94
394 77
394 78
394 93
394 94
395 77
395 78
395 93
395 94
396 77
396 78
396 93
396 94
397 77
397 78
397 93
397 94
398 77
398 78
398 93
398 94
399 77
399 78
399 93
399 94
400 77
400 78
400 93
400 94
401 77
401 78
401 93
401 94
522 77
522 78
522 93
522 94
391 96 1 1
391 137 0 0
391 121
392 96 1 1
392 137 0 0
392 121
393 96 1 1
393 137 0 0
393 121
394 96 1 1
394 137 0 0
394 121
395 96 1 1
395 137 0 0
395 121
396 96 1 1
396 137 1 1
396 121
397 96 1 1
397 137 0 0
397 121
398 96 1 1
398 137 0 0
398 121
399 96 1 1
399 137 0 0
399 121
400 96 1 1
400 137 0 0
400 121
401 96 1 1
401 137 0 0
401 121
522 96 1 1
522 137 0 0
522 121