• Réinitialiser
Public enterprises as policy instruments : the importance of public entrepreneurship
SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Bernier, Luc%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Luc Bernier

(2014)

Journal of Economic Policy Reform

Vol. 17

no. 3

p. 253

Les syndicats dans la mire des conservateurs 

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Collombat, Thomas%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Thomas Collombat

(2014)

Relations

no. 772

p. 4

ICT Helping to Scale up Microfinance

Eduardo Henrique Diniz

Martin Jayo

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Pozzebon, Marlei%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Marlei Pozzebon

Frédéric Lavoie

(2014)

Journal of Global Information Management, Special Issue on ICT in Brazil: Global Issues and Challenges

no. 22

p. 34

Innovations sociales (parties prenantes des stratégies)

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Harrisson, Denis%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Denis Harrisson

(2014)

Encyclopédie de la stratégie

p. 715

Le renouvellement de la géographie économique: vers une approche socioéconomique

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Klein, Juan-Luis%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Juan-Luis Klein

Matthieu Roy

(2014)

Vers une nouvelles géographie économique. Hommage à Claude Manzagol

p. 177

The World Bank and Municipal Adjustments in Senegal: Towards a New Institutional Framework

Mebometa Ndongo

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Klein, Juan-Luis%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Juan-Luis Klein

(2014)

Journal of Management and Strategy

Vol. 5

no. 2

p. 82

Le travail au Québec : plus flexible et plus précaire

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Noiseux, Yanick%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Yanick Noiseux

Samuel Blouin

(2014)

Une sociologie de la recherche partenariale

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Tremblay, Pierre-André%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Pierre-André Tremblay

(2014)

Savoirs croisés, le défi de l'innovation sociale partagé

Les politiques familiales et la gouvernance de la conciliation emploi ¿famille au Québec : le rôle des acteurs

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Tremblay, Diane-Gabrielle%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Diane-Gabrielle Tremblay

(2014)

Travail et société. Une introduction à la sociologie du travail

p. 317

Introduction: Retour sur le Printemps érable

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Ancelovici, Marcos%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Marcos Ancelovici

F. Dupuis-Deri

(2014)

Un Printemps rouge et noir : Regards croisés sur la grève étudiante de 2012

p. 7

Hydro-Québec, la commercialisation d'une société d'État

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Bernier, Luc%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Luc Bernier

(2014)

Les défis québécois : conjonctures et transitions

p. 59

Sans elles, le collège ne serait pas ce qu'il est. Le travail des Petites soeurs de la Sainte-Famille dans les collèges classiques au Québec

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Bienvenue, Louise%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Louise Bienvenue

G. Laperrière

(2014)

Histoire sociale/ Social History

Vol. 47

no. 93

p. 5

Économie sociale et innovation. L'approche de la régulation, au coeur de la construction québécoise de l'économie sociale

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Bouchard, Marie%J.%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Marie J. Bouchard

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Lévesque, Benoît%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Benoît Lévesque

(2014)

L'innovation sociale. Les marches d'une construction théorique et pratique

p. 125

Le rapport D'Amours : de mauvaises solutions

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Bourque, Gilles%L.%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Gilles L. Bourque

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Hanin, Frédéric%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Frédéric Hanin

(2014)

Relations

no. 771

p. 21

La journée de « la » porte ouverte au Pavillon Lucien-Brault de l'UQO

Louise Briand

(2014)

Tisser le fil rouge. Le printemps érable en Outaouais ? récits militants

p. 45

Effets et enjeux des mobilités internationales pour études : histoire de vie d'un recueil de récits de voyage

C. Chaput

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Duperré, Martine%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Martine Duperré

F. Nadeau

Eugénie Terrier

(2014)

Chemins de formation

no. 19

Développement territorial périurbain, réseau d?acteurs et innovation sociale : le cas d?une coopérative internet dans la région de Montréal

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Doyon, Mélanie%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Mélanie Doyon

T. Deroo

(2014)

Revue Interventions économiques

no. 50

Innovation sociale et lutte contre la pauvreté: modèles de gouvernance et de développement territorial

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Klein, Juan-Luis%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Juan-Luis Klein

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Raufflet, Emmanuel%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Emmanuel Raufflet

(2014)

Interventions économiques

Vol. 50

Building 'Critical Performativity Engines' for deprived communities: The construction of popular cooperative incubators in Brazil

B. Leca

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Gond, Jean-Pascal%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Jean-Pascal Gond

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Barin-Cruz, Luciano%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Luciano Barin-Cruz

(2014)

Organization

p. 683

L'intervention à domicile et en milieu ouvert dans les champs de la vieillesse et de la protection de l'enfance France - Québec. Rapport intermédiaire

C. Lenzi

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Jetté, Christian%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Christian Jetté

V. Chamberland

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Dumais, Lucie%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Lucie Dumais

(2014)

La contribution de la CSN à une finance solidaire et responsable, des outils collectifs à un Carrefour financier solidaire
SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Lévesque, Benoît%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Benoît Lévesque

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Bourque, Gilles%L.%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Gilles L. Bourque

Clément Guimond

Claude Dorion

(2014)

Cahiers du CRISES

Vol. ET1402

" Des demi-citoyens, pas des voleurs de jobs

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Noiseux, Yanick%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Yanick Noiseux

(2014)

Réseau d'études des dynamiques transnationales et de l'action collective (REDTAC), article grand public no.5, 2p, mai 2014.

Centres d'appel et Infirmières

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Tremblay, Diane-Gabrielle%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Diane-Gabrielle Tremblay

(2014)

Dictionnaire des risques psycho-sociaux

La démocratie directe en mouvement: Structure et rapports de pouvoir au sein de la CLASSE

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Ancelovici, Marcos%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Marcos Ancelovici

Maxime Roy-Allard

(2014)

Un Printemps rouge et noir : Regards croisés sur la grève étudiante de 2012

p. 87

De l'importance à l'essentialité de la géographie

Mario Bédard

(2014)

Vol. 1

Les organismes centraux

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Bernier, Luc%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Luc Bernier

André Fortier

(2014)

La politique québécoise et canadienne : une approche pluraliste

p. 239

Between Protection and Activation: People with Disabilities in the Social Investment State

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Dumais, Lucie%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Lucie Dumais

L. Archambault

(2014)

Canadian Journal of Disabilities

Vol. 4

no. 2

Le développement économique communautaire et la cohésion sociale à Montréal

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Klein, Juan-Luis%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Juan-Luis Klein

Pierre Morrissette

(2014)

Le défi de l?innovation sociale partagée

p. 159

L' innovation sociale : les marches d'une construction théorique et pratique

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Lévesque, Benoît%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Benoît Lévesque

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Fontan, Jean-Marc%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Jean-Marc Fontan

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Klein, Juan-Luis%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Juan-Luis Klein

(2014)

A review of two decades of employment equity in Canada: progress and propositions

Eddy Ng

Rana Haq

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Tremblay, Diane-Gabrielle%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Diane-Gabrielle Tremblay

(2014)

International Handbook on Diversity Management at Work_x005F_x000D_ (Second Edition Country Perspectives on Diversity and Equal Treatment)

p. 46

Transformation du travail au Québec : Flexibilité et précarité

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Noiseux, Yanick%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Yanick Noiseux

(2014)

Droits et libertés

Vol. déc. 2014

Gendering fashion, fashioning fur: on the (re)production of a gendered labor market within a craft industry in transition

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Rantisi, Norma%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Norma Rantisi

(2014)

Environment and Planning D: Society and Space

Vol. 32

no. 2

p. 223

L' innovation technologique, organisationnelle et sociale

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Tremblay, Diane-Gabrielle%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Diane-Gabrielle Tremblay

(2014)

Conclusion: 'Les grèves étudiantes, qu'ossa donne?'

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Ancelovici, Marcos%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Marcos Ancelovici

Francis Dupuis-Deri

(2014)

Un Printemps rouge et noir : Regards croisés sur la grève étudiante de 2012

p. 356

Réflexions sur la territorialité périurbaine. Les cas de Saint-Basile-le-Grand et McMasterville 

Mario Bédard

Sandra Breux

(2014)

Revista Márgenes

Vol. 11

no. 14

p. 40

Organisations publiques

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Bernier, Luc%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Luc Bernier

Jacques Bourgault

Bachir Mazouz

Cédric Gracia

(2014)

Encyclopédie de la stratégie

p. 895

Extreme poverty alleviation through community-based entrepreneurship:PRODECO in Paraguay

J. Gallardo

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Raufflet, Emmanuel%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Emmanuel Raufflet

(2014)

Development in Practice

Vol. 24

no. 1

p. 140

Éléments de synthèse et perspectives d'avenir pour la philanthropie: un système et une culture plurielle
SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Lévesque, Benoît%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Benoît Lévesque

(2014)

Culture philanthropique: visages et transformations. Actes du Sommet, Éléments de synthèse et perspectives d'avenir

p. 126

Un Printemps rouge et noir : Regards croisés sur la grève étudiante de 2012

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Ancelovici, Marcos%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Marcos Ancelovici

Francis Dupuis-Deri

(2014)

Les frais de scolarité et l?UQO ? le sort des universités en région

Guy Bellemare

Louise Briand

(2014)

Tisser le fil rouge. Le printemps érable en Outaouais ? récits militants

p. 45

Dimension sociopolitique

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Bernier, Luc%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Luc Bernier

Luc Farinas

(2014)

Encyclopédie de la stratégie

p. 339

Financiarisation de l'entreprise et prise de contrôle des actifs sous la Lacc: une étude de cas dans l'industrie forestière

Josée Côté

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Hanin, Frédéric%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Frédéric Hanin

François L'Italien

(2014)

Équipe de recherche: Philippe Bergeron, Luc Bouthillier, Josée Côté, Frédéric Hanin, Paul-André Lapointe, François L'Italien, Pierre Thibault

Vol. CT-2014

no. 2

La recherche partenariale dans l'appui au développement local : le parcours de la Concertation en développement social de Verdun

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Jetté, Christian%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Christian Jetté

(2014)

Savoirs croisés: le défi de l'innovation sociale partagée

p. 133

Los Mexicanos en Montreal: ¿Una comunidad transnacional?

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Klein, Juan-Luis%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Juan-Luis Klein

Mauricio Aranzazu

(2014)

Chapitre du rapport du projet " Comunidades transnacionales y cultura empresarial en America del Norte", mené à terme avec le financement du Programa interinstitucional de estudios sobre la región de América del Norte (PIERAN)

Les systèmes industriels localisés : état de la recherche

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Lévesque, Benoît%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Benoît Lévesque

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Fontan, Jean-Marc%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Jean-Marc Fontan

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Klein, Juan-Luis%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Juan-Luis Klein

(2014)

L'innovation sociale, les marches d'une construction théorique et pratique

p. 101

Être parent et avocat : les défis de la conciliation travail-famille pour la progression professionnelle
SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Tremblay, Diane-Gabrielle%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Diane-Gabrielle Tremblay

(2014)

Regards sur le travail [en ligne]

Vol. 10

no. 1

And Philosophy for All! A multi-Stakeholder Co-operative's Quest to Disseminate the Practice of " Commmunitties of Inquiry "

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Audebrand, Luc%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Luc Audebrand

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Malo, Marie-Claire%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Marie-Claire Malo

(2014)

Journal of Cooperative Studies

Vol. 47

no. 1

p. 9

Interagency, network and Co-governance in the Child Care Sector

Guy Bellemare

Marcos Barros

Louise Briand

(2014)

Cahier du CRISES

no. ET1405

Multi-event ethnography: doing research in pluralistic settings

N.A. Delgado

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Barin-Cruz, Luciano%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Luciano Barin-Cruz

(2014)

Journal of Organizational Ethnography

Vol. 3

p. 43

Non-standard Employment, The Jobs Crisis and Precarity : A Report on the Structural Transformation of the World of Work, Working paper

D. Draiche

A. Lemesurier

SELECT guid FROM coloc_posts INNER JOIN coloc_term_relationships on coloc_posts.ID = coloc_term_relationships.object_id where post_title like '%Noiseux, Yanick%' and coloc_term_relationships.term_taxonomy_id = 8 order by ID DESC Limit 1

Yanick Noiseux

(2014)