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 (3, 24, 283, 20, 276, 35, 33, 36, 47, 246, 277, 409, 49, 251, 278, 397, 163, 54, 248, 279, 394, 60, 426, 280, 404, 366, 288, 269, 86, 254, 403, 386, 314, 273, 264, 408, 377, 289, 274, 257, 417, 298, 293, 275, 258, 424, 359, 313, 324, 281, 249, 407, 385, 323, 282, 427, 405, 305, 336, 292, 250, 419, 365, 357, 418, 253, 284, 384, 354, 226, 406, 421, 330, 227, 364, 344, 363, 349, 393, 358, 38, 48, 50, 55, 61, 87, 190, 206, 270, 295, 290, 375, 321, 327, 325, 337, 360, 367, 380, 387, 395, 398, 410, 93, 51, 67, 56, 62, 88, 208, 233, 271, 296, 291, 373, 315, 331, 326, 338, 361, 368, 378, 388, 396, 399, 411, 77, 68, 57, 63, 89, 238, 272, 297, 294, 374, 317, 334, 328, 339, 362, 370, 379, 389, 400, 412, 78, 69, 58, 64, 90, 212, 239, 299, 301, 376, 318, 329, 340, 369, 381, 390, 401, 413, 341, 285, 79, 70, 59, 65, 91, 213, 300, 322, 332, 423, 372, 382, 391, 402, 414, 342, 286, 80, 71, 66, 92, 221, 302, 319, 333, 371, 383, 392, 428, 415, 343, 287, 81, 72, 123, 185, 222, 303, 320, 335, 416, 345, 82, 73, 348, 234, 304, 316, 420, 346, 83, 74, 350, 306, 347, 84, 75, 351, 307, 422, 85, 76, 352, 308, 353, 309, 355, 310, 356, 311, 312)) AND (t_d.attribute_id IN (45)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))