SELECT news.details as details , news.id as id, news.title as newstitle, news.summary as summary, image,file,categories.summary as catsummary, categories.title as category,categories.id as catid , publishdate, UNIX_TIMESTAMP(news.datesent) as datesent FROM news, categories WHERE categories.id!=10 AND news.category=categories.id AND categories.id=38 AND news.publishdate<>'' AND news.publishdate >= DATE_SUB(CURDATE(), INTERVAL 1 YEAR) order by news.datesent DESC LIMIT 1660,20 Kanal KBB
Kullanıcı Girişi:
GENEL DUYURULAR
Her sayfada 20 kayıt gösterilmektedir.