(SELECT COUNT(1) AS ccount, `af`.`username` as cuser, `af`.`id` as `cid` FROM `click_views` as `cv`, `affilates` as `af`, `payouts` as `po`, `accounts` as `ac` WHERE `cv`.`view_type` = 'c' GROUP BY `cv`.`af_id` ORDER BY ccount DESC) UNION (SELECT COUNT(1) AS vcount, `af`.`username` as `vuser`, `af`.`id` as vid FROM `click_views` as `cv`, `affilates` as `af`, `payouts` as `po`, `accounts` as `ac` WHERE `cv`.`view_type` = 'v' GROUP BY `cv`.`af_id` ORDER BY ccount DESC) UNION (SELECT COUNT(1) AS pcount, `af`.`username` as puser, `af`.`id` as pid FROM `click_views` as `cv`, `affilates` as `af`, `payouts` as `po`, `accounts` as `ac` WHERE `po`.`IS_FREE` = 'FALSE' AND `po`.`click_views_id` = `cv`.`id` GROUP BY `cv`.`af_id` ORDER BY ccount DESC) UNION (SELECT COUNT(1) AS fpcount, `af`.`username` as fuser, `af`.`id` as fid FROM `click_views` as `cv`, `affilates` as `af`, `payouts` as `po`, `accounts` as `ac` WHERE `po`.`memberID` = `ac`.`id` AND `ac`.`convert_to_paying` != 0 AND `po`.`click_views_id` = `cv`.`id` GROUP BY `cv`.`af_id` ORDER BY ccount DESC)