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:04:37' and `ac`.`end_time` >= '2023-02-01 16:04:37'
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=16 and campaign_id=500update ad_view_stat set view_count=view_count+1 where id=1661105
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:04:37' and `ac`.`end_time` >= '2023-02-01 16:04:37'
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=16 and campaign_id=507update ad_view_stat set view_count=view_count+1 where id=1661108
Tatil için geldiği Bodrum'da girdiği havuz genç Zeynep'in sonu oldu.
Kısa süre önce tatil için Bodrum'a gelen 20 yaşındaki Zeynep Kabakçıoğlu tedavi gördüğü hastanedeki yaşam savaşını kaybetti.
Önceki gün Gümbet Mahallesindeki bir otelin havuzunda yüzdüğü sırada boğulan ve sağlık ekiplerinin yoğun çabası sonrası hayata döndürülerek Özel Bodrum Hastanesinde tedavi altına alınan Kabakçıoğlu, sabaha karşı hayatını kaybetti. Hastanenin yoğun bakım ünitesinde tutulan genç Zeynep yapılan tüm müdahalelere rağmen kurtarılamadı.
Yetiştirme Yurdunda büyüdüğü öğrenilen ve birkaç arkadaşı ile tatil için ilçeye gelen Zeynep'in cenazesi, Bodrum Belediyesi Cenaze Hizmetleri Birimine ait araçla Özel Bodrum Hastanesi Morgundan alınarak polis nezaretinde Muğla-Yerkesik Adli Tıp Kurumuna gönderildi.
Adli Tıp Kurumun'da kesin ölüm nedeni belirlenecek olan Zeynep Kabakçıoğlu'nun 7 Mayıs Cumartesi gününün de doğum günü olduğu öğrenildi. Talihsiz gencin ölümüyle ilgili soruşturmanın devam ettiği bildirildi.
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:04:37' and `ac`.`end_time` >= '2023-02-01 16:04:37'
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
Ö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:04:37' and `ac`.`end_time` >= '2023-02-01 16:04:37'
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