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='A4' and it.grouptype_printranking < '1' and it.id=itop.item_id order by it.grouptype_printranking desc limit 1