Problem 1:
SELECT publicationname, publicationnamesort FROM sqlb_publicationoverview WHERE publicationname != publicationnamesort;

Problem 2:
What is "Arr" (probably from Array (someone uses PHP))
SELECT language0, count(*) FROM sqlb_publicationoverview GROUP BY language0;
vs
SELECT language, count(*) FROM sqlb_publications GROUP BY language;


Problem 3:
//no unique key :(
SELECT id_pub, COUNT( DISTINCT refcode1 ) FROM sqlb_publications GROUP BY id_pub HAVING COUNT( DISTINCT refcode1 ) > 1;

Problem 4:
//parentnote shouldn't be 0... ever
SELECT * FROM sqlb_publications WHERE parentnode IS NOT NULL AND parentnode <= 0 LIMIT 10;

Problem 5:
//sha1 passwords needs to be salted
I was able to reverse a few of them
You should consider anything currently stored in there compromised
F7DC00ACEE416C2BEDE7A4AB43FA0623505604A9 -> Sazbir4
61CAC2F4974BD8DFA6153E4E7B81BF5747BF018C -> thompsond
011C945F30CE2CBAFC452F39840F025693339C42 -> 1111
4D7547A1D2787C72F0E985D8B5194295E4AA6141 -> tester1

Problem 6:
// 291438 of ~4800000 are wrong?
SELECT count(*) FROM sqlb_publicationoverview
JOIN sqlb_publications ON sqlb_publicationoverview.id_pub = sqlb_publications.id_pub
WHERE sqlb_publicationoverview.publicationcode != sqlb_publications.refcode1;