(Sorry for delay, I cannot send two messages in short time, tells me the forum :-))
OK, I perform it again:
Code: Select all
SELECT a.*,l.title AS language_title,uc.name AS editor,c.title AS category_title, c.title AS guestbook_title, c.id AS guestbook_id
FROM `et_phocaguestbook_items` AS a
LEFT JOIN `et_languages` AS l
ON l.lang_code = a.language
LEFT JOIN et_users AS uc
ON uc.id=a.checked_out
LEFT JOIN et_categories AS c
ON c.id = a.catid
WHERE a.id > 1
AND (a.published IN (0, 1))
ORDER BY a.rgt desc
LIMIT 20
Code: Select all
SELECT COUNT(*)
FROM `et_phocaguestbook_items` AS a
LEFT JOIN `et_languages` AS l
ON l.lang_code = a.language
LEFT JOIN et_users AS uc
ON uc.id=a.checked_out
LEFT JOIN et_categories AS c
ON c.id = a.catid
WHERE a.id > 1
AND (a.published IN (0, 1))
