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.morituri_film.sorttitle' which is not in SELECT list; this is incompatible with DISTINCT

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