Home Statistics Search Cover Gallery People Gallery Picture Gallery Administration Credits
de dk en nl no
SQL-Statement failed:
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'usr_ud08_155_2.pmp_film.sorttitle' which is not in SELECT list; this is incompatible with DISTINCT

Query:
SELECT DISTINCT pmp_film.id FROM pmp_film LEFT JOIN pmp_boxset ON pmp_film.id = pmp_boxset.childid 
WHERE pmp_film.collectiontype = 'Owned' AND 
pmp_boxset.childid IS NULL 
ORDER BY pmp_film.sorttitle asc LIMIT 0, 100