"Back"

SQL Select

{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}
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 (242, 302, 335, 336, 339, 365, 366, 367, 368, 369, 371, 372)) 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 (242, 302, 335, 336, 339, 365, 366, 367, 368, 369, 371, 372)) 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 (242, 302, 335, 336, 339, 365, 366, 367, 368, 369, 371, 372)) 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 (242, 302, 335, 336, 339, 365, 366, 367, 368, 369, 371, 372)) 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 (242, 302, 335, 336, 339, 365, 366, 367, 368, 369, 371, 372)) 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
242 71 CROSBY • SOFA CROSBY • SOFA
242 86 /F/9/F90120002_1.jpg /F/9/F90120002_1.jpg
242 87 /F/9/F90120002_1.jpg /F/9/F90120002_1.jpg
242 97 crosby-sofa crosby-sofa
242 112 CROSBY • SOFA CROSBY • SOFA
242 113 CROSBY • SOFA CROSBY • SOFA
242 114 CROSBY • SOFA CROSBY • SOFA
242 118 2 2
242 119 4 4
242 144 INDEX,FOLLOW INDEX,FOLLOW
302 71 WU • MARBLE TABLE FOR CLOISONNE TILES WU • MARBLE TABLE FOR CLOISONNE TILES
302 86 /A/M/AM00001202_1.jpg /A/M/AM00001202_1.jpg
302 87 /A/M/AM00001202_1.jpg /A/M/AM00001202_1.jpg
302 97 wu-marble-table-for-cloisonne-tiles wu-marble-table-for-cloisonne-tiles
302 112 WU • MARBLE TABLE FOR CLOISONNE TILES WU • MARBLE TABLE FOR CLOISONNE TILES
302 113 WU • MARBLE TABLE FOR CLOISONNE TILES WU • MARBLE TABLE FOR CLOISONNE TILES
302 114 WU • MARBLE TABLE FOR CLOISONNE TILES WU • MARBLE TABLE FOR CLOISONNE TILES
302 118 2 2
302 119 4 4
302 144 INDEX,FOLLOW INDEX,FOLLOW
335 71 Love Seat Love Seat
335 86 /A/F/AF00001640_1.jpg /A/F/AF00001640_1.jpg
335 87 /A/F/AF00001640_1.jpg /A/F/AF00001640_1.jpg
335 97 love-seat love-seat
335 112 Love Seat Love Seat
335 113 Love Seat Love Seat
335 114 Love Seat Love Seat
335 118 2 2
335 119 4 4
335 144 INDEX,FOLLOW INDEX,FOLLOW
336 71 2 seat sofa 2 seat sofa
336 86 /A/F/AF00001643_1.jpg /A/F/AF00001643_1.jpg
336 87 /A/F/AF00001643_1.jpg /A/F/AF00001643_1.jpg
336 97 2-seat-sofa 2-seat-sofa
336 112 2 seat sofa 2 seat sofa
336 113 2 seat sofa 2 seat sofa
336 114 2 seat sofa 2 seat sofa
336 118 2 2
336 119 4 4
336 144 INDEX,FOLLOW INDEX,FOLLOW
339 71 Slipper sofa Slipper sofa
339 86 /A/F/AF00001650_1.jpg /A/F/AF00001650_1.jpg
339 87 /A/F/AF00001650_1.jpg /A/F/AF00001650_1.jpg
339 97 slipper-sofa slipper-sofa
339 112 Slipper sofa Slipper sofa
339 113 Slipper sofa Slipper sofa
339 114 Slipper sofa Slipper sofa
339 118 2 2
339 119 4 4
339 144 INDEX,FOLLOW INDEX,FOLLOW
365 71 DELANCEY • SOFA DELANCEY • SOFA
365 86 /A/F/AF00001497.jpg /A/F/AF00001497.jpg
365 87 /A/F/AF00001497.jpg /A/F/AF00001497.jpg
365 97 delancey-sofa delancey-sofa
365 112 DELANCEY • SOFA DELANCEY • SOFA
365 113 DELANCEY • SOFA DELANCEY • SOFA
365 114 DELANCEY • SOFA DELANCEY • SOFA
365 118 2 2
365 119 4 4
365 144 INDEX,FOLLOW INDEX,FOLLOW
366 71 DUDDELLS • SOFA DUDDELLS • SOFA
366 86 /N/S/NSSF-5158-60.jpg /N/S/NSSF-5158-60.jpg
366 87 /N/S/NSSF-5158-60.jpg /N/S/NSSF-5158-60.jpg
366 97 duddells-sofa duddells-sofa
366 112 DUDDELLS • SOFA DUDDELLS • SOFA
366 113 DUDDELLS • SOFA DUDDELLS • SOFA
366 114 DUDDELLS • SOFA DUDDELLS • SOFA
366 118 2 2
366 119 4 4
366 144 INDEX,FOLLOW INDEX,FOLLOW
367 71 BELGRAVIA • SOFA BELGRAVIA • SOFA
367 86 /N/S/NSSF-5139-60.jpg /N/S/NSSF-5139-60.jpg
367 87 /N/S/NSSF-5139-60.jpg /N/S/NSSF-5139-60.jpg
367 97 belgravia-sofa belgravia-sofa
367 112 BELGRAVIA • SOFA BELGRAVIA • SOFA
367 113 BELGRAVIA • SOFA BELGRAVIA • SOFA
367 114 BELGRAVIA • SOFA BELGRAVIA • SOFA
367 118 2 2
367 119 4 4
367 144 INDEX,FOLLOW INDEX,FOLLOW
368 71 MOLTON • SOFA MOLTON • SOFA
368 86 /N/S/NSSF-5137-60.jpg /N/S/NSSF-5137-60.jpg
368 87 /N/S/NSSF-5137-60.jpg /N/S/NSSF-5137-60.jpg
368 97 molton-sofa molton-sofa
368 112 MOLTON • SOFA MOLTON • SOFA
368 113 MOLTON • SOFA MOLTON • SOFA
368 114 MOLTON • SOFA MOLTON • SOFA
368 118 2 2
368 119 4 4
368 144 INDEX,FOLLOW INDEX,FOLLOW
369 71 ESCAMILLO • SIDE TABLE ESCAMILLO • SIDE TABLE
369 86 /D/7/D72130010.jpg /D/7/D72130010.jpg
369 87 /D/7/D72130010.jpg /D/7/D72130010.jpg
369 97 escamillo-side-table escamillo-side-table
369 112 ESCAMILLO • SIDE TABLE ESCAMILLO • SIDE TABLE
369 113 ESCAMILLO • SIDE TABLE ESCAMILLO • SIDE TABLE
369 114 ESCAMILLO • SIDE TABLE ESCAMILLO • SIDE TABLE
369 118 2 2
369 119 4 4
369 144 INDEX,FOLLOW INDEX,FOLLOW
371 71 ROSALIND • SIDE TABLE ROSALIND • SIDE TABLE
371 86 /E/L/EL-14-F375.jpg /E/L/EL-14-F375.jpg
371 87 /E/L/EL-14-F375.jpg /E/L/EL-14-F375.jpg
371 97 rosalind-side-table rosalind-side-table
371 112 ROSALIND • SIDE TABLE ROSALIND • SIDE TABLE
371 113 ROSALIND • SIDE TABLE ROSALIND • SIDE TABLE
371 114 ROSALIND • SIDE TABLE ROSALIND • SIDE TABLE
371 118 2 2
371 119 4 4
371 144 INDEX,FOLLOW INDEX,FOLLOW
372 71 ARIEL • SIDE TABLE ARIEL • SIDE TABLE
372 86 /E/L/EL-14-F373.jpg /E/L/EL-14-F373.jpg
372 87 /E/L/EL-14-F373.jpg /E/L/EL-14-F373.jpg
372 97 ariel-side-table ariel-side-table
372 112 ARIEL • SIDE TABLE ARIEL • SIDE TABLE
372 113 ARIEL • SIDE TABLE ARIEL • SIDE TABLE
372 114 ARIEL • SIDE TABLE ARIEL • SIDE TABLE
372 118 2 2
372 119 4 4
372 144 INDEX,FOLLOW INDEX,FOLLOW
242 73 220X120X83 cm 220X120X83 cm
302 73 37X37X37 cm 37X37X37 cm
335 73 185X65X48 cm 185X65X48 cm
336 73 155X75X86 cm 155X75X86 cm
339 73 116X85X240 cm 116X85X240 cm
365 73 157.5x67.3x89 cm 157.5x67.3x89 cm
366 73 208x86x73 cm 208x86x73 cm
367 73 240x95x75 cm 240x95x75 cm
368 73 240x97x76 cm 240x97x76 cm
369 73 41x41x68 cm 41x41x68 cm
371 73 66x66x69 cm 66x66x69 cm
372 73 62x62x67 cm 62x62x67 cm
242 75 25000.0000 25000.0000
242 76
242 120
302 75 15000.0000 15000.0000
302 76
302 120
335 75 35000.0000 35000.0000
335 76
335 120
336 75 22000.0000 22000.0000
336 76
336 120
339 75 12000.0000 12000.0000
339 76
339 120
365 75 22500.0000 22500.0000
365 76
365 120
366 75 70000.0000 70000.0000
366 76
366 120
367 75 85000.0000 85000.0000
367 76
367 120
368 75 85000.0000 85000.0000
368 76
368 120
369 75 2500.0000 2500.0000
369 76
369 120
371 75 9500.0000 9500.0000
371 76
371 120
372 75 9500.0000 9500.0000
372 76
372 120
242 77
242 78
242 93
242 94
302 77
302 78
302 93
302 94
335 77
335 78
335 93
335 94
336 77
336 78
336 93
336 94
339 77
339 78
339 93
339 94
365 77
365 78
365 93
365 94
366 77
366 78
366 93
366 94
367 77
367 78
367 93
367 94
368 77
368 78
368 93
368 94
369 77
369 78
369 93
369 94
371 77
371 78
371 93
371 94
372 77
372 78
372 93
372 94
242 96 1 1
242 137 0 0
242 121
302 96 1 1
302 137 0 0
302 121
335 96 1 1
335 137 0 0
335 121
336 96 1 1
336 137 0 0
336 121
339 96 1 1
339 137 0 0
339 121
365 96 1 1
365 137 0 0
365 121
366 96 1 1
366 137 0 0
366 121
367 96 1 1
367 137 0 0
367 121
368 96 1 1
368 137 0 0
368 121
369 96 1 1
369 137 0 0
369 121
371 96 1 1
371 137 0 0
371 121
372 96 1 1
372 137 0 0
372 121