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:12:44' and `ac`.`end_time` >= '2023-02-01 16:12:44'
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=16 and campaign_id=492update ad_view_stat set view_count=view_count+1 where id=1661099
İRLANDALI TURİSTİ HAYATTA TUTABİLMEK İÇİN SEFERBER OLDULAR
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:12:44' and `ac`.`end_time` >= '2023-02-01 16:12:44'
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=497checkstat select id from ad_view_stat where view_date="2023-02-01" and view_hour=16 and campaign_id=497update ad_view_stat set view_count=view_count+1 where id=1661102
İRLANDALI TURİSTİ HAYATTA TUTABİLMEK İÇİN SEFERBER OLDULAR
Önceki gün akşam üzeri saatlerinde Gümbet Koyunda boğulma tehlikesi atlatan İrlandalı...
Önceki gün akşam üzeri saatlerinde Gümbet Koyunda boğulma tehlikesi atlatan İrlandalı turist, çevredeki duyarlı vatandaşlar ve ilk yardım ekiplerinin yoğun çabası sonucu ölümden döndü.
Tatilini geçirmek üzere Bodrum'a gelen 66 yaşındaki İrlanda uyruklu Elizabeth Devay isimli turist Gümbet Koyunda kaldığı otelin plajında denize girdi. Bir süre suda kalan Devay'ın suda çırpındığını gören otel personeli hemen denize girerek yaşlı turisti kıyıya çıkardılar.
Olay yerine gelen 112 İlk yardım ekipleri İrlandalı kadını hayatta tutabilmek için uzun süre müdahale ettiler. Elizabeth Devay'e kaldırıldığı Bodrum Devlet Hastanesi Acil Polikliniğinde de bir süre müdahale edildi. Devay'a burada yapılan müdahaleden sonra tedavisine devam edilmek üzere Özel Bodrum Hastanesi'ne sevk edildiği ve yoğun bakım servisine alındığı öğrenildi.
Edinilen bilgilere göre yoğun bakım servisine kaldırılan İrlandalı turistin hayati tehlikesinin ise devam ediyor.
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:12:44' and `ac`.`end_time` >= '2023-02-01 16:12:44'
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=16 and campaign_id=502update ad_view_stat set view_count=view_count+1 where id=1661107
TÜSİAD Yönetim Kurulu Başkanı Ümit Boyner, ''Toplumsal barışın önünde engel olan...
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:12:44' and `ac`.`end_time` >= '2023-02-01 16:12:44'
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=16 and campaign_id=509update ad_view_stat set view_count=view_count+1 where id=1661110