SELECT `ac`.`id`, `ac`.`banner_text`, `ac`.`banner_url`, `ac`.`hash` as `banner_hash`, `images`.`image_728x150` as `banner`, `images`.`image_default` as `image_default`, `images`.`id` as `image_id`, sum(ad_view_stat.view_count) as view_counts, `alt_banner`.`image_default` as `alt_banner`, `ac`.`kapanma_zamani`, `ac`.`gosterilmeme_suresi`, `ac`.`ad_campaign_type`, `ac`.`banner_script`
FROM `ad_campaigns` as `ac`
JOIN `ad_view_stat` ON `ad_view_stat`.`campaign_id`=`ac`.`id` and `view_date`="2023-01-31"
JOIN `ad_customers` ON `ad_customers`.`id`=`ac`.`customer_id` and `ad_customers`.`active`=1
JOIN `images` ON `images`.`id`=`ac`.`post_image_id`
LEFT JOIN `images` as `alt_banner` ON `alt_banner`.`id`=`ac`.`alternatif_banner`
WHERE `ac`.`banner_size_id` = 1
AND `ac`.`start_time` <= '2023-01-31 16:32:46' and `ac`.`end_time` >= '2023-01-31 16:32:46'
AND `ac`.`deleted` = 0
AND `ac`.`active` = 1
GROUP BY `ad_view_stat`.`campaign_id`
ORDER BY `view_counts` ASC
LIMIT 1update ad_campaigns set views=views+1 where id=453checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=16 and campaign_id=453update ad_view_stat set view_count=view_count+1 where id=1660240
SELECT `ac`.`id`, `ac`.`banner_text`, `ac`.`banner_url`, `ac`.`hash` as `banner_hash`, `images`.`image_728x150` as `banner`, `images`.`image_default` as `image_default`, `images`.`id` as `image_id`, sum(ad_view_stat.view_count) as view_counts, `alt_banner`.`image_default` as `alt_banner`, `ac`.`kapanma_zamani`, `ac`.`gosterilmeme_suresi`, `ac`.`ad_campaign_type`, `ac`.`banner_script`
FROM `ad_campaigns` as `ac`
JOIN `ad_view_stat` ON `ad_view_stat`.`campaign_id`=`ac`.`id` and `view_date`="2023-01-31"
JOIN `ad_customers` ON `ad_customers`.`id`=`ac`.`customer_id` and `ad_customers`.`active`=1
JOIN `images` ON `images`.`id`=`ac`.`post_image_id`
LEFT JOIN `images` as `alt_banner` ON `alt_banner`.`id`=`ac`.`alternatif_banner`
WHERE `ac`.`banner_size_id` = 1
AND `ac`.`start_time` <= '2023-01-31 16:32:46' and `ac`.`end_time` >= '2023-01-31 16:32:46'
AND `ac`.`deleted` = 0
AND `ac`.`active` = 1
GROUP BY `ad_view_stat`.`campaign_id`
ORDER BY `view_counts` ASC
LIMIT 1update ad_campaigns set views=views+1 where id=497checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=16 and campaign_id=497update ad_view_stat set view_count=view_count+1 where id=1660244
BAYRAMI KOŞARAK KUTLADILAR
19 Mayıs 6. Geleneksel Atatürk Koşusu Bitez'de yapıldı. Ulu Önder Mustafa Kemal...
19 Mayıs 6. Geleneksel Atatürk Koşusu Bitez'de yapıldı. Ulu Önder Mustafa Kemal Atatürk'ün Samsuna çıkışının 87. yılında, Bitez Belediyesi'nin organizasyonuyla 19 Mayıs 6. Geleneksel Atatürk koşusu gerçekleştirildi...
Öğleden sonra yapılan ve 230 sporcunun katılımıyla gerçekleşen koşuda, Bitez Belediye Başkanı M. Remzi Güngör, meclis üyeleri Can Çelikyürek ve Hasan Hüseyin Eskici de koştu. Bitez sahilinde yapılan Atatürk Koşusu, spor tesislerinde sona erdi...
5 kategoride yarışan sporcular koşu sonrası yapılan ödül töreni ile ödüllerini aldılar. Bitez Belediye Başkanı M. Remzi Güngör, geleneksel hale gelen koşunun her yıl devam edeceğini, geçen yıllarda olduğu gibi yine dostluk içinde geçtiğini söyledi...
13 yaş altı bayanlar da Özlem Yıldız, erkeklerde Süleyman Çelik, 13-16 yaş arası erkeklerde Güneş Suyabatmaz, 16 - 25 yaş arası erkeklerde İsa Çakıcı, 25-35 yaş arası bayanlarda Sadika Çelik, erkeklerde Murat Karabaş, 25-35 yaş arası bayanlarda Elmas Aşçıoğlu, erkeklerde Ufuk Arıdıcı ve 35 yaş üstü erkeklerde Nasfet Eristay birinci oldular...
SELECT `ac`.`id`, `ac`.`banner_text`, `ac`.`banner_url`, `ac`.`hash` as `banner_hash`, `images`.`image_320x320` as `banner`, `images`.`image_default` as `image_default`, `images`.`id` as `image_id`, sum(ad_view_stat.view_count) as view_counts, `alt_banner`.`image_default` as `alt_banner`, `ac`.`kapanma_zamani`, `ac`.`gosterilmeme_suresi`, `ac`.`ad_campaign_type`, `ac`.`banner_script`
FROM `ad_campaigns` as `ac`
JOIN `ad_view_stat` ON `ad_view_stat`.`campaign_id`=`ac`.`id` and `view_date`="2023-01-31"
JOIN `ad_customers` ON `ad_customers`.`id`=`ac`.`customer_id` and `ad_customers`.`active`=1
JOIN `images` ON `images`.`id`=`ac`.`post_image_id`
LEFT JOIN `images` as `alt_banner` ON `alt_banner`.`id`=`ac`.`alternatif_banner`
WHERE `ac`.`banner_size_id` = 3
AND `ac`.`start_time` <= '2023-01-31 16:32:46' and `ac`.`end_time` >= '2023-01-31 16:32:46'
AND `ac`.`deleted` = 0
AND `ac`.`active` = 1
GROUP BY `ad_view_stat`.`campaign_id`
ORDER BY `view_counts` ASC
LIMIT 1update ad_campaigns set views=views+1 where id=509checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=16 and campaign_id=509update ad_view_stat set view_count=view_count+1 where id=1660247
BESİAD geleneksel Perşembe toplantılarının bu haftaki konuğu CHP 1. Sıra Milletvekili...
Anket
SELECT `ac`.`id`, `ac`.`banner_text`, `ac`.`banner_url`, `ac`.`hash` as `banner_hash`, `images`.`image_320x320` as `banner`, `images`.`image_default` as `image_default`, `images`.`id` as `image_id`, sum(ad_view_stat.view_count) as view_counts, `alt_banner`.`image_default` as `alt_banner`, `ac`.`kapanma_zamani`, `ac`.`gosterilmeme_suresi`, `ac`.`ad_campaign_type`, `ac`.`banner_script`
FROM `ad_campaigns` as `ac`
JOIN `ad_view_stat` ON `ad_view_stat`.`campaign_id`=`ac`.`id` and `view_date`="2023-01-31"
JOIN `ad_customers` ON `ad_customers`.`id`=`ac`.`customer_id` and `ad_customers`.`active`=1
JOIN `images` ON `images`.`id`=`ac`.`post_image_id`
LEFT JOIN `images` as `alt_banner` ON `alt_banner`.`id`=`ac`.`alternatif_banner`
WHERE `ac`.`banner_size_id` = 3
AND `ac`.`start_time` <= '2023-01-31 16:32:46' and `ac`.`end_time` >= '2023-01-31 16:32:46'
AND `ac`.`deleted` = 0
AND `ac`.`active` = 1
GROUP BY `ad_view_stat`.`campaign_id`
ORDER BY `view_counts` ASC
LIMIT 1update ad_campaigns set views=views+1 where id=359checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=16 and campaign_id=359update ad_view_stat set view_count=view_count+1 where id=1660262