SELECT COUNT(x1_referat.id) AS cid, subject_uploads, x1_subject.subject_uploads, x1_subject.subj_id, x1_subject.srt FROM x1_referat, x1_subject WHERE x1_referat.subj_id=x1_subject.subj_id and x1_referat.typ!=12 GROUP BY x1_subject.subject_uploads ORDER BY srt