SELECT `p`.* , ( CASE WHEN `c`.`slug` IS NULL THEN CONCAT(`p`.`post_type`,'/',`p`.`slug`) ELSE CONCAT(`p`.`post_type`,'/',`c`.`slug`,'/',`p`.`slug`) END ) AS `url`,`c`.`title` AS `cname`, CONCAT(`p`.`post_type`,'/',`c`.`slug`) AS `urlcategory` FROM `post` AS `p` LEFT JOIN `category` AS `c` ON `c`.`category_id`=`p`.`category_id` AND `c`.`post_type`=`p`.`post_type` WHERE `p`.`post_type`='posts' AND `p`.`status`='publish' AND `p`.`date_publish` <= NOW() ORDER BY `p`.`date_publish` DESC,`p`.`post_id` DESC LIMIT 0,6; SMA Tamansiswa Teluk Betung - Berita
Call Us On : (0721) 475448 | Email : smatamsis.74bdl@gmail.com |

Berita