Ophir LOJKINE
11 lines
233 B
SQL
11 lines
233 B
SQL
SELECT 'list' AS component, 'Blog Posts' AS title;
|
|
|
|
SELECT
|
|
p.title,
|
|
u.username AS description,
|
|
'user' AS icon,
|
|
CONCAT('/post/', p.id) AS link
|
|
FROM posts p
|
|
JOIN users u ON p.user_id = u.id
|
|
ORDER BY p.created_at DESC;
|