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 (42, 43, 261, 248, 422, 476, 564, 571, 576, 604, 660, 1130, 1189, 3995, 4081, 4330, 4364, 4419, 4584, 4650, 4774, 4856, 4974, 5266, 5359, 3912, 6184, 3819, 3761, 6142, 6152, 6153, 6261, 3759, 3767, 3818, 4011, 6272, 6134, 6076, 6078, 6143, 6154, 6262, 3760, 3785, 3820, 5703, 6151, 6144, 6155, 6263, 3864, 3786, 4013, 6100, 6120, 6145, 92, 4680, 6132, 6253, 6131, 6252, 6146, 3986, 4474, 6121, 6271, 6254, 6147, 6255, 6198, 6148, 6106, 6104, 6256, 6149, 6158, 6230, 6257, 6113, 6182, 6159, 6118, 6258, 3805, 6183, 6169, 6259, 6187, 6260, 6101, 6188, 3824, 6129, 6190, 6109, 6191, 6192, 6193, 6194, 6156, 6157, 6180, 3770, 3781, 3828, 6273, 5704, 6130, 5773, 6067, 6105, 6110, 6186, 6199, 6231, 6249, 3833, 6173, 4427, 6274, 6127, 6068, 6200, 6232, 6248, 3793, 3821, 4052, 4554, 6119, 6102, 6238, 6103, 6168, 6201, 6233, 6247, 3829, 3825, 4053, 6195, 6089, 6185, 6202, 6234, 6244, 6108, 3826, 6196, 6203, 6235, 6241, 6197, 6204, 6236, 6246, 6205, 6240, 6206, 6242, 6207, 6245, 6179, 6208, 6243, 6209, 6092, 6210, 6211, 6212, 6213, 6214, 6215, 6216, 6217, 6218, 6219, 6220, 6221, 6222, 6223, 6224, 6225, 6226, 6227, 6229, 6090, 3779, 5608, 6091, 5609, 5610, 5611, 6239, 5499)) AND (t_d.attribute_id IN (45)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))