(SELECT node1.title as naam, node2.nid, node2.title as filmtitel, 'regisseur' as functie FROM node as node1 INNER JOIN field_data_field_regisseur ON field_data_field_regisseur.field_regisseur_target_id = node1.nid INNER JOIN node as node2 ON node2.nid = field_data_field_regisseur.entity_id WHERE node1.type='actoren' AND node1.nid = %i) UNION (SELECT node1.title as naam, node2.nid, node2.title as filmtitel, 'productie' as functie FROM node as node1 INNER JOIN field_data_field_productie ON field_data_field_productie.field_productie_target_id = node1.nid INNER JOIN node as node2 ON node2.nid = field_data_field_productie.entity_id WHERE node1.type='actoren' AND node1.nid = %i) UNION (SELECT node1.title as naam, node2.nid, node2.title as filmtitel, 'DOP' as functie FROM node as node1 INNER JOIN field_data_field_dop ON field_data_field_dop.field_dop_target_id = node1.nid INNER JOIN node as node2 ON node2.nid = field_data_field_dop.entity_id WHERE node1.type='actoren' AND node1.nid = %i) UNION (SELECT node1.title as naam, node2.nid, node2.title as filmtitel, 'montage' as functie FROM node as node1 INNER JOIN field_data_field_montage ON field_data_field_montage.field_montage_target_id = node1.nid INNER JOIN node as node2 ON node2.nid = field_data_field_montage.entity_id WHERE node1.type='actoren' AND node1.nid = %i) UNION (SELECT node1.title as naam, node2.nid, node2.title as filmtitel, 'muziek' as functie FROM node as node1 INNER JOIN field_data_field_muziek ON field_data_field_muziek.field_muziek_target_id = node1.nid INNER JOIN node as node2 ON node2.nid = field_data_field_muziek.entity_id WHERE node1.type='actoren' AND node1.nid = %i) UNION (SELECT node1.title as naam, node2.nid, node2.title as filmtitel, 'cast' as functie FROM node as node1 INNER JOIN field_data_field_acteur ON field_data_field_acteur.field_acteur_target_id = node1.nid INNER JOIN node as node2 ON node2.nid = field_data_field_acteur.entity_id WHERE node1.type='actoren' AND node1.nid = %i) ORDER BY filmtitel

Robby Cleiren


Cadet (cast)
Het Moment (cast)