SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `at_position`.`position` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '2' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2'
LEFT JOIN `aw_shopbybrand_brand_product` AS `at_position` ON (at_position.`product_id`=e.entity_id) AND (brand_id=66) WHERE (`e`.`entity_id` IN('1266', '1267', '1268', '1269', '1270', '1272', '1274', '1275', '1277', '1293', '1294', '1295', '1296', '1297', '1298', '1325', '1327', '1328', '1329', '1330', '1331', '1333', '1334', '1335', '1336', '1351', '1360', '1361', '1362', '1363', '1365', '1368', '1369', '1370', '1383', '1384', '1385', '1402', '1403', '1404', '1405', '1406', '1407', '1408', '1409', '1410', '1411', '1413', '1415', '1416', '1418', '1419', '1446', '1448', '1449', '1450', '1483', '1484', '1485', '1486', '1487', '1488', '1489', '1490', '1491', '1492', '1493', '1494', '1495', '1498', '1499', '1500', '1501', '1502', '1504', '1505', '1506', '1507', '1508', '1509', '1511', '1512', '1513', '1514', '1515', '1516', '1517', '1518', '1519', '1520', '1521', '1522', '1523', '1524', '4979', '10646', '10654', '10658', '10660', '11538', '11540', '11543', '11544', '11545', '11547', '11548', '11549', '11550', '11551', '11552', '11556', '11564', '11568', '11569', '11570', '11571', '11573', '11575', '11577', '11579', '11582', '11584', '11586', '11589', '11592', '11593', '11597', '11599', '11600', '11601', '11602', '18831', '18834', '19718', '26729', '27490', '31678', '31734', '31834', '31857', '31894', '31903', '31913', '32095', '32096', '32128', '32159', '32160', '32266', '32267', '32269', '32270', '32271', '32299', '32314', '34071', '35623', '38054', '38055', '38058', '38059', '38060', '38064', '38065', '38067', '38070', '38074', '38075', '38076', '38079', '38081', '38083', '44689', '44758')) ORDER BY `at_position`.`position` DESC LIMIT 24
