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 (2, 407, 419, 424, 441, 471, 400, 461, 430, 503, 10, 70, 30, 253, 375, 401, 501, 420, 425, 431, 442, 462, 472, 481, 16, 58, 28, 254, 376, 402, 408, 421, 426, 435, 447, 463, 473, 107, 18, 403, 409, 422, 427, 451, 464, 474, 498, 203, 246, 19, 404, 410, 423, 428, 456, 465, 475, 303, 388, 40, 405, 411, 499, 429, 466, 476, 274, 406, 412, 488, 467, 477, 41, 413, 505, 468, 478, 26, 307, 414, 469, 479, 23, 470, 278, 275, 198, 21, 276, 24, 277, 337, 326, 327, 328, 392, 343, 355, 357, 362, 364, 369, 391, 397, 486, 496, 17, 59, 71, 108, 199, 309, 247, 255, 260, 352, 305, 377, 384, 493, 415, 432, 436, 443, 448, 452, 457, 60, 73, 310, 248, 256, 261, 283, 306, 378, 381, 416, 433, 437, 444, 449, 453, 458, 194, 68, 84, 196, 257, 262, 284, 379, 382, 417, 434, 438, 445, 450, 454, 459, 348, 61, 85, 113, 349, 325, 380, 383, 418, 439, 446, 491, 455, 460, 69, 74, 114, 308, 279, 371, 440, 497, 386, 365, 280, 94, 385, 281, 103, 311, 312, 351, 285, 399, 335)) AND (t_d.attribute_id IN ('45', '48', '49', '52', '60', '63', '68', '124', '125')) 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 (2, 407, 419, 424, 441, 471, 400, 461, 430, 503, 10, 70, 30, 253, 375, 401, 501, 420, 425, 431, 442, 462, 472, 481, 16, 58, 28, 254, 376, 402, 408, 421, 426, 435, 447, 463, 473, 107, 18, 403, 409, 422, 427, 451, 464, 474, 498, 203, 246, 19, 404, 410, 423, 428, 456, 465, 475, 303, 388, 40, 405, 411, 499, 429, 466, 476, 274, 406, 412, 488, 467, 477, 41, 413, 505, 468, 478, 26, 307, 414, 469, 479, 23, 470, 278, 275, 198, 21, 276, 24, 277, 337, 326, 327, 328, 392, 343, 355, 357, 362, 364, 369, 391, 397, 486, 496, 17, 59, 71, 108, 199, 309, 247, 255, 260, 352, 305, 377, 384, 493, 415, 432, 436, 443, 448, 452, 457, 60, 73, 310, 248, 256, 261, 283, 306, 378, 381, 416, 433, 437, 444, 449, 453, 458, 194, 68, 84, 196, 257, 262, 284, 379, 382, 417, 434, 438, 445, 450, 454, 459, 348, 61, 85, 113, 349, 325, 380, 383, 418, 439, 446, 491, 455, 460, 69, 74, 114, 308, 279, 371, 440, 497, 386, 365, 280, 94, 385, 281, 103, 311, 312, 351, 285, 399, 335)) AND (t_d.attribute_id IN ('47', '50', '51', '57', '58', '59', '64', '67', '139', '140', '141', '143', '144', '146', '149', '150', '151', '152', '153', '154', '155', '156', '157', '160', '227', '233', '234', '238', '249', '250', '251', '252', '255', '265')) 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 (2, 407, 419, 424, 441, 471, 400, 461, 430, 503, 10, 70, 30, 253, 375, 401, 501, 420, 425, 431, 442, 462, 472, 481, 16, 58, 28, 254, 376, 402, 408, 421, 426, 435, 447, 463, 473, 107, 18, 403, 409, 422, 427, 451, 464, 474, 498, 203, 246, 19, 404, 410, 423, 428, 456, 465, 475, 303, 388, 40, 405, 411, 499, 429, 466, 476, 274, 406, 412, 488, 467, 477, 41, 413, 505, 468, 478, 26, 307, 414, 469, 479, 23, 470, 278, 275, 198, 21, 276, 24, 277, 337, 326, 327, 328, 392, 343, 355, 357, 362, 364, 369, 391, 397, 486, 496, 17, 59, 71, 108, 199, 309, 247, 255, 260, 352, 305, 377, 384, 493, 415, 432, 436, 443, 448, 452, 457, 60, 73, 310, 248, 256, 261, 283, 306, 378, 381, 416, 433, 437, 444, 449, 453, 458, 194, 68, 84, 196, 257, 262, 284, 379, 382, 417, 434, 438, 445, 450, 454, 459, 348, 61, 85, 113, 349, 325, 380, 383, 418, 439, 446, 491, 455, 460, 69, 74, 114, 308, 279, 371, 440, 497, 386, 365, 280, 94, 385, 281, 103, 311, 312, 351, 285, 399, 335)) AND (t_d.attribute_id IN ('53', '54', '70', '71', '142', '145', '148', '161', '162')) 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_datetime` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_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 (e.entity_id IN (2, 407, 419, 424, 441, 471, 400, 461, 430, 503, 10, 70, 30, 253, 375, 401, 501, 420, 425, 431, 442, 462, 472, 481, 16, 58, 28, 254, 376, 402, 408, 421, 426, 435, 447, 463, 473, 107, 18, 403, 409, 422, 427, 451, 464, 474, 498, 203, 246, 19, 404, 410, 423, 428, 456, 465, 475, 303, 388, 40, 405, 411, 499, 429, 466, 476, 274, 406, 412, 488, 467, 477, 41, 413, 505, 468, 478, 26, 307, 414, 469, 479, 23, 470, 278, 275, 198, 21, 276, 24, 277, 337, 326, 327, 328, 392, 343, 355, 357, 362, 364, 369, 391, 397, 486, 496, 17, 59, 71, 108, 199, 309, 247, 255, 260, 352, 305, 377, 384, 493, 415, 432, 436, 443, 448, 452, 457, 60, 73, 310, 248, 256, 261, 283, 306, 378, 381, 416, 433, 437, 444, 449, 453, 458, 194, 68, 84, 196, 257, 262, 284, 379, 382, 417, 434, 438, 445, 450, 454, 459, 348, 61, 85, 113, 349, 325, 380, 383, 418, 439, 446, 491, 455, 460, 69, 74, 114, 308, 279, 371, 440, 497, 386, 365, 280, 94, 385, 281, 103, 311, 312, 351, 285, 399, 335)) AND (t_d.attribute_id IN ('61', '62')) 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_decimal` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_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 (e.entity_id IN (2, 407, 419, 424, 441, 471, 400, 461, 430, 503, 10, 70, 30, 253, 375, 401, 501, 420, 425, 431, 442, 462, 472, 481, 16, 58, 28, 254, 376, 402, 408, 421, 426, 435, 447, 463, 473, 107, 18, 403, 409, 422, 427, 451, 464, 474, 498, 203, 246, 19, 404, 410, 423, 428, 456, 465, 475, 303, 388, 40, 405, 411, 499, 429, 466, 476, 274, 406, 412, 488, 467, 477, 41, 413, 505, 468, 478, 26, 307, 414, 469, 479, 23, 470, 278, 275, 198, 21, 276, 24, 277, 337, 326, 327, 328, 392, 343, 355, 357, 362, 364, 369, 391, 397, 486, 496, 17, 59, 71, 108, 199, 309, 247, 255, 260, 352, 305, 377, 384, 493, 415, 432, 436, 443, 448, 452, 457, 60, 73, 310, 248, 256, 261, 283, 306, 378, 381, 416, 433, 437, 444, 449, 453, 458, 194, 68, 84, 196, 257, 262, 284, 379, 382, 417, 434, 438, 445, 450, 454, 459, 348, 61, 85, 113, 349, 325, 380, 383, 418, 439, 446, 491, 455, 460, 69, 74, 114, 308, 279, 371, 440, 497, 386, 365, 280, 94, 385, 281, 103, 311, 312, 351, 285, 399, 335)) AND (t_d.attribute_id IN ('72')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))