Query is not executing properly when I use GROUP_CONCAT with in keyward
<p>I am try to run sub query with NOT IN keyword</p>

<pre><code>SELECT DISTINCT(user_id) FROM user_group_master WHERE user_id IN (SELECT GROUP_CONCAT("'",userid,"'") FROM location_sharing_setting WHERE owner_id = '123456' AND sharing_status = 0)
</code></pre>

<p>Query is running properly when we didn't use sub query</p>

<pre><code>SELECT DISTINCT(user_id) FROM user_group_master WHERE user_id NOT IN ('56556','540003')
</code></pre>

<p>Please Help me with best solution ...</p>