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-01-31"
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-31 17:18:55' and `ac`.`end_time` >= '2023-01-31 17:18:55'
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-31" and view_hour=17 and campaign_id=392update ad_view_stat set view_count=view_count+1 where id=1660280
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-01-31"
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-31 17:18:55' and `ac`.`end_time` >= '2023-01-31 17:18:55'
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-31" and view_hour=17 and campaign_id=428update ad_view_stat set view_count=view_count+1 where id=1660295
GÜMBET PLAJI DAHA GÜVENLİ OLACAK
Gümbet Plajı'nda denize girilen bölgede artık motorlu taşıt bulunmayacak. Bodrum...
Gümbet Plajı'nda denize girilen bölgede artık motorlu taşıt bulunmayacak. Bodrum Belediyesi Liman İşletme Müdürlüğü Gümbet Plajı'na 1.5 kilometre uzunluğunda güvenlik şeridi çekti...
Gümbet Mahallesi'nden Sorumlu Belediye Meclis Üyesi Orhan Kavala, Bodrum'un Gümbet Plajı'nda güvenlik tedbirlerinin artırıldığını, bu kapsamda denize 1.5 kilometre uzunluğunda güvenlik şeridi çekildiğini söyledi. Güvenlik şeridinin motorlu araçların plajda yaratabileceği riskleri ortadan kaldırmak amacıyla çekildiğini vurgulayan Kavala, güvenlik şeridinden 6 metre genişliğinde bir çıkış olacağını ve tüm motorlu taşıtların bu çıkışı kullanacağını söyledi...
Denize konulan sarı dubalara uyarı levhalarının yerleştirileceğini belirten Kavala, 'Hem şeridin iç kısmından hem de dış kısmından bu uyarılar görülebilecek. Böylece uygulamada her hangi bir olumsuzluğun yaşanmasının önüne geçilecek' şeklinde konuştu...
Güvenlik şeridi Bodrum Belediyesi Liman İşletme Müdürlüğü, Zabıta, Sahil Güvenlik ve Su Sporları Komisyonu tarından sürekli denetlenecek. Kurala uymayanlara ise cezai yaptırım uygulanacak...
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-01-31"
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-31 17:18:55' and `ac`.`end_time` >= '2023-01-31 17:18:55'
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=359checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=17 and campaign_id=359update ad_view_stat set view_count=view_count+1 where id=1660283
Ünlü Sanatçı Kıraç, Konacık Uluslararası Pedasa Tarih Kültür ve Sanat Festivali...
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-01-31"
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-31 17:18:56' and `ac`.`end_time` >= '2023-01-31 17:18: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=394checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=17 and campaign_id=394update ad_view_stat set view_count=view_count+1 where id=1660285