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=217) WHERE (`e`.`entity_id` IN('1141', '1145', '4459', '4461', '4462', '4486', '4487', '4488', '4540', '4634', '4658', '4725', '4726', '4745', '8307', '8308', '8371', '8372', '8399', '8400', '8450', '8451', '8452', '8478', '8485', '8489', '8632', '8638', '8655', '8660', '8728', '8732', '8756', '8774', '8895', '8901', '9008', '10477', '10492', '10605', '16828', '16829', '16830', '16856', '16861', '16863', '16864', '16865', '16869', '16870', '16872', '16890', '16963', '16965', '16968', '18245', '18763', '18764', '21490', '21491', '21492', '21493', '21494', '21495', '21496', '21497', '21498', '21499', '21500', '21503', '21505', '21506', '21508', '21509', '21510', '21511', '21512', '21513', '21514', '21515', '21516', '21517', '21518', '21519', '21520', '21521', '21522', '21523', '21524', '21525', '21526', '21527', '21528', '21529', '21530', '21531', '21532', '21533', '21534', '21535', '21536', '21537', '21538', '21539', '21540', '21541', '21542', '21543', '21544', '21545', '21546', '21547', '21548', '21549', '21550', '21551', '21552', '21553', '21556', '21557', '21558', '21559', '21560', '21562', '21563', '21564', '21565', '21567', '21568', '21569', '21570', '21571', '21572', '21573', '21574', '21575', '21576', '21577', '21578', '21580', '21581', '21583', '21584', '21585', '21586', '21587', '21588', '21589', '21590', '21591', '21592', '21593', '21594', '21595', '21596', '21597', '21600', '21601', '21603', '21604', '21605', '21607', '21608', '21609', '21610', '21611', '21612', '21613', '21616', '21617', '21618', '21619', '21620', '21621', '21622', '21623', '21624', '21626', '21628', '21629', '21630', '21631', '21632', '21634', '21635', '21636', '21637', '21639', '21642', '21643', '21644', '21645', '21646', '21647', '23825', '24023', '24033', '24058', '24070', '24072', '24078', '24093', '24101', '24116', '24120', '24124', '24132', '24136', '24148', '24161', '24163', '24164', '24170', '24171', '24194', '24196', '24200', '24210', '24227', '24228', '24236', '24238', '24240', '24260', '24268', '24279', '24280', '24317', '24327', '24328', '24337', '24353', '24357', '24365', '24373', '24374', '24377', '24430', '24431', '24435', '24440', '24452', '24486', '24505', '24513', '24517', '24529', '24541', '24568', '24570', '24571', '24572', '24573', '24574', '24577', '24579', '24582', '24610', '24618', '24625', '24632', '24634', '24642', '24663', '24692', '24704', '24713', '24716', '24723', '24730', '24736', '24739', '24771', '24777', '24823', '24908', '24930', '24943', '24963', '25006', '25008', '25025', '25031', '25041', '25054', '25067', '25079', '25135', '25173', '25185', '25264', '25307', '25308', '25310', '25316', '25323', '25327', '25332', '25565', '25568', '25597', '25629', '25630', '25631', '25632', '25645', '26021', '26025', '26027', '26031', '26032', '26033', '26035', '26036', '26038', '26039', '26040', '26043', '26047', '26051', '26052', '26055', '26061', '26067', '26068', '26069', '26071', '26074', '26145', '26162', '26170', '26247', '26339', '26390', '26391', '26397', '26400', '26408', '29682', '29665', '29681', '29678', '29677', '29676', '29672', '30882', '30884', '30885', '30886', '30889', '30890', '30892', '30893', '30895', '30896', '30897', '30899', '30902', '30904', '30905', '30906', '30907', '30908', '30909', '30910', '30911', '30912', '30913', '30915', '30920', '30922', '30923', '30924', '30925', '30927', '30928', '30929', '30932', '30935', '30936', '30937', '30938', '30939', '30940', '30942', '30943', '30946', '30948', '30949', '30950', '30953', '29664', '29666', '29667', '29673', '29679', '29683', '30875', '31573', '31592', '31600', '31675', '31682', '31699', '31760', '32061', '32331', '35596', '35873', '35874', '35875', '35876', '35877', '35878', '35880', '35881', '35961', '36195', '42193', '42194', '42196', '42197', '42199', '42200', '42201', '42202', '42205', '42207', '42208', '42209', '42210', '42213', '42215', '42218', '42220', '42224', '42225', '42228', '42231', '42234', '42237', '42238', '42242', '42243', '42246', '42247', '42248', '42251', '42253', '42254', '42255', '42256', '42257', '42258', '42259', '42260', '42261', '42263', '42264', '42265', '42266', '42267', '42269', '42270', '42275', '42276', '42277', '42279', '42280', '42281', '42283', '42284', '42285', '42286', '42287', '42288', '42289', '42290', '42292', '42293', '42294', '42296', '42297', '42298', '42299', '42300', '42301', '42302', '42303', '42304', '42305', '42306', '42308', '42309', '42310', '42311', '42313', '42314', '42317', '45833')) ORDER BY `at_position`.`position` DESC LIMIT 24
