|
|
Herzlich Willkommen bei uhrwerk.org uhrwerk - Zeit ist Macht. Status: www.uhrwerk.org / board
 |
|
 |
| |
 |
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN or_board_threads as t ON t.thread_id = p.id
' at line 37
SELECT
p.thread_id as thread_id,
p.id as post_id,
p.title as post_title,
p.text as post_text,
p.edit_times as post_edit_times,
p.edit_user_id as post_edit_user_id,
p.author_id as author_id,
p.anonymous_nick as anonymous_nick,
p.anonymous_email as anonymous_email,
p.ip_address as ip_address,
DATE_FORMAT(p.time,'%d.%m.%Y %k:%i') as post_time,
UNIX_TIMESTAMP(p.time) as post_time2,
DATE_FORMAT(p.edit_time,'%d.%m.%Y %k:%i') as post_edit_time,
DATE_FORMAT(bu.registerdate,'%d.%m.%Y') as author_regdate,
bu.rank_id as author_rank_id,
t.is_poll as is_poll,
t.is_closed as is_closed,
t.is_announcement as is_announcement,
t.is_sticky as is_sticky,
u.avatar as author_avatar,
u.nick as author_nick,
u.country_residence as author_residence,
u.country_nationality as author_nationality,
u.clantag as clantag,
UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(u.lastonline) as author_idletime,
u.num_board_posts as author_posts,
u.popularity as popularity,
u.set_board_signature as author_signature,
u.set_board_rank as author_rank,
DATE_FORMAT(NOW(),'%d.%m.%Y') AS today,
DATE_FORMAT(NOW() - INTERVAL 1 DAY,'%d.%m.%Y') AS yesterday
FROM or_board_posts as p
LEFT JOIN or_users as u ON u.id = p.author_id
LEFT JOIN or_board_users as bu ON bu.user_id = p.author_id AND bu.forum_id =
INNER JOIN or_board_threads as t ON t.thread_id = p.id
WHERE p.id =
GROUP BY p.id
ORDER BY p.time ASC
LIMIT 0,1 |
|
|
 |
|
 |
|
|
