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=181) WHERE (`e`.`entity_id` IN('4746', '4749', '4750', '4754', '4755', '4760', '4761', '4762', '4763', '10806', '10807', '10809', '10810', '10811', '10812', '10813', '10815', '10832', '10836', '10851', '10853', '10864', '10874', '14536', '14569', '14714', '15117', '15165', '15168', '15182', '15333', '15464', '15483', '15493', '15650', '15697', '15740', '18829', '19347', '20593', '20596', '20597', '20598', '20600', '20601', '20602', '20606', '20611', '20613', '20614', '20616', '20617', '20618', '20619', '20620', '20621', '20622', '20623', '20624', '20625', '20626', '20629', '20632', '20636', '20637', '24035', '24756', '24925', '24927', '24949', '25094', '25138', '25229', '25235', '25248', '25563', '25572', '25585', '25601', '25638', '25673', '26003', '26007', '26010', '26016', '26017', '26154', '26164', '26167', '26623', '26624', '30180', '29302', '29303', '29304', '29305', '29311', '29313', '29316', '29317', '29319', '31088', '31050', '31369', '31497', '31576', '31756', '31826', '31841', '31843', '31849', '31855', '31856', '31899', '31904', '31907', '31910', '31914', '31923', '31924', '31925', '31926', '31930', '31947', '31973', '31977', '31978', '31995', '32014', '32017', '32019', '32023', '32024', '32025', '32027', '32029', '32030', '32039', '32073', '32078', '32090', '32122', '32123', '32129', '32132', '32134', '32135', '32138', '32163', '32164', '32166', '32324', '32483', '32959', '32982', '31190', '31152', '31315', '31211', '31316', '31368', '31139', '31104', '31261', '31213', '31214', '31090', '31216', '31091', '31141', '31065', '31262', '31066', '31375', '31127', '31263', '31142', '31072', '31026', '31264', '31321', '31218', '31106', '31219', '31107', '31155', '31156', '31277', '31160', '31407', '31410', '31411', '31412', '31119', '31147', '31289', '31307', '31206', '31257', '31207', '31023', '31209', '34489', '35058', '35077', '35078', '35080', '35211', '35452', '35453', '35454', '35838', '35839', '36172', '36192', '37010', '37011', '37012', '37013', '37014', '37015', '37016', '37017', '37018', '37019', '37020', '37021', '37022', '37023', '37024', '37025', '37027', '37028', '37029', '37030', '37031', '37032', '37033', '37034', '37035', '37037', '37038', '37039', '37040', '37041', '37042', '37043', '37044', '37045', '37047', '37048', '37049', '37050', '37051', '37052', '37053', '37054', '37055', '37056', '37057', '37058', '37059', '37061', '37062', '37063', '37064', '37065', '37066', '37067', '37068', '37070', '37071', '37072', '37073', '37074', '37075', '37076', '37077', '37078', '37079', '37080', '37081', '37082', '37083', '37084', '37085', '37086', '37087', '37088', '37089', '37090', '37091', '37092', '37093', '37094', '37095', '37096', '37097', '37098', '37099', '37100', '41733', '41734', '41735', '41736', '41737', '41738', '41739', '41740', '41741', '41742', '41743', '41744', '41745', '41746', '41747', '41748', '41749', '41750', '41751', '41752', '41753', '41754', '41755', '41756', '41757', '41758', '41759', '41760', '41761', '41762', '41763', '41764', '41765', '41766', '41767', '41768', '41769', '41770', '41771', '43935', '43936', '43937', '43938', '43939', '43940', '44728', '44735', '44806')) ORDER BY `at_position`.`position` DESC LIMIT 24
