select item_locale.categoryid from itemshop.item_locale inner join itemshop.item_price on item_locale.itemid = item_price.itemid and item_price.days=30 and item_price.locale=item_locale.locale where item_locale.status in (3) and item_locale.locale='my' and item_locale.itemid=200005683