SELECT `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-02-01"
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-02-01 16:00:56' and `ac`.`end_time` >= '2023-02-01 16:00:56'
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-02-01" and view_hour=16 and campaign_id=392update ad_view_stat set view_count=view_count+1 where id=1661083
SELECT `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-02-01"
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-02-01 16:00:56' and `ac`.`end_time` >= '2023-02-01 16:00:56'
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-02-01" and view_hour=16 and campaign_id=428update ad_view_stat set view_count=view_count+1 where id=1661090
BODRUMSPOR'UN KUPADAKİ RAKİBİ BELLİ OLDU...
Bodrum Belediyesi Bodrumspor Ziraat Türkiye Kupası 5. Eleme turunda MKE Ankaragücü...
Bodrum Belediyesi Bodrumspor Ziraat Türkiye Kupası 5. Eleme turunda MKE Ankaragücü ile eşleşti.
Ziraat Türkiye Kupası 5. Eleme Turu kura çekimi bugün TFF Hasan Doğan Milli Takımlar Kamp ve Eğitim Tesisleri Orhan Saka Konferans Salonu'nda gerçekleşirken, TFF 2. Lig Beyaz Grup’ta mücadele eden Bodrum Belediyesi Bodrumspor, Süper Lig ekiplerinden MKE Ankaragücü ile eşleşti.
Çift maç eleminasyon sistemine göre oynanacak Ziraat Türkiye Kupası 5. Eleme Turu'na, 4. Eleme Turu galibi 28 takım ile Galatasaray, Fenerbahçe, Medipol Başakşehir ve Akhisarspor takımları katıldı. B.B.Bodrumspor ilk karşılaşmayı kendi evinde oynayacak. İlk maçlar 4, 5 ve 6 Aralık tarihlerinde, rövanş maçları ise 18, 19 ve 20 Aralık 2018 tarihlerinde oynanacak.
TFF Hasan Doğan Milli Takımlar Kamp ve Eğitim Tesisleri Orhan Saka Konferans Salonu'nda gerçekleşen kura çekimine B.B.Bodrumspor’u temsilen kulüp yöneticisi Hüseyin Gözütok katıldı.
SELECT `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-02-01"
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-02-01 16:00:57' and `ac`.`end_time` >= '2023-02-01 16:00:57'
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-02-01" and view_hour=16 and campaign_id=494update ad_view_stat set view_count=view_count+1 where id=1661101
Özel Bodrum Hastanesi ve Bodrum Toplum Sağlığı işbirliği ile Bodrum Denizciler Derneğinde...
Anket
SELECT `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-02-01"
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-02-01 16:00:57' and `ac`.`end_time` >= '2023-02-01 16:00:57'
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-02-01" and view_hour=16 and campaign_id=499update ad_view_stat set view_count=view_count+1 where id=1661104