SELECT `t_d`.`attribute_id`, `e`.`entity_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_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_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 (e.entity_id IN (461, 489, 483, 576, 592, 659, 560, 737, 104, 462, 484, 490, 810, 593, 663, 468, 494, 491, 566, 527, 635, 680, 504, 473, 497, 492, 787, 539, 639, 523, 507, 493, 567, 554, 648, 688, 541, 477, 515, 765, 568, 757, 651, 570, 480, 577, 701, 574, 583, 676, 601, 588, 656, 888, 682, 768, 749, 667, 605, 809, 630, 619, 907, 887, 333, 463, 469, 474, 478, 481, 485, 904, 901, 495, 499, 506, 509, 518, 525, 881, 544, 557, 784, 792, 796, 571, 575, 584, 589, 602, 606, 620, 636, 640, 647, 655, 657, 673, 672, 704, 685, 702, 758, 897, 788, 652, 564, 464, 470, 475, 479, 482, 486, 905, 902, 496, 500, 508, 510, 520, 526, 528, 540, 546, 558, 889, 793, 797, 572, 595, 578, 585, 590, 628, 603, 621, 641, 649, 762, 658, 674, 669, 679, 745, 693, 703, 582, 898, 789, 653, 563, 465, 471, 487, 903, 501, 511, 512, 521, 529, 530, 542, 548, 559, 785, 794, 798, 573, 596, 579, 586, 591, 629, 622, 642, 660, 675, 670, 681, 708, 581, 899, 790, 565, 466, 472, 488, 502, 763, 522, 536, 531, 543, 551, 561, 786, 795, 799, 597, 580, 631, 609, 623, 643, 661, 677, 671, 747, 715, 755, 759, 503, 513, 906, 537, 532, 545, 552, 562, 766, 632, 610, 624, 644, 662, 678, 748, 760, 505, 893, 547, 553, 801, 599, 633, 611, 625, 645, 750, 723, 514, 894, 549, 555, 802, 600, 634, 646, 731, 550, 803, 761, 666, 736, 516, 534, 517, 535, 519, 743, 900)) AND (t_d.attribute_id IN (41)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_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_category_entity_int` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_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 (e.entity_id IN (461, 489, 483, 576, 592, 659, 560, 737, 104, 462, 484, 490, 810, 593, 663, 468, 494, 491, 566, 527, 635, 680, 504, 473, 497, 492, 787, 539, 639, 523, 507, 493, 567, 554, 648, 688, 541, 477, 515, 765, 568, 757, 651, 570, 480, 577, 701, 574, 583, 676, 601, 588, 656, 888, 682, 768, 749, 667, 605, 809, 630, 619, 907, 887, 333, 463, 469, 474, 478, 481, 485, 904, 901, 495, 499, 506, 509, 518, 525, 881, 544, 557, 784, 792, 796, 571, 575, 584, 589, 602, 606, 620, 636, 640, 647, 655, 657, 673, 672, 704, 685, 702, 758, 897, 788, 652, 564, 464, 470, 475, 479, 482, 486, 905, 902, 496, 500, 508, 510, 520, 526, 528, 540, 546, 558, 889, 793, 797, 572, 595, 578, 585, 590, 628, 603, 621, 641, 649, 762, 658, 674, 669, 679, 745, 693, 703, 582, 898, 789, 653, 563, 465, 471, 487, 903, 501, 511, 512, 521, 529, 530, 542, 548, 559, 785, 794, 798, 573, 596, 579, 586, 591, 629, 622, 642, 660, 675, 670, 681, 708, 581, 899, 790, 565, 466, 472, 488, 502, 763, 522, 536, 531, 543, 551, 561, 786, 795, 799, 597, 580, 631, 609, 623, 643, 661, 677, 671, 747, 715, 755, 759, 503, 513, 906, 537, 532, 545, 552, 562, 766, 632, 610, 624, 644, 662, 678, 748, 760, 505, 893, 547, 553, 801, 599, 633, 611, 625, 645, 750, 723, 514, 894, 549, 555, 802, 600, 634, 646, 731, 550, 803, 761, 666, 736, 516, 534, 517, 535, 519, 743, 900)) AND (t_d.attribute_id IN (414, 413)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_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_category_entity_text` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_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 (e.entity_id IN (461, 489, 483, 576, 592, 659, 560, 737, 104, 462, 484, 490, 810, 593, 663, 468, 494, 491, 566, 527, 635, 680, 504, 473, 497, 492, 787, 539, 639, 523, 507, 493, 567, 554, 648, 688, 541, 477, 515, 765, 568, 757, 651, 570, 480, 577, 701, 574, 583, 676, 601, 588, 656, 888, 682, 768, 749, 667, 605, 809, 630, 619, 907, 887, 333, 463, 469, 474, 478, 481, 485, 904, 901, 495, 499, 506, 509, 518, 525, 881, 544, 557, 784, 792, 796, 571, 575, 584, 589, 602, 606, 620, 636, 640, 647, 655, 657, 673, 672, 704, 685, 702, 758, 897, 788, 652, 564, 464, 470, 475, 479, 482, 486, 905, 902, 496, 500, 508, 510, 520, 526, 528, 540, 546, 558, 889, 793, 797, 572, 595, 578, 585, 590, 628, 603, 621, 641, 649, 762, 658, 674, 669, 679, 745, 693, 703, 582, 898, 789, 653, 563, 465, 471, 487, 903, 501, 511, 512, 521, 529, 530, 542, 548, 559, 785, 794, 798, 573, 596, 579, 586, 591, 629, 622, 642, 660, 675, 670, 681, 708, 581, 899, 790, 565, 466, 472, 488, 502, 763, 522, 536, 531, 543, 551, 561, 786, 795, 799, 597, 580, 631, 609, 623, 643, 661, 677, 671, 747, 715, 755, 759, 503, 513, 906, 537, 532, 545, 552, 562, 766, 632, 610, 624, 644, 662, 678, 748, 760, 505, 893, 547, 553, 801, 599, 633, 611, 625, 645, 750, 723, 514, 894, 549, 555, 802, 600, 634, 646, 731, 550, 803, 761, 666, 736, 516, 534, 517, 535, 519, 743, 900)) AND (t_d.attribute_id IN (415)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))