Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT
- li.auto_id
- FROM
- links AS li
- JOIN group_data AS gi ON
- li.auto_id = gi.autoid AND li.user_id = gi.userid
- WHERE
- gi.groupid IN
- (
- SELECT
- CAST( GROUP_CONCAT( gf.groupid ) AS CHAR )
- FROM
- group_followers AS gf
- WHERE
- gf.userid_ext = '1'
- GROUP BY
- gf.userid_ext
- )
- AND li.keyword LIKE '%shiba%'
- gi.groupid IN
- (
- SELECT
- gf.groupid
- FROM
- ...
- )
Add Comment
Please, Sign In to add comment