| eav |
Mage_Catalog_Model_Resource_Category_Collection |
SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `core_url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '119') AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '119') AND (`at_is_active`.`store_id` = 3)
INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '934') AND `at_include_in_menu_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '934') AND (`at_include_in_menu`.`store_id` = 3)
LEFT JOIN `core_url_rewrite` ON (core_url_rewrite.category_id=e.entity_id) AND (core_url_rewrite.is_system=1 AND core_url_rewrite.store_id='3' AND core_url_rewrite.id_path LIKE 'category/%') WHERE (`e`.`entity_type_id` = '9') AND (`e`.`entity_id` IN('1517', '1531', '1523', '1519', '1524', '1527', '1520', '1538', '1526', '1525', '1532', '1530', '1536', '1533', '1539', '1535', '1534', '1537', '1521', '1529', '1528', '1541', '1522', '1518', '1268', '1281', '1284', '1285', '1286', '1287', '1288', '1289', '1282', '1290', '1291', '1292', '1293', '1294', '1295', '1296', '1488', '1502', '1297', '1481', '1501', '1298', '1283', '1300', '1299', '1269', '1301', '1302', '1303', '1304', '1305', '1306', '1307', '1308', '1309', '1310', '1311', '1312', '1313', '1314', '1482', '1316', '1317', '1318', '1319', '1320', '1321', '1270', '1322', '1323', '1324', '1325', '1326', '1327', '1328', '1329', '1330', '1331', '1332', '1333', '1334', '1335', '1336', '1337', '1338', '1339', '1340', '1483', '1271', '1341', '1342', '1343', '1344', '1345', '1346', '1347', '1348', '1349', '1484', '1350', '1351', '1352', '1353', '1272', '1354', '1355', '1439', '1440', '1273', '1358', '1359', '1360', '1435', '1436', '1437', '1438', '1274', '1363', '1364', '1441', '1442', '1443', '1503', '1444', '1445', '1446', '1275', '1370', '1371', '1485', '1372', '1373', '1374', '1375', '1376', '1486', '1276', '1378', '1379', '1380', '1381', '1377', '1383', '1382', '1384', '1386', '1387', '1385', '1277', '1388', '1389', '1390', '1391', '1393', '1392', '1394', '1395', '1396', '1397', '1487', '1398', '1399', '1400', '1401', '1402', '1403', '1404', '1405', '1278', '1406', '1407', '1408', '1409', '1410', '1411', '1412', '1413', '1414', '1415', '1416', '1417', '1418', '1419', '1420', '1421', '1422', '1423', '1424', '1425', '1426', '1279', '1427', '1428', '1429', '1430', '1431', '1432', '1433', '1434', '1447', '1492', '1491', '1497', '1494', '1495', '1496', '1493', '1490', '1489', '1516', '1257', '1449', '1448', '1451', '1450', '1452', '1455', '1479', '1453', '1477', '1454', '1480', '1478', '1256', '1258', '1262', '1240', '1500')) AND (`e`.`entity_id` NOT IN('1262', '1323', '1325', '1329', '1339', '1340', '1345', '1355', '1364', '1377', '1382', '1384', '1384', '1385', '1391', '1398', '1400', '1401', '1404', '1407', '1409', '1410', '1411', '1412', '1414', '1415', '1416', '1418', '1419', '1421', '1422', '1424', '1425', '1426', '1431', '1433', '1434', '1437', '1447', '1483', '1487', '1489', '1490', '1490', '1491', '1491', '1492', '1492', '1493', '1493', '1494', '1494', '1495', '1495', '1496', '1496', '1497', '1497', '1517', '1518', '1518', '1519', '1519', '1519', '1519', '1520', '1520', '1520', '1520', '1521', '1521', '1521', '1522', '1522', '1523', '1523', '1523', '1524', '1524', '1524', '1524', '1525', '1525', '1525', '1525', '1525', '1526', '1526', '1526', '1526', '1526', '1527', '1527', '1527', '1528', '1528', '1528', '1529', '1529', '1530', '1530', '1530', '1531', '1531', '1532', '1532', '1533', '1533', '1533', '1533', '1534', '1534', '1534', '1534', '1534', '1535', '1535', '1535', '1535', '1535', '1536', '1536', '1536', '1537', '1537', '1537', '1537', '1537', '1538', '1538', '1538', '1538', '1539', '1539', '1539', '1539', '1541', '1541')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1') |
discussion en ligne/chat
Envoyer un message
