Startseite Statistiken Suche Covergallerie Personengallerie Bildergallerie Newsarchiv Gästebuch Kontakt Adminstration free-for-all Home free-for-all Forum Credits
de dk en nl no
SQL-Statement failed:
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'freeforadvd.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 LEFT JOIN pmp_collection ON pmp_film.collectiontype = pmp_collection.collection 
WHERE pmp_collection.partofowned = '1' AND 
pmp_boxset.childid IS NULL 
ORDER BY pmp_film.sorttitle asc LIMIT 0, 30