PageLimit;
$group_say = $wpdb->get_row( 'SELECT COUNT(group_id) as GroupSay FROM '.AHMETI_WP_TIMELINE_DB_PREFIX.'ahmeti_wp_timeline WHERE type="group_name"', OBJECT );
if(empty($page) || !is_numeric($page)){
$baslangic=1;
$page=1;
}else{
$baslangic=$page;
}
$toplam_sayfa=(int)$group_say->GroupSay;
$baslangic=($baslangic-1)*$page_limit;
//$group_list = $wpdb->get_results( 'SELECT group_id,title FROM '.AHMETI_WP_TIMELINE_DB_PREFIX.'ahmeti_wp_timeline WHERE type="group_name" ORDER BY group_id DESC LIMIT '.$baslangic.','.$page_limit, ARRAY_A );
$group_list = $wpdb->get_results( 'SELECT `group_id`,`title`,
(select COUNT(`event_id`) from `'.AHMETI_WP_TIMELINE_DB_PREFIX.'ahmeti_wp_timeline` as `sub_ahmeti_wp_timeline` WHERE `sub_ahmeti_wp_timeline`.`group_id`=`wp_ahmeti_wp_timeline`.`group_id` AND `sub_ahmeti_wp_timeline`.`type`="event" ) as `event_count`
FROM `'.AHMETI_WP_TIMELINE_DB_PREFIX.'ahmeti_wp_timeline`
where `wp_ahmeti_wp_timeline`.`type` ="group_name" ORDER BY `wp_ahmeti_wp_timeline`.`group_id` DESC LIMIT '.$baslangic.','.$page_limit, ARRAY_A );
//var_dump($group_list);
//var_dump($wpdb->last_query());
if($toplam_sayfa > 0){
?>
.'/ahmeti-wp-timeline/images/edit.png'; ?>)
.'/ahmeti-wp-timeline/images/delete.png'; ?>)