Akademik Müzik Araştırmaları

SELECT p.id as page_id, p.title, p.views, p.published, DATE_FORMAT(p.published, '%d %M %Y') as published_date, a.ad, a.soyad, p.a_id FROM p__c as pc LEFT JOIN pages as p ON (p.id=pc.page_id) LEFT JOIN page_categories as c ON (c.id=pc.category_id) LEFT JOIN akademisyenler as a ON (a.id=p.a_id) WHERE p.id<>10 AND pc.category_id IN (1) AND NOT ISNULL(p.published) AND p.published<=NOW() AND IF(ISNULL(p.unpublished), 1, IF(p.unpublished>NOW(),1,0)) GROUP BY (p.id) ORDER BY p.id LIMIT 8