SELECT (SELECT COUNT(1) FROM `click_views` AS `cv` , `affilates` AS `af`
WHERE `af`.`id` = `cv`.`af_id` AND `cv`.`af_id` = '151' AND `cv`.`view_type` = 'c') as `ccount`,
(SELECT COUNT(1) FROM `click_views` AS `cv` , `affilates` AS `af`
WHERE `af`.`id` = `cv`.`af_id` AND `cv`.`af_id` = '151' AND `cv`.`view_type` = 'v') as `vcount`,
(SELECT COUNT(1) FROM `click_views` as `cv`, `affilates` as `af`, `payouts` as `po`
WHERE `po`.`click_views_id` = `cv`.`id` AND `af`.`id` = `cv`.`af_id` AND `cv`.`af_id` = '151' AND `po`.`IS_FREE` = 'TRUE') as `fcount`,
(SELECT COUNT(1) as `pcount` FROM `click_views` as `cv`, `affilates` as `af`, `payouts` as `po`, `accounts` as `ac`
WHERE `po`.`click_views_id` = `cv`.`id` AND `af`.`id` = `cv`.`af_id` AND `cv`.`af_id` = '151' AND `po`.`IS_FREE` = 'FALSE' AND `ac`.`id` != `po`.`memberID` OR `po`.`memberID` = 0 AND `ac`.`convert_to_paying` = 0) as `pcount`,
(SELECT COUNT(1) FROM `click_views` as `cv`, `affilates` as `af`, `payouts` as `po`, `accounts` as `ac`
WHERE `po`.`click_views_id` = `cv`.`id` AND `af`.`id` = `cv`.`af_id` AND `cv`.`af_id` = '151' AND `po`.`IS_FREE` = 'FALSE' AND `ac`.`id` = `po`.`memberID` AND `ac`.`convert_to_paying` != 0) as `fpcount`