SELECT
A.CREATED_TIME,
A.ID,
A.LINK,
A.PICTURE,
A.MESSAGE,
B.AMOUNT_COMMENTS,
C.LIKES,
A.SHARES,
ROUND((B.NEGATIVE)/(0.1* C.LIKES + B.AMOUNT_COMMENTS)*100,2) AS "NEGATIVE_MOOD",
ROUND((B.NEUTRAL)/(0.1* C.LIKES + B.AMOUNT_COMMENTS)*100,2) AS "NEUTRAL_MOOD",
ROUND((B.POSITIVE + (0.1* C.LIKES))/(0.1* C.LIKES + B.AMOUNT_COMMENTS)*100,2) AS "POSITIVE_MOOD"
--IFNULL(B.NEGATIVE,0) AS "NEGATIVE_MOOD",
--IFNULL(B.NEUTRAL,0) AS "NEUTRAL_MOOD",
--IFNULL(B.POSITIVE,0) + IFNULL((0.1* C.LIKES),0) AS "POSITIVE_MOOD"
FROM FBWALLPOST A
LEFT JOIN
(
    SELECT
    POST_ID,
    COUNT(POST_ID) AS "AMOUNT_COMMENTS",
    COUNT(CASE WHEN SENTIMENT_VALUE < '0' THEN '1' END) AS "NEGATIVE",
    COUNT(CASE WHEN SENTIMENT_VALUE = '0' THEN '1' END) AS "NEUTRAL",
    COUNT(CASE WHEN SENTIMENT_VALUE > '0' THEN '1' END) AS "POSITIVE"
    FROM BECKS_FBCOM
    GROUP BY POST_ID
) B
ON A.ID = B.POST_ID
LEFT JOIN
(
    SELECT
    POST_ID,
    COUNT(POST_ID) AS "LIKES"
    FROM FBLIKE
    GROUP BY POST_ID
) C
ON A.ID = C.POST_ID
WHERE A.SOURCE = 'fb_becks.de/feed'
ORDER BY A.CREATED_TIME DESC