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 18:30:48' and `ac`.`end_time` >= '2023-02-01 18:30:48'
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=500checkstat select id from ad_view_stat where view_date="2023-02-01" and view_hour=18 and campaign_id=500update ad_view_stat set view_count=view_count+1 where id=1661173
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 18:30:48' and `ac`.`end_time` >= '2023-02-01 18:30:48'
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=507checkstat select id from ad_view_stat where view_date="2023-02-01" and view_hour=18 and campaign_id=507update ad_view_stat set view_count=view_count+1 where id=1661176
İSLAMHANELERİ YOLUNDA BİR CAN DAHA GİTTİ!
Sabah saatlerinde İslamhaneleri'nde meydana gelen trafik kazasında okula gitmek...
Sabah saatlerinde İslamhaneleri'nde meydana gelen trafik kazasında okula gitmek için yola çıkan bir gencin hayatını kaybettiği öğrenildi. Kazanın ardından mahalle halkı yolu çift taraflı olarak ulaşıma kapattı.
Daha önce de birçok ölümlü kazanın meydana geldiği İslamhaneleri mahallesinde bu sabah yine talihsiz bir kaza yaşandı. Okula gitmek için evden çıkıp yolun karşısına
geçmeye çalışırken bir aracın çarptığı 14 yaşındaki bir çocuk kaldırıldığı Acıbadem Hastanesi'nde yapılan tüm müdahalelere rağmen kurtarılamayarak yaşamını yitirdi.
Kazanın ardından İslamhaneleri halkı, Turgutreis-Bodrum yolunu çift yönlü olarak trafiğe kapattı. Yolda kilometrelerce araç kuyruğu oluştu. Bölgeye Bodrum Kaymakamı
Dr. Mehmet Gödekmerdan da gitti.
Uzun uğraşların sonunda ikna olan mahalle halkı yolu yeniden trafiğe açtı.Mahalle halkı geçtiğimiz yıllarda da benzer bir kazanın ardından yolu trafiğe kapatmış ve
bölgede kalıcı önlemler alınmasını talep etmişti.
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 18:30:48' and `ac`.`end_time` >= '2023-02-01 18:30:48'
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=502checkstat select id from ad_view_stat where view_date="2023-02-01" and view_hour=18 and campaign_id=502update ad_view_stat set view_count=view_count+1 where id=1661175
Bodrum’da yaşayan 76 yaşındaki Nurten Güzelköylü, evinin bahçesinde bulunan ve yaklaşık...
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 18:30:48' and `ac`.`end_time` >= '2023-02-01 18:30:48'
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=509checkstat select id from ad_view_stat where view_date="2023-02-01" and view_hour=18 and campaign_id=509update ad_view_stat set view_count=view_count+1 where id=1661178