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=1255) WHERE (`e`.`entity_id` IN('8990', '15629', '15734', '15747', '22773', '22774', '22775', '22776', '22777', '22778', '22779', '22780', '22781', '22782', '22783', '22784', '22785', '22786', '22787', '22788', '22789', '22791', '22793', '22795', '22796', '22797', '22798', '22799', '22800', '22801', '22803', '22805', '22806', '22808', '22809', '22810', '22811', '22812', '22813', '22814', '22815', '22816', '22817', '22818', '22819', '22820', '22821', '22822', '22823', '22824', '22827', '22828', '22829', '22830', '22831', '22832', '22833', '22835', '22837', '22838', '22840', '22841', '22842', '22843', '22844', '22845', '22846', '22847', '22848', '22850', '22851', '22852', '22853', '22854', '22855', '22856', '22857', '22858', '22859', '22860', '22861', '22862', '22863', '22864', '22865', '22866', '22867', '22868', '22869', '22871', '22872', '22873', '22874', '22875', '22876', '22877', '22879', '22880', '22881', '22882', '22883', '22884', '22885', '22886', '22887', '22889', '22890', '22891', '22892', '22893', '22894', '22895', '22896', '22897', '22898', '22899', '22901', '22902', '22903', '22904', '22906', '22907', '22908', '22909', '22910', '22911', '22913', '22914', '22915', '22916', '22917', '22920', '22921', '22922', '22923', '22924', '22925', '22926', '22927', '22928', '22929', '22930', '22931', '22932', '22933', '22934', '22935', '22936', '22937', '22938', '22939', '22940', '22941', '22942', '22943', '22945', '22946', '22947', '22948', '22949', '22951', '22952', '24286', '24304', '24368', '24376', '24408', '24409', '24423', '24444', '24466', '24503', '24550', '24661', '24798', '24856', '24940', '25018', '25061', '25116', '25129', '25161', '25205', '25262', '25328', '25590', '28299', '39434', '39435', '39436', '39437', '39438', '39439', '39441', '39442', '39443', '39444', '39445', '39446', '39447', '39448', '39449', '39450', '39451', '39452', '39453', '39454', '39455', '39456', '39457', '39458', '39459', '39460', '39461', '39462', '39463', '39464', '39465', '39466', '39467', '39468', '39469', '39470', '39471', '39472', '39473', '39474', '39475', '39476', '39477', '39478', '39479', '39481', '39482', '39483', '39485', '39486', '39487', '39488', '39489', '39490', '39491', '39492', '39493', '39494', '39495', '39496', '39497', '39498', '39499', '39500', '39501', '39502', '39503', '39504', '39505', '39506', '39507', '39508', '39509', '39510', '39511', '39514', '39516', '39517', '39518', '39519', '39520', '39521', '39522', '39523', '39524', '39525', '39526', '39527', '39528', '39529', '39530', '39531', '39532', '39533', '39534', '39535', '39536', '39537', '39538', '39539', '39540', '39541', '39542', '39543', '39544', '39545', '39546', '39547', '39548', '39549', '39550', '39551', '39552', '39553', '39554', '39555', '39556', '39557', '39558', '39559', '39560', '39561', '39562', '39563', '39564', '39566', '39567', '39568', '39569', '39570', '39571', '39572', '39573', '39574', '39575', '39576', '39577')) ORDER BY `at_position`.`position` DESC LIMIT 24
