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-27"
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-27 03:48:25' and `ac`.`end_time` >= '2023-01-27 03:48:25'
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=507checkstat select id from ad_view_stat where view_date="2023-01-27" and view_hour=03 and campaign_id=507update ad_view_stat set view_count=view_count+1 where id=1656441
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-27"
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-27 03:48:25' and `ac`.`end_time` >= '2023-01-27 03:48:25'
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=392checkstat select id from ad_view_stat where view_date="2023-01-27" and view_hour=03 and campaign_id=392update ad_view_stat set view_count=view_count+1 where id=1656414
COŞKU DOLU UZUN GÜN
Bugün erken saatlerde Bodrum Şehir Stadı'nda başlayan "23 Nisan Ulusal Egemenlik...
Bugün erken saatlerde Bodrum Şehir Stadı'nda başlayan "23 Nisan Ulusal Egemenlik ve Çocuk Bayramı" kutlamaları oldukça renkli geçti. Kutlamalara Bodrum Kaymakamı Abdullah Kalkan, Bodrum Belediye Başkanı Mazlum Ağan, Garnizon Komutanı Kıdemli Albay Çağatay Erdoğan, İlçe Emniyet Müdürü Yılmaz Özden, çeşitli siyasi parti ve sivil toplum örgütü temsilcileri katıldı. Hep bir ağızdan söylenen İstiklal Marşı'nın ardından günün anlam ve önemini belirten konuşmalar yapıldı ve törenlere geçildi. Yarımada'daki çeşitli okullardan gelen öğrencilerin yaptığı gösteriler ilgiyle izlendi.Aylardır 23 Nisan kutlamalarına hazırlanan öğrenciler gösterilerini başarıyla sundular. İlköğretim okullarında okuyan öğrencilerin hazırladıkları gösteriler, Bodrum Şehir Stadı'nda yaklaşık 3 bin kişi tarafından izlendi. Çeşitli kutlamalarla devam eden tören, öğle saatlerinde 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-27"
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-27 03:48:25' and `ac`.`end_time` >= '2023-01-27 03:48:25'
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=207checkstat select id from ad_view_stat where view_date="2023-01-27" and view_hour=03 and campaign_id=207update ad_view_stat set view_count=view_count+1 where id=1656423
Bodrum'da çıkan kavgada 1 kişi bıçakla yaralandı. Bodrum Artemis caddesinde meydana...
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-27"
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-27 03:48:25' and `ac`.`end_time` >= '2023-01-27 03:48:25'
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=330checkstat select id from ad_view_stat where view_date="2023-01-27" and view_hour=03 and campaign_id=330update ad_view_stat set view_count=view_count+1 where id=1656424
