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:53:06' and `ac`.`end_time` >= '2023-01-28 09:53:06'
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=428checkstat select id from ad_view_stat where view_date="2023-01-28" and view_hour=09 and campaign_id=428update ad_view_stat set view_count=view_count+1 where id=1657468
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:53:06' and `ac`.`end_time` >= '2023-01-28 09:53:06'
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
KARADENİZLİLER BİR ARADA
Bodrum Karadenizliler Dayanışma Derneği'nin 1. danışma ve tanışma toplantısı gerçekleştirildi....
Bodrum Karadenizliler Dayanışma Derneği'nin 1. danışma ve tanışma toplantısı gerçekleştirildi.
Gümbet Doria Otel'de yapılan toplantıya Bodrum'da yaşayan yaklaşık 50 Karadenizli vatandaş katıldı. Saygı duruşunda bulunulması ve İstiklal Marşı'nın okunması ile başlayan toplantıya katılanlar sırayla kendilerini tanıttılar. Birbirinden farklı işkollarında yer alan katılımcıların, tanışmaları ve sohbetleri olukça sıcak bir atmosferde gerçekleşti.
Derneğin Başkanı Mustafa Berberoğlu amaçlarının Bodrum'da yaşayan Karadenizlileri bir araya getirmek olduğunu belirtti. Berberoğlu yaptığı konuşmasında şunları söyledi:
"Bodrum Yarımadası'nda yaşayan çok sayıda Karadenizli var. Bir araya gelerek yardımlaşmayı artırmak, iyi günde ve kötü günde bir arada olmak istiyoruz. Derneğimizin şu anda 50 üyesi var ama tabi ki bu sayı her geçen gün artacak" dedi. Karadenizlilerin toplantısında esprili sohbetler dikkat çekerken, toplantının yapıldığı salonda zaman zaman gülüşmeler yaşandı.
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:53:06' and `ac`.`end_time` >= '2023-01-28 09:53:06'
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-28" and view_hour=09 and campaign_id=207update ad_view_stat set view_count=view_count+1 where id=1657492
Bodrumspor, Antalyaspor'un hücum oyuncusu Gökdeniz Bayrakdar'ı sezon sonuna kadar...
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:53:06' and `ac`.`end_time` >= '2023-01-28 09:53:06'
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-28" and view_hour=09 and campaign_id=330update ad_view_stat set view_count=view_count+1 where id=1657493