SELECT DISTINCT
    bierut.id,
    u.id AS uid,
    u.fname AS ufname,
    u.sname AS usname,
    bierut.tekst,
    bierut.DATA,
    IF(l1.lajki > 0, l1.lajki, 0) AS lajki,
    IF(l2.id_bieruta IS NOT NULL, 1, 0) AS czy_lajk,
    IF(bierut.ogolny = 1, 'info', IF(bierut.lokacja = 0, 'block', 'danger')) AS alert
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) l1 ON bierut.id = l1.id_bieruta
LEFT JOIN (SELECT id_bieruta FROM bierut_lajki WHERE id_usera = 107) l2 ON bierut.id = l2.id_bieruta
ORDER BY bierut.DATA DESC