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:40:14' and `ac`.`end_time` >= '2023-01-27 03:40:14'
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-27" and view_hour=03 and campaign_id=428update ad_view_stat set view_count=view_count+1 where id=1656447
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:40:14' and `ac`.`end_time` >= '2023-01-27 03:40:14'
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
2. AYAK YARIŞLARI TAMAMLANDI
CFM-BAYK Kış Trofesi'nin 2. Ayak yarışları önceki gün düzenlenen ikinci gün yarışlarıyla...
CFM-BAYK Kış Trofesi'nin 2. Ayak yarışları önceki gün düzenlenen ikinci gün yarışlarıyla tamamlandı.
Bodrum Açık Deniz Yelken Kulübü (BAYK) tarafından düzenlenen CFM-BAYK Kış Trofesi'nin 2. Ayak yarışları Türkiye’nin farklı illerinden 50 teknede 450 sporcunun katılımıyla yapıldı.
Her ayağı iki günden oluşan organizasyonun Cumartesi günkü ilk gün yarışları şiddetli rüzgar sebebiyle yapılamamıştı. İkinci gün yarışlarında tekneler IRC-A, IRC-B ve destek olmak üzere üç sınıfta mücadele etti.
Öğle saat 12.00 sularında Bodrum Kalesi açıklarında yerlerini alan tekneler start verilmesiyle yelkenlerini açtı. IRC-A sınıfında yarışanlar Karaada önlerinde kurulan parkurda yaklaşık 8.4 millik şamandıra rotada, diğer iki sınıfta mücadele edenler ise 17 millik Bodrum-Çelebi Adası- Bodrum rotasında yelken mücadele etti. Zaman zaman şiddetini arttıran rüzgar yarışmacılara zorlarken, yarışların başlangıç hattında ve şamandıralar dönülürken teknelerin birbirine yakın ilerlemesi heyecanlı anlar yaşattı.
Dereceye girenlere ödülleri 3-4 Mart'ta yapılacak üçüncü ayak organizasyonunda verilecek.
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:40:14' and `ac`.`end_time` >= '2023-01-27 03:40:14'
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:40:14' and `ac`.`end_time` >= '2023-01-27 03:40:14'
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