SELECT DISTINCT
    bierut.id,
    u.id AS uid,
    u.fname AS ufname,
    u.sname AS usname,
    bierut.tekst,
    bierut.DATA,
    IF(l.lajki > 0, l.lajki, 0) AS lajki,
FROM bierut
JOIN skok_users u ON bierut.id_user = u.id
JOIN bierut_tagi t ON bierut.id = t.id_bieruta
LEFT JOIN (SELECT id_bieruta, COUNT(id_usera) AS lajki FROM bierut_lajki GROUP BY id_bieruta) l ON bierut.id = l.id_bieruta
ORDER BY bierut.DATA DESC