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 (1401, 273, 274, 1333, 1390, 1465, 1424, 155, 1383, 1416, 276, 203, 162, 1384, 1391, 1402, 1478, 1432, 1427, 1443, 1361, 1337, 1385, 1334, 1426, 1428, 320, 421, 266, 1409, 1467, 1452, 157, 261, 164, 1336, 1305, 1406, 1461, 1425, 1368, 1345, 1438, 1442, 1407, 1466, 1441, 326, 1362, 1350, 1347, 1408, 1446, 1475, 1394, 1370, 1440, 1338, 1355, 1403, 1437, 1476, 1330, 1363, 1335, 1419, 1436, 314, 1374, 1346, 1472, 1477, 1388, 1454, 1366, 1411, 1351, 1331, 1420, 1327, 1473, 240, 310, 1451, 1410, 1381, 1462, 1365, 1474, 1405, 1444, 1468, 1332, 1449, 1471, 1392, 1421, 1434, 332, 1413, 1448, 1367, 1450, 424, 1393, 1344, 1439, 165, 1469, 1343, 1329, 308, 1377, 1460, 1433, 1376, 309, 1457, 1435, 272, 430, 1458, 431, 1455, 432, 1459, 433, 1456, 1380, 434, 435, 177, 183)) AND (t_d.attribute_id IN (41)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))<script type="text/javascript">window.location.href = 'https://www.ndc.co.uk/pub/errors/report.php?id=02d84552a6e8e962adec8cd7dd0e3862abea12f0bec29429e34c5e49b6224e64&skin=default';</script>