neayi / tripleperformance

The docker stack for the Triple Performance platform
https://tripleperformance.fr
MIT License
7 stars 1 forks source link

Créer une page avec les dernières interactions #275

Open bertrandgorge opened 1 year ago

bertrandgorge commented 1 year ago

SELECT interactions.* , users.firstname, users.lastname, pages.title FROM interactions INNER join pages ON pages.page_id = interactions.page_id INNER Join users ON users.id = interactions.user_id ORDER BY interactions.updated_at DESC;