SELECT COUNT(p.ID) AS numrows FROM tweb_posts p WHERE p.`post_type`='post' AND p.`post_status`='publish' AND p.`post_category`=4; ?>
SELECT p.*,u.nama as unama, k.nama as post_category_name, k.nama_en as post_category_name_en FROM tweb_posts p LEFT JOIN tweb_users u ON p.post_author=u.id LEFT JOIN tweb_posts_category k ON p.post_category=k.id WHERE p.`post_type`='post' AND p.`post_status`='publish' AND p.`post_category`=4 ORDER BY p.`post_date` DESC LIMIT 56, 8 ?>
SELECT p.ID, p.post_name, p.post_title, p.post_title_en, p.post_date, p.post_cover, p.post_tags, p.post_content, p.post_content_en, c.nama AS post_direktori, u.nama as penulis FROM tweb_posts p LEFT JOIN tweb_posts_category c ON p.post_category=c.id LEFT JOIN tweb_users u ON p.post_author=u.id WHERE p.`post_type`='post' AND p.`post_status`='publish' ORDER BY p.`post_date` DESC LIMIT 8 ?>
Array ( [0] => siteman/settings/users_datatables [1] => siteman/profile/upload_pp [2] => siteman/laman/simpan [3] => siteman/siteman/summernote_upload [4] => siteman/projects/project_json_datatables [5] => siteman/projects/clients_datatables [6] => siteman/projects/clients_contact_save [7] => siteman/projects/ajax_search_wilayah [8] => siteman/posts/post_ganti_sampul [9] => siteman/associates/json_datatables [10] => siteman/associates/upload_pp [11] => siteman/associates/simpan [12] => siteman/website/medsos_simpan )