SELECT oxa.OXARTNUM FROM oxarticles oxa INNER JOIN s_articles_details sad ON(sad.ordenrumber=oxa.OXARTNUM AND sad.kind=1) WHERE oxa.OXPARENTID = ?STOP