Revize 984
Přidáno uživatelem Michal Kliment před více než 13 roky(ů)
| freenetis/branches/testing/application/models/job.php | ||
|---|---|---|
|
SELECT c.*, CONCAT(u.surname," ",u.name) AS user FROM comments c
|
||
|
LEFT JOIN users u ON c.user_id = u.id
|
||
|
ORDER BY datetime DESC
|
||
|
) AS c WHERE c.comments_thread_id = j.comments_thread_id GROUP BY c.user_id
|
||
|
) AS c WHERE c.comments_thread_id = j.comments_thread_id GROUP BY c.comments_thread_id
|
||
|
) AS comments,
|
||
|
(
|
||
|
SELECT GROUP_CONCAT(comment SEPARATOR ", \n\n") FROM
|
||
| ... | ... | |
|
SELECT c.*, CONCAT(u.surname," ",u.name) AS user FROM comments c
|
||
|
LEFT JOIN users u ON c.user_id = u.id
|
||
|
ORDER BY datetime DESC
|
||
|
) AS c WHERE c.comments_thread_id = j.comments_thread_id GROUP BY c.user_id
|
||
|
) AS c WHERE c.comments_thread_id = j.comments_thread_id GROUP BY c.comments_thread_id
|
||
|
) AS comments,
|
||
|
(
|
||
|
SELECT GROUP_CONCAT(comment SEPARATOR ", \n\n") FROM
|
||
| ... | ... | |
|
SELECT c.*, CONCAT(u.surname," ",u.name) AS user FROM comments c
|
||
|
LEFT JOIN users u ON c.user_id = u.id
|
||
|
ORDER BY datetime DESC
|
||
|
) AS c WHERE c.comments_thread_id = j.comments_thread_id GROUP BY c.user_id
|
||
|
) AS c WHERE c.comments_thread_id = j.comments_thread_id GROUP BY c.comments_thread_id
|
||
|
) AS comments,
|
||
|
(
|
||
|
SELECT GROUP_CONCAT(comment SEPARATOR ", \n\n") FROM
|
||
Také k dispozici: Unified diff
Oprava chyby na zobrazeni seznamu vsech praci.