select *,(select shop.clm25 from shop where shop.clm0 = kyujin.clm1) from kyujin where clm30 = 1 and clm1 in (155,156,157,158,159,160,161,162,163,165,166,168,170,171,172,173,174,175,176,178,179,180,182,184,187,188,189,192,193,194,195,199,200,201,202,203,205,206,207,208,209,210,211,212,213,214,215,222,225,226,227,228,229,232) order by clm0 desc