Références

  • LE COPERNIC
  • Le Citalium
  • Le Citalys
  • LE COPERNIC II
  • ETOILE SAINT HONORE
  • EUROPA
  • FRANKLIN
  • LA PLACE OVALE
  • Accueil
  • Actualités
  • La carte des projets
  • Attentifs à l'architecture
  • Nous connaître
SELECT * FROM node, url_alias, content_type_programmes_realises, files WHERE ((files.fid IN (SELECT field_perspective_fid FROM content_field_perspective WHERE vid = node.vid)) OR (files.fid IN (SELECT field_perspective_1_fid FROM content_field_perspective_1 WHERE vid = node.vid)) OR (files.fid IN (SELECT field_perspective_2_fid FROM content_field_perspective_2 WHERE vid = node.vid)) OR (files.fid IN (SELECT field_perspective_3_fid FROM content_field_perspective_3 WHERE vid = node.vid))) AND node.vid = content_type_programmes_realises.vid AND src=CONCAT('node/', node.nid) AND field_reference_type_value='entreprise' ORDER BY node.vid DESC, fid

Références

Références

Flash Player version 10.0.0 (get Flash Player) is required to visit 'Les Nouveaux Constructeurs'.

You can try to upgrade your Flash Player by clicking here

You can also access the html alternative