select it.*, itco.*,itop.*,it.id itid from NICECART_ITEM it, NICECART_ITEMCOMMENT itco ,NICECART_ITEM_PLUS_OPTION itop where it.printcheck='Y' and it.id=itco.item_id and it.sub_id_key='A6' and it.grouptype_printranking > '81' and it.id=itop.item_id order by it.grouptype_printranking asc limit 1