SQL:SELECT DISTINCT COUNT(DISTINCT d.id, version),d.id as id, dv.version as version, d.ord as ord, dv.status as status, d.parent_id as parent_id, d.template_id as template_id, t.uname as template_uname, t.has_template_fields as has_content, d.folder as folder, d.uname as uname, dv.name as name, dv.title as title, dv.keywords as keywords, dv.description as description, dv.default_handler as default_handler, dv.time_created as timestamp_created, dv.time_modified as timestamp_modified, dv.time_publish as timestamp_publish, dv.time_expires as timestamp_expires,0 as relevance FROM document as d,document_version as dv,template as t WHERE d.id=dv.document_id AND t.id=d.template_id AND (d.parent_id = '1') AND (status = 'published') ORDER BY title ASC LIMIT 5 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause Kinokone - 101 osumaa| yle.fi | Arkistoitu
 
Hae YLEstä:
Kinokone
Satunnaiselokuvageneraattori

Hakuehdot:

Luettelo kaikista Kinokoneen elokuvista.
Uusi haku
Hakutulos ( 101 Osumaa )
 

Sivu:

1 | 2 | 3 | ... | 20 | 21
 Seuraava »

Warning: Invalid argument supplied for foreach() in /www/kinokone/templates/result.php on line 150
 

Sivu:

1 | 2 | 3 | ... | 20 | 21
 Seuraava »