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 = 3 WHERE (e.entity_id IN (4, 3, 33, 130, 158, 188, 213, 321, 348, 383, 431, 441, 463, 214, 737, 530, 34, 131, 159, 189, 221, 303, 322, 349, 384, 432, 442, 464, 738, 5, 35, 132, 162, 190, 222, 327, 353, 387, 435, 445, 465, 739, 6, 38, 133, 166, 191, 223, 330, 356, 391, 438, 448, 466, 740, 9, 37, 134, 170, 192, 224, 335, 360, 394, 451, 367, 741, 10, 42, 135, 177, 193, 294, 341, 423, 742, 11, 40, 472, 180, 194, 225, 345, 397, 743, 12, 41, 474, 183, 195, 481, 744, 13, 108, 136, 731, 364, 501, 484, 745, 473, 502, 487, 746, 196, 503, 489, 747, 504, 748, 505, 749, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 722, 726, 7, 15, 23, 43, 61, 88, 81, 109, 123, 126, 137, 141, 144, 147, 153, 155, 160, 163, 167, 174, 178, 181, 184, 197, 203, 208, 215, 259, 263, 266, 269, 277, 280, 283, 286, 288, 295, 304, 323, 328, 331, 336, 342, 346, 350, 354, 357, 361, 365, 368, 385, 389, 392, 395, 454, 424, 434, 437, 439, 443, 446, 449, 452, 467, 475, 477, 479, 482, 485, 488, 490, 531, 732, 8, 16, 24, 44, 62, 93, 82, 114, 124, 127, 138, 142, 145, 150, 154, 156, 161, 164, 168, 175, 179, 182, 186, 200, 204, 209, 226, 260, 264, 273, 278, 281, 284, 287, 296, 305, 324, 329, 334, 340, 343, 347, 351, 355, 358, 362, 366, 369, 386, 388, 393, 396, 398, 425, 433, 436, 440, 444, 447, 450, 453, 468, 476, 478, 483, 486, 491, 532, 733, 14, 17, 25, 55, 63, 101, 118, 125, 128, 139, 143, 146, 157, 165, 169, 686, 709, 187, 207, 212, 229, 261, 265, 274, 279, 282, 285, 290, 297, 306, 325, 344, 352, 359, 370, 390, 399, 688, 469, 734, 26, 18, 682, 129, 140, 232, 262, 275, 293, 496, 292, 307, 326, 693, 371, 689, 470, 27, 683, 236, 499, 276, 298, 312, 716, 412, 28, 684, 240, 299, 315, 717, 372, 29, 694, 245, 300, 718, 30, 249, 301, 719, 60, 252, 720, 31, 256, 721, 728, 32, 19, 45, 47, 50, 64, 67, 77, 83, 85, 99, 94, 102, 110, 115, 119, 148, 151, 173, 198, 201, 205, 210, 216, 227, 230, 233, 237, 241, 246, 250, 253, 257, 267, 270, 308, 313, 316, 332, 337, 373, 375, 377, 379, 381, 492, 426, 428, 455, 176, 20, 46, 48, 56, 65, 68, 78, 84, 86, 91, 95, 103, 111, 116, 120, 149, 152, 171, 199, 202, 206, 211, 217, 228, 231, 234, 238, 242, 247, 251, 254, 258, 268, 271, 309, 314, 317, 333, 338, 374, 376, 378, 380, 382, 413, 427, 429, 456, 687, 711, 21, 49, 57, 66, 69, 79, 87, 90, 96, 104, 112, 117, 121, 497, 218, 235, 239, 243, 248, 255, 272, 310, 318, 339, 417, 430, 457, 701, 712, 22, 51, 58, 70, 80, 89, 97, 113, 122, 219, 244, 311, 420, 458, 702, 713, 52, 59, 71, 92, 98, 220, 703, 53, 72, 100, 706, 54, 73, 106, 74, 75, 76, 685, 319, 414, 418, 421, 459, 461, 493, 320, 415, 419, 422, 460, 462, 494, 416, 495)) AND (t_d.attribute_id IN (45, 48, 140)) 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 = 3 WHERE (e.entity_id IN (4, 3, 33, 130, 158, 188, 213, 321, 348, 383, 431, 441, 463, 214, 737, 530, 34, 131, 159, 189, 221, 303, 322, 349, 384, 432, 442, 464, 738, 5, 35, 132, 162, 190, 222, 327, 353, 387, 435, 445, 465, 739, 6, 38, 133, 166, 191, 223, 330, 356, 391, 438, 448, 466, 740, 9, 37, 134, 170, 192, 224, 335, 360, 394, 451, 367, 741, 10, 42, 135, 177, 193, 294, 341, 423, 742, 11, 40, 472, 180, 194, 225, 345, 397, 743, 12, 41, 474, 183, 195, 481, 744, 13, 108, 136, 731, 364, 501, 484, 745, 473, 502, 487, 746, 196, 503, 489, 747, 504, 748, 505, 749, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 722, 726, 7, 15, 23, 43, 61, 88, 81, 109, 123, 126, 137, 141, 144, 147, 153, 155, 160, 163, 167, 174, 178, 181, 184, 197, 203, 208, 215, 259, 263, 266, 269, 277, 280, 283, 286, 288, 295, 304, 323, 328, 331, 336, 342, 346, 350, 354, 357, 361, 365, 368, 385, 389, 392, 395, 454, 424, 434, 437, 439, 443, 446, 449, 452, 467, 475, 477, 479, 482, 485, 488, 490, 531, 732, 8, 16, 24, 44, 62, 93, 82, 114, 124, 127, 138, 142, 145, 150, 154, 156, 161, 164, 168, 175, 179, 182, 186, 200, 204, 209, 226, 260, 264, 273, 278, 281, 284, 287, 296, 305, 324, 329, 334, 340, 343, 347, 351, 355, 358, 362, 366, 369, 386, 388, 393, 396, 398, 425, 433, 436, 440, 444, 447, 450, 453, 468, 476, 478, 483, 486, 491, 532, 733, 14, 17, 25, 55, 63, 101, 118, 125, 128, 139, 143, 146, 157, 165, 169, 686, 709, 187, 207, 212, 229, 261, 265, 274, 279, 282, 285, 290, 297, 306, 325, 344, 352, 359, 370, 390, 399, 688, 469, 734, 26, 18, 682, 129, 140, 232, 262, 275, 293, 496, 292, 307, 326, 693, 371, 689, 470, 27, 683, 236, 499, 276, 298, 312, 716, 412, 28, 684, 240, 299, 315, 717, 372, 29, 694, 245, 300, 718, 30, 249, 301, 719, 60, 252, 720, 31, 256, 721, 728, 32, 19, 45, 47, 50, 64, 67, 77, 83, 85, 99, 94, 102, 110, 115, 119, 148, 151, 173, 198, 201, 205, 210, 216, 227, 230, 233, 237, 241, 246, 250, 253, 257, 267, 270, 308, 313, 316, 332, 337, 373, 375, 377, 379, 381, 492, 426, 428, 455, 176, 20, 46, 48, 56, 65, 68, 78, 84, 86, 91, 95, 103, 111, 116, 120, 149, 152, 171, 199, 202, 206, 211, 217, 228, 231, 234, 238, 242, 247, 251, 254, 258, 268, 271, 309, 314, 317, 333, 338, 374, 376, 378, 380, 382, 413, 427, 429, 456, 687, 711, 21, 49, 57, 66, 69, 79, 87, 90, 96, 104, 112, 117, 121, 497, 218, 235, 239, 243, 248, 255, 272, 310, 318, 339, 417, 430, 457, 701, 712, 22, 51, 58, 70, 80, 89, 97, 113, 122, 219, 244, 311, 420, 458, 702, 713, 52, 59, 71, 92, 98, 220, 703, 53, 72, 100, 706, 54, 73, 106, 74, 75, 76, 685, 319, 414, 418, 421, 459, 461, 493, 320, 415, 419, 422, 460, 462, 494, 416, 495)) AND (t_d.attribute_id IN (46)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))