|
SELECT a.*, u.name AS author, u.usertype, UNIX_TIMESTAMP( a.created ) AS created_ts, cat.title AS cat_title, sec.title AS section_title
FROM #__content AS a
LEFT JOIN #__categories AS cat ON cat.id = a.catid
LEFT JOIN #__sections AS sec ON sec.id = a.sectionid
WHERE
AND cat.published = 1
AND sec.published = 1
ORDER BY a.created DESC Error creating feed file, please check write permissions. |
Sindicación
Unia-Informa
Números anteriores
Novedades UNIADestacamos |
