Banner ad space:headerSELECT `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-28"
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-28 09:25:44' and `ac`.`end_time` >= '2023-01-28 09:25:44'
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=445checkstat select id from ad_view_stat where view_date="2023-01-28" and view_hour=09 and campaign_id=445update ad_view_stat set view_count=view_count+1 where id=1657471
Banner ad space:headerSELECT `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-28"
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-28 09:25:44' and `ac`.`end_time` >= '2023-01-28 09:25:44'
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=446checkstat select id from ad_view_stat where view_date="2023-01-28" and view_hour=09 and campaign_id=446update ad_view_stat set view_count=view_count+1 where id=1657472
YERLİ MALI ETKİNLİKLERİ
Yerli Malı Haftası çerçevesinde CHP Kadın Kolları tarafından etkinlikler düzenlendi....
Yerli Malı Haftası çerçevesinde CHP Kadın Kolları tarafından etkinlikler düzenlendi. Belediye Meydanı'nda düzenlenen yerli malı pazarına, Çomakdağ ve Karaova (Mumcular) köylüleri, el işleri, çeşitli yiyecekler ve yetiştirdikleri ürünlerle katıldı. Pazara vatandaşlar büyük ilgi gösterdi. Pazarın ardından Bodrum Belediyesi Meclis Salonu'nda CHP Kadın Kolları üyelerinin düzenlediği "Küreselleşme ve AB Sürecinde Yerli Malı" konulu söyleşi düzenlendi. Prof. Dr. Gürhan Çağlayan ile Ulusal Sanayici ve İş Adamları Derneği Ankara Şubesi Başkanı Cemal Çoban'ın konuşmacı olarak katıldığı söyleşiye partililer, sivil toplum kuruluşu temsilcileri ve çok sayıda vatandaş ilgi gösterdi. Barkovizyon eşliğinde katılımcılara "Küreselleşme ve AB Sürecinde Yerli Malı" hakkında bilgiler verildi. Yaklaşık olarak iki saat süren konuşmaların ardından söyleşi, katılımcıların soruları ve konuşmacıların cevapları ile son buldu.
Banner ad space:sidebar_topSELECT `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-28"
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-28 09:25:44' and `ac`.`end_time` >= '2023-01-28 09:25:44'
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=430checkstat select id from ad_view_stat where view_date="2023-01-28" and view_hour=09 and campaign_id=430update ad_view_stat set view_count=view_count+1 where id=1657469
Bodrum’da önceki gün Bitez'de çıkan yangınla ilgili gözaltına alınan şüpheli, adli...
Anket
Banner ad space:sidebar_bottomSELECT `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-28"
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-28 09:25:44' and `ac`.`end_time` >= '2023-01-28 09:25:44'
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=455checkstat select id from ad_view_stat where view_date="2023-01-28" and view_hour=09 and campaign_id=455update ad_view_stat set view_count=view_count+1 where id=1657470
