obrati samo paznju, za te gde nemas dl za DL's ces dobiti u rezultatu
NULL a ne 0
mozes da promenis upit ovako pa da ishendlas te null-ove:
SELECT
t1.FileName,
t1.CLKs,
COALESCE(t1.DLs, 0) AS DLs,
COALESCE(t1.DLs / t1.CLKs, 0) AS Conv,
COALESCE(t1.FullRevenue / t1.DLs, 0) AS AverageDLRevenue,
COALESCE(t1.FullRevenue / t1.CLKs, 0) AS AverageClickRevenue,
COALESCE(t1.FullRevenue, 0) AS FullRevenue
FROM
(SELECT
`files`.`filename` AS FileName,
`files`.`id` AS file_id,
(SELECT COUNT(*)
FROM
`clicks`
WHERE
`clicks`.`file_id` = `files`.`id`
AND `clicks`.`date` BETWEEN '2014-05-10' AND '2014-05-17'
) AS CLKs,
t2.DLs,
t2.RevnSUM AS FullRevenue
FROM
`files`
LEFT JOIN
(SELECT `file_id`, COUNT(*) AS DLs, SUM(revenue*percentage/100) AS RevnSUM
FROM
`downloads`
WHERE
`downloads`.`date` BETWEEN '2014-05-10' AND '2014-05-17'
GROUP BY `file_id`
) t2
ON
(`t2`.`file_id` = `files`.`id` )
WHERE
`files`.`user_id` = 106
) t1
WHERE
t1.CLKs > 0
ORDER BY
CLKs DESC, DLs DESC