SELECT * FROM demo 
  WHERE `type`=101 OR 
        (`type`=102 AND `id` = (
                        SELECT `id` FROM demo  WHERE `type`=103 
                                               AND `id` IN 
                                                        (SELECT dt.id FROM (SELECT * FROM demo WHERE `type`=102) AS dt)
                                               AND `value` like'3301%'
));