CAdvBanner :: getCTRSQL: Bitrix method

      
<?php 
//  CAdvBanner :: getCTRSQL()
//  /dist/bitrix/modules/advertising/classes/mysql/advertising.php:264

    
public static function getCTRSQL()
    {
        return 
'IF (SUM(D.SHOW_COUNT) > 0, round((SUM(D.CLICK_COUNT)*100)/SUM(D.SHOW_COUNT),2), 0)    CTR';
    }