SELECT p.*, l.link AS pageLink, n.lang,
(SELECT username FROM warp_cms_users WHERE id_user = p.id_user_insert ) AS user_insert_username,
(SELECT username FROM warp_cms_users WHERE id_user = p.id_user_update ) AS user_update_username,
(SELECT firstname FROM warp_cms_users WHERE id_user = p.id_user_insert ) AS user_insert_firstname,
(SELECT firstname FROM warp_cms_users WHERE id_user = p.id_user_update ) AS user_insert_firstname,
(SELECT lastname FROM warp_cms_users WHERE id_user = p.id_user_insert ) AS user_update_lastname,
(SELECT lastname FROM warp_cms_users WHERE id_user = p.id_user_update ) AS user_update_lastname
FROM warp_cms_posts
INNER JOIN warp_cms_links AS l
ON p.id_link = l.id_link
INNER JOIN warp_cms_navs AS n
ON l.id_nav = n.id_nav
WHERE p.id_link = 13
AND p.publish = 1
AND publish_date < 1765409100 AND ( ( publish_date_to > publish_date AND publish_date_to > 1765409100 ) OR publish_date_to < publish_date )
ORDER BY sticky DESC, publish_date DESC, title
Vyhledávání | multizone.cz