select CDM,S_INFO,C_ID,C_SID
from t_shop
where S_VALID='1' and CDM in
(
    SELECT CDM
    FROM t_shop
    WHERE CONTAINS (s_name, p_query, 1) > 0 
)

    SELECT CDM,S_INFO,C_ID
    FROM t_shop
    WHERE CONTAINS (s_name, p_query, 1) > 0 and S_VALID='1'