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=98) WHERE (`e`.`entity_id` IN('8105', '8108', '8109', '8110', '8111', '8112', '8113', '8114', '8115', '8116', '8117', '8119', '8120', '8121', '8122', '8124', '8125', '8127', '8129', '8132', '8133', '8135', '8137', '8140', '8141', '8143', '8144', '8145', '8147', '8148', '8150', '8151', '8152', '8155', '8156', '8163', '8164', '8165', '8167', '8169', '8170', '8172', '8176', '8177', '8178', '8179', '8180', '8181', '8563', '8564', '8565', '8584', '8588', '8589', '8590', '8591', '8592', '8593', '8596', '8597', '8598', '8599', '8601', '8602', '8603', '8604', '8605', '8606', '8609', '8619', '8620', '8622', '8624', '8625', '8626', '8629', '8631', '8634', '8637', '8640', '8649', '8653', '8658', '8659', '8662', '8674', '8675', '8676', '8685', '8687', '8688', '8712', '8713', '8714', '8721', '8733', '8734', '8735', '8750', '8753', '8755', '8777', '8828', '8889', '8927', '8928', '8929', '8931', '8936', '8959', '8977', '8979', '8986', '9076', '9077', '9078', '9079', '9080', '9081', '9083', '9084', '9085', '9086', '9087', '9088', '9089', '9090', '9091', '9092', '9093', '9094', '9095', '9096', '9097', '9099', '9101', '9102', '9103', '9104', '9105', '9106', '9107', '9108', '9109', '9110', '9111', '9112', '9113', '9114', '9115', '9116', '9117', '9118', '9119', '9120', '9121', '9122', '9123', '9124', '9125', '9126', '9127', '9128', '9129', '9130', '9131', '9132', '9158', '10913', '10937', '10938', '10942', '10949', '10960', '15324', '15346', '15348', '15678', '15681', '15686', '15724', '18767', '18772', '19389', '19390', '19391', '20039', '26806', '26810', '31487', '31490', '31496', '31498', '31502', '31503', '31505', '31506', '31507', '31508', '31520', '31528', '31565', '31585', '31601', '31624', '31625', '31626', '31684', '31822', '31877', '31881', '32169', '32170', '32320', '32323', '32326', '32339', '34261', '35378', '35469', '36165', '43993', '44378', '44825', '45711', '45837', '46060', '46061', '54359', '54388', '54389', '54390', '54391')) ORDER BY `at_position`.`position` DESC LIMIT 24
