zUi4nipr

1I need some help getting MySql to output some results using a subquery
2CREATE TABLE IF NOT EXISTS `session_data` (
3  `visible_portf_ids` varchar(255) DEFAULT NULL
4) ENGINE=InnoDB DEFAULT CHARSET=utf8;
5
6INSERT INTO `session_data` (`visible_portf_ids`) VALUES
7('45,44,658,659,661,45,44,658,659,661')
8	
9SELECT portfolio_hierarchy_id, account_id, name, leaf_node_portf_id 
10FROM portfolio_hierarchy
11WHERE account_id = 1
12AND leaf_node_portf_id IN 
13            (
14                 (SELECT visible_portf_ids
15                 FROM session_data
16                 WHERE username = 'ronedog')
17            )
18ORDER BY name ASC
19	
20(SELECT visible_portf_ids
21FROM session_data
22WHERE username = 'ronedog')
23	
2445,44,658,659,661,45,44,658,659,661
25	
26SELECT portfolio_hierarchy_id, account_id, name, leaf_node_portf_id 
27FROM portfolio_hierarchy
28WHERE account_id = 1
29AND leaf_node_portf_id IN (45,44,658,659,661,45,44,658,659,661)
30ORDER BY name ASC
31	
32AND FIND_IN_SET(leaf_node_portf_id,
33                 (SELECT visible_portf_ids
34                 FROM session_data
35                 WHERE username = 'ronedog'
36                 LIMIT 1)
37            ) > 0