get values of nested query in mysql

Question

SELECT *, count(idWallHasWallPost) as republish FROM admin_pw.wall_has_wallpost 
    where WallPost_idWallPost in 
    (select WallPost_idWallPost from wall_has_wallpost where Wall_idWall in 
    (select Wall_idWall from follower where User_idUser=1))
    group by WallPost_idWallPost 
    having republish>1;

I have this nested query in mysql. Is there anyway to acces the values from the nested queries higher up in the query.

I would like to access Wall_idWall in last select. I select it the query lowest and would like to see which Wall_idWall was used by the in operator.

user359040 · Accepted Answer · 2013-02-18 11:12:52Z

1

Try:

SELECT w.*, count(w.idWallHasWallPost) as republish, v.all_Wall_idWall
FROM admin_pw.wall_has_wallpost w
join (select h.WallPost_idWallPost, 
             group_concat(distinct h.Wall_idWall) all_Wall_idWall
      from wall_has_wallpost h
      join follower f on h.Wall_idWall = f.Wall_idWall and f.User_idUser=1
      group by h.WallPost_idWallPost) v
on w.WallPost_idWallPost = v.WallPost_idWallPost
group by WallPost_idWallPost 
having republish>1;

answered Feb 18, 2013 at 11:12

user359040

Sign up to request clarification or add additional context in comments.

Comments

Methew · Accepted Answer · 2013-02-18 11:20:41Z

0

try this if you only need Wall_idWall in last select

SELECT *, count(idWallHasWallPost) as republish,(select Wall_idWall from follower where User_idUser=1) as Wall_idWall FROM admin_pw.wall_has_wallpost 
where WallPost_idWallPost in 
(select WallPost_idWallPost from wall_has_wallpost where Wall_idWall in 
(select Wall_idWall from follower where User_idUser=1))
group by WallPost_idWallPost 
having republish>1;

OR you can change where clause according to your requirements.

answered Feb 18, 2013 at 11:20

Methew

3634 gold badges10 silver badges28 bronze badges

Collectives™ on Stack Overflow

get values of nested query in mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related