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=362) WHERE (`e`.`entity_id` IN('15304', '15739', '22415', '22504', '24059', '24211', '24472', '24668', '24729', '24766', '24821', '24917', '25059', '25208', '25209', '36064', '36175', '37115', '37116', '37117', '37118', '37119', '37120', '37121', '37122', '37123', '37124', '37125', '37126', '37127', '37128', '37130', '37131', '37132', '37133', '37134', '37135', '37136', '37137', '37138', '37139', '37140', '37141', '37142', '37143', '37144', '37145', '37146', '37147', '37148', '37149', '37150', '37151', '37152', '37153', '37154', '37155', '37156', '37158', '37159', '37160', '37161', '37162', '37163', '37165', '37166', '37167', '37168', '37171', '37172', '37173', '37176', '37177', '37178', '37179', '37180', '37181', '37182', '37183', '37184', '37185', '37186', '37187', '37188', '37189', '37190', '37191', '37192', '37193', '37194', '37195', '37196', '37197', '37198', '37199', '37200', '37201', '37202', '37203', '37204', '37205', '37206', '37208', '37209', '37210', '37211', '37212', '37213', '37214', '37215', '37216', '37217', '37219', '37220', '37221', '37222', '37223', '37224', '37225', '37226', '37227', '37228', '37229', '37230', '37231', '37232', '37233', '37234', '37235', '37236', '37237', '37238', '37239', '37241', '37242', '37243', '37244', '37245', '37246', '37247', '37248', '37249', '37250', '37251', '37252', '37253', '37254', '37255', '37256', '37257', '37258')) ORDER BY `at_position`.`position` DESC LIMIT 24
