SELECT s.selishte_id, sp.ime, s.selishte_up_id, spbg.ime, COUNT(ob.obqva_id) AS broi_ob, s.selishted FROM selishte s LEFT JOIN selishte_prevod sp ON s.selishte_id = sp.selishte_id AND sp.ezik_id = 1 LEFT JOIN selishte_prevod spbg ON s.selishte_id = spbg.selishte_id AND spbg.ezik_id = 1 LEFT JOIN obqva_selishte ob ON s.selishte_id = ob.selishte_id GROUP BY s.selishte_id, sp.ime, s.selishte_up_id, spbg.ime, s.selishted ORDER BY sp.ime