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<>12 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