|  |  | 
 |  |  |     @Delete("DELETE FROM parent_platform WHERE serverGBId=#{serverGBId}") | 
 |  |  |     int delParentPlatform(ParentPlatform parentPlatform); | 
 |  |  |  | 
 |  |  |     @Select("SELECT *,(" + | 
 |  |  |             "select sum(sum1) from ( " + | 
 |  |  |             "SELECT count(0) as sum1 FROM platform_gb_channel pc WHERE pc.platformId = pp.serverGBId " + | 
 |  |  |             "union all " + | 
 |  |  |             "SELECT count(0) as sum1 FROM platform_gb_stream pgs WHERE pgs.platformId = pp.serverGBId " + | 
 |  |  |             ") " + | 
 |  |  |             ") as channelCount " + | 
 |  |  |     @Select("SELECT *, ((SELECT count(0)\n" + | 
 |  |  |             "              FROM platform_gb_channel pc\n" + | 
 |  |  |             "              WHERE pc.platformId = pp.serverGBId)\n" + | 
 |  |  |             "              +\n" + | 
 |  |  |             "              (SELECT count(0)\n" + | 
 |  |  |             "              FROM platform_gb_stream pgs\n" + | 
 |  |  |             "              WHERE pgs.platformId = pp.serverGBId)) as channelCount\n" + | 
 |  |  |             "FROM parent_platform pp ") | 
 |  |  |     List<ParentPlatform> getParentPlatformList(); | 
 |  |  |  |