La tabla GAMECMS_NEWS
la tabla GAMECMS_NEWSSYSTEMLINK
mi consulta
Código PHP:
$sql = "SELECT
distinct gamecms_news.newsId,
gamecms_news.subject,
gamecms_news.shortNews,
gamecms_news.iconId,
gamecms_news.releaseDateTime,
gamecms_system.systemAbbrev
FROM
gamecms_newsSystemLink
INNER JOIN
gamecms_news
ON
gamecms_newsSystemLink.newsId = gamecms_news.newsId
INNER JOIN
gamecms_system
ON
gamecms_newsSystemLink.systemId = gamecms_system.systemId
WHERE
auth='1'
AND
gamecms_news.deleted='0'
ORDER BY
releaseDateTime
DESC
LIMIT 0, ".$numNews;
Espero puedan ayudarme