Buenas tardes, voy a realizar una consulta que entiendo que pueda parecer muy básica.
Intente introducir la id del curso pero me da error, podría ayudarme?
SELECT
u.username AS 'From',
u2.username AS 'To',
DATE_FORMAT(FROM_UNIXTIME(me.timecreated), '%Y-%m-%d %H:%i') AS 'When',
me.subject,
me.smallmessage
FROM prefix_message me
WHERE c.id=24
JOIN prefix_user u ON u.id = me.useridfrom
JOIN prefix_user u2 ON u2.id = me.useridto
ORDER BY u.username, u2.username