Kullanıcı Girişi:
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) AND news.id NOT IN(17868,17867,17866,17865,17861) order by news.datesent DESC LIMIT 0,20
takvim
17.11.2018 - İstanbul 7. ESC 17.11.2018 - İstanbul 13. TKDK 17.11.2018 - Yıldırım Beyazıt Otoloji Odyoloji 22.11.2018 - ERA-International Symposium on Asthma and Rhinitis 2018 23.11.2018 - 5.Fırat TKDK