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 14:48:30' and `ac`.`end_time` >= '2023-02-01 14:48:30'
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=453checkstat select id from ad_view_stat where view_date="2023-02-01" and view_hour=14 and campaign_id=453update ad_view_stat set view_count=view_count+1 where id=1661025
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 14:48:30' and `ac`.`end_time` >= '2023-02-01 14:48:30'
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=492checkstat select id from ad_view_stat where view_date="2023-02-01" and view_hour=14 and campaign_id=492update ad_view_stat set view_count=view_count+1 where id=1661029
ÇÖP KONTEYNERLERİ YENİLENİYOR
Bodrum Belediyesi ekipleri, yaz sezonu öncesi Bodrum yarımadası genelindeki eskiyen...
Bodrum Belediyesi ekipleri, yaz sezonu öncesi Bodrum yarımadası genelindeki eskiyen çöp konteynerlerini yenileri ile değiştirmek için çalışma başlattı.
Bodrum Belediyesi Temizlik İşleri Müdürlüğü tarafından ihalesi yapılarak satın alma işlemleri gerçekleştirilen 2000'e yakın yeni konteynerlerin ilçe genelinde dağıtımı yapılıyor. Çalışmalar kapsamında galvanizden yapılmış modern görünümlü konteynerler, eskileriyle değiştiriliyor.
Uzun yıllardır kullanılarak defalarca boyama işleminden geçmiş çöp konteynerlerinin bazılarının kullanım ömrünü tamamlaması nedeniyle doğan ihtiyacın giderildiğini ifade eden yetkililer, yarımada genelinde yaklaşık 9 bin çöp konteyneri bulunduğunu belirttiler.
Yetkiler ayrıca ihtiyaç kapsamında yapılacak yeni satın almalarla eksiklerin giderileceğini, eskiyen ve kullanılamaz durumda olan konteynerlerin en kısa sürede yenileri ile değiştirileceğini açıkladılar.
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 14:48:30' and `ac`.`end_time` >= '2023-02-01 14:48:30'
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-02-01" and view_hour=14 and campaign_id=359update ad_view_stat set view_count=view_count+1 where id=1661012
Uzun süredir problem yaşanan Bodrum Gümüşlük yolu Peksimet Köyü mevkiinde başlatılan...
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 14:48:30' and `ac`.`end_time` >= '2023-02-01 14:48:30'
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-02-01" and view_hour=14 and campaign_id=394update ad_view_stat set view_count=view_count+1 where id=1661015