SELECT sarki.ad AS sarki_ad, sarki_id, album.ad AS album_ad, sarki.album_id, sanatci.ad AS sanatci_ad, album.sanatci_id,  SUM(deger) AS toplampuan, COUNT(deger) AS toplamoy,  sure, muzik_tur.ad AS tur, sarki.yerli, sarki_sozu FROM sarki, album, sanatci, oylar, muzik_tur WHERE oylar.sira = sarki.sarki_id AND kaynak=3 AND sarki.ad LIKE '$harf%' AND sarki.album_id = album.album_id AND album.sanatci_id = sanatci.sanatci_id AND sarki.tur = muzik_tur.tur_id GROUP BY sarki.ad