14 lines
195 B
MySQL
14 lines
195 B
MySQL
|
SELECT
|
||
|
posts.id,
|
||
|
posts.post_title,
|
||
|
posts.isanon,
|
||
|
posts.post_time,
|
||
|
authors.name
|
||
|
FROM
|
||
|
posts,authors,tags
|
||
|
WHERE
|
||
|
posts.authorid = authors.id AND
|
||
|
posts.id = tags.postid AND
|
||
|
tags.tag = :tag;
|
||
|
|