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:43:46' and `ac`.`end_time` >= '2023-01-27 03:43: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=445checkstat select id from ad_view_stat where view_date="2023-01-27" and view_hour=03 and campaign_id=445update ad_view_stat set view_count=view_count+1 where id=1656417
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:43:46' and `ac`.`end_time` >= '2023-01-27 03:43: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=446checkstat select id from ad_view_stat where view_date="2023-01-27" and view_hour=03 and campaign_id=446update ad_view_stat set view_count=view_count+1 where id=1656418
TÜRK HALK OYUNLARI TÜRKİYE FİNALİ
Başbakanlık Gençlik ve Spor Müdürlüğü'nce düzenlenen "Gençlik Merkezleri Arası Türk...
Başbakanlık Gençlik ve Spor Müdürlüğü'nce düzenlenen "Gençlik Merkezleri Arası Türk Halk Oyunları Türkiye Finali" Bodrum'da başladı. BOFAD ve Sunu Organizasyon'ca organize edilen yarışma öncesinde Milta Marina önünden Bodrum Kalesi'ne kadar kortej yürüyüşü gerçekleştirildi. Halkoyunları ekipleri yürüyüşün ardından Bodrum Kalesi Kuzey Hendeği'nde gösterilerini sundular. Düzenlemeli Ekipler dalında yapılan stilize yarışmada, Barlar kategorisinde Sivas Gençlik Merkezi, Horonda Trabzon Vakfıkebir Gençlik Merkezi, Karşılamada Bursa Yunus Emre Gençlik Merkezi, Zeybekte Manisa Gençlik Merkezi, Karmada Burdur Gençlik Merkezi birinci olurken Halay kategorisinde ise Diyarbakır ve Siirt gençlik merkezleri birinciliği paylaştılar. Halkoyunları uzmanı 10 kişinin hakemliğinde yapılan yarışmayı yaklaşık bin kişi izledi. Yarışmanın ikinci gününde ise düzenlemesiz ekipler Bodrum Belediyesi Binnaz Karakaya Spor Salonu'nda gösterilerini sundular. İkinci günde ise geleneksel dalda gösteriler sunuldu.
Sadece salonda değil, oyunlar dışarda da sürdü. Gençlik Merkezleri Arası Türk Halk Oyunları Türkiye Finali'ne Ağrı, Afyonkarahisar, Amasya, Antalya, Artvin, Aydın, Bayburt, Bingöl, Bitlis, Bolu, Bursa, Burdur, Çanakkale, Diyarbakır, Denizli, Edirne, Hakkari, Kahramanmaraş, Karaman, Kütahya, Siirt, Sivas, Şanlıurfa,Trabzon, Maçka, Van, ve Zonguldak'tan ekipler katıldı.
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:43:46' and `ac`.`end_time` >= '2023-01-27 03:43: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=494checkstat select id from ad_view_stat where view_date="2023-01-27" and view_hour=03 and campaign_id=494update ad_view_stat set view_count=view_count+1 where id=1656445
BAYK (Bodrum Açıkdeniz Yelken Kulübü) yarış takviminin son yarışı olan Milta Bodrum...
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:43:46' and `ac`.`end_time` >= '2023-01-27 03:43: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=499checkstat select id from ad_view_stat where view_date="2023-01-27" and view_hour=03 and campaign_id=499update ad_view_stat set view_count=view_count+1 where id=1656446