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=954) WHERE (`e`.`entity_id` IN('550', '14179', '15662', '23414', '23415', '23417', '23418', '23419', '23420', '23421', '23422', '23423', '23424', '23426', '23427', '23430', '23431', '23432', '23433', '23434', '23435', '23436', '23437', '23438', '23744', '23746', '23747', '23748', '23749', '24999', '25057', '25073', '25272', '25294', '25320', '25660', '25661', '25802', '25803', '25804', '25806', '25814', '25816', '25819', '25820', '25824', '25827', '25834', '25837', '25842', '25843', '25844', '25845', '25846', '25847', '26370', '26371', '26375', '26376', '26393', '26399', '26401', '26403', '26538', '26539', '26546', '26547', '26605', '27508', '27492', '27493', '27504', '27506', '27507', '27509', '27510', '27511', '27513', '27514', '27516', '27517', '27518', '27520', '27521', '27522', '27523', '27524', '27525', '27526', '27527', '27528', '27529', '27530', '27532', '27534', '27535', '27536', '27537', '27538', '27539', '27540', '27541', '27542', '35934', '36038', '38084', '38085', '38086', '38087', '38089', '38090', '38091', '38092', '38093', '38094', '38095', '38096', '38097', '38098', '38099', '38100', '38101', '38102', '38103', '38104', '38105', '38106', '38107', '38108', '38109', '38110', '38111', '38112', '38113', '38114', '38115', '38116', '38117', '38118', '38119', '38120', '38121', '38122', '38123', '38124', '38125', '38126', '38127', '38128', '38129', '38130', '38131', '38132', '38133', '38134', '38135', '38136', '38137', '38138', '38139', '38140', '38141', '38142', '38143', '38144', '38145', '38146', '38147', '38148', '38149', '38150', '38151', '38152', '38153', '38154', '38155', '38156', '38157', '38158', '38160', '38161', '38162', '38163', '38164', '38165', '38167', '38169', '38170', '38171', '38172', '38174', '38175', '38176', '38177', '38178', '38179', '38180', '38181', '38182', '38183', '45831')) ORDER BY `at_position`.`position` DESC LIMIT 24
