QUERY: SELECT
CONCAT(field_data_field_lengte.field_lengte_value DIV 60, ':', MOD(field_data_field_lengte.field_lengte_value, 60) ) as tijd,
REPLACE(file_managed_poster.uri, 'public://', 'https://www.daltondistribution.be/sites/default/files/') as urlfotoposter,
REPLACE(file_managed_stills.uri, 'public://', 'https://www.daltondistribution.be/sites/default/files/') as urlstill,
node.title,
GROUP_CONCAT( DISTINCT taxonomy_term_data.name ORDER BY taxonomy_term_data.name ASC SEPARATOR ',') as tax,
GROUP_CONCAT( DISTINCT taxonomy_term_data.tid ORDER BY taxonomy_term_data.name ASC SEPARATOR ',') as tax2_enkeldaton,
GROUP_CONCAT( DISTINCT ConversieTIDZedDalton.TidZed ORDER BY taxonomy_term_data.name ASC SEPARATOR ',') as tax2,
GROUP_CONCAT( DISTINCT landenlijst.landnaam ORDER BY landenlijst.landnaam ASC SEPARATOR ', ') as landenlijstje,
GROUP_CONCAT( DISTINCT node2.title ORDER BY node2.title ASC SEPARATOR ', ') as regielijst,
GROUP_CONCAT( DISTINCT genres.genrenaam ORDER BY genres.genrenaam ASC SEPARATOR ', ') as genrelijst,
field_data_field_lesmap_beschikbaar.field_lesmap_beschikbaar_value,
field_onderwijstype_value,
field_gesproken_taal_value,
node.nid,
'2' as zedofdalton,
body_value as synopsis,
field_data_field_jaar.field_jaar_value, field_data_field_type_film.field_type_film_value,
field_data_field_type_film.field_type_film_value,
field_ondertiteling_value,
field_topquote_value
FROM
node
LEFT JOIN field_data_field_jaar
ON
field_data_field_jaar.entity_id = node.nid
LEFT JOIN field_data_field_type_film
ON
field_data_field_type_film.entity_id = node.nid
LEFT JOIN
genres on field_data_field_type_film.field_type_film_value = genres.genrecode
LEFT JOIN field_data_field_regisseur
on field_data_field_regisseur.entity_id = node.nid
LEFT JOIN node node2
on node2.nid = field_data_field_regisseur.field_regisseur_target_id
LEFT JOIN field_data_field_productielanden
ON field_data_field_productielanden.entity_id = node.nid
LEFT JOIN landenlijst
ON field_data_field_productielanden.field_productielanden_value = landenlijst.landcode
LEFT JOIN field_data_field_stills
ON
field_data_field_stills.entity_id = node.nid
LEFT JOIN
file_managed file_managed_stills
ON field_data_field_stills.field_stills_fid = file_managed_stills.fid
LEFT JOIN
field_data_field_poster
ON field_data_field_poster.entity_id = node.nid
LEFT JOIN
file_managed file_managed_poster
ON field_data_field_poster.field_poster_fid = file_managed_poster.fid
LEFT JOIN
field_data_field_keywords
ON
field_data_field_keywords.entity_id = node.nid
LEFT JOIN
taxonomy_term_data ON taxonomy_term_data.tid = field_data_field_keywords.field_keywords_tid
LEFT JOIN ConversieTIDZedDalton On ConversieTIDZedDalton.TidDalton = taxonomy_term_data.tid
LEFT JOIN
field_data_field_lesmap_beschikbaar
ON field_data_field_lesmap_beschikbaar.entity_id = node.nid
LEFT JOIN
field_data_field_onderwijstype
ON field_data_field_onderwijstype.entity_id = node.nid
LEFT JOIN
field_data_field_gesproken_taal ON field_data_field_gesproken_taal.entity_id = node.nid
LEFT JOIN
field_data_body on field_data_body.entity_id = node.nid
LEFT JOIN
field_data_field_lengte on field_data_field_lengte.entity_id = node.nid
LEFT JOIN
field_data_field_ondertiteling on field_data_field_ondertiteling.entity_id = node.nid
LEFT JOIN
field_data_field_topquote on field_data_field_topquote.entity_id = node.nid
WHERE
(
(node.type = 'film')
AND
(
node.nid =
)
)
GROUP BY
node.title
ORDER BY node.title
LIMIT 0,100
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
)
GROUP BY
node.title
ORDER BY node.title
LIMIT 0,100' at line 110
