SELECT `RANK`.`RANK`, `ITEM`.*, `DETAIL`.`AFFILIATE_URL` FROM (`INFOCART_ITEM_MAIN` `ITEM` LEFT JOIN `INFOCART_ITEM_DETAIL` `DETAIL` ON `ITEM`.`ITEM_ID` = `DETAIL`.`ITEM_ID`) LEFT JOIN `INFOCART_RANK` `RANK` ON `ITEM`.`ITEM_ID` = `RANK`.`ITEM_ID` WHERE `RANK`.`ITEM_ID` IN () AND `RANK`.`DATE` = '2008-08-20' ORDER BY `RANK`.`RANK` ASC