SELECT s.nazev_skup, c.* FROM rs_clanky AS c LEFT JOIN rs_skup_cl AS s ON c.skupina_cl = s.ids WHERE nazev_skup LIKE("%a%")