|  |  | 
 |  |  |     @Delete("DELETE FROM parent_platform WHERE serverGBId=#{serverGBId}") | 
 |  |  |     int delParentPlatform(ParentPlatform parentPlatform); | 
 |  |  |  | 
 |  |  |     @Select("SELECT *,( SELECT count(0) FROM platform_gb_channel pc WHERE pc.platformId = pp.serverGBId) as channelCount FROM parent_platform pp ") | 
 |  |  |     @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(); | 
 |  |  |  | 
 |  |  |     @Select("SELECT * FROM parent_platform WHERE enable=#{enable}") |