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 16:56:07' and `ac`.`end_time` >= '2023-01-31 16:56:07'
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=16 and campaign_id=428update ad_view_stat set view_count=view_count+1 where id=1660267
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 16:56:07' and `ac`.`end_time` >= '2023-01-31 16:56:07'
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=445checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=16 and campaign_id=445update ad_view_stat set view_count=view_count+1 where id=1660236
ARAÇTA SIKIŞAN KADIN UZUN SÜRE KURTARILAMADI
Bodrum Yalıkavak yolunda meydana gelen trafik kazasında 3 kişi yaralandı. Araçta...
Bodrum Yalıkavak yolunda meydana gelen trafik kazasında 3 kişi yaralandı. Araçta sıkışan Fatma Ünlü itfaiye ekiplerinin çalışması sonucu kurtarıldı.
Bodrum Yalıkavak yolu Yaka köy mevkiinde meydana gelen trafik kazasında Mustafa Ünlü idaresindeki 48 TC 513 plakalı araç ile Mahmut Bayzıt idaresindeki 15 NE 948 plakalı araç kafa kafaya çarpıştı. Kaza sonucu 48 TC 513 plakalı aracın sürücüsü Mustafa Ünlü, gelini Fatma Ünlü ve Gülcan Dora Ünlü yaralandı.
Araçta sıkışan Fatma Ünlü'nün kurtarılması için Bodrum Belediyesi İtfaiyesi Kurtarma aracı uzun süre çalıştı. Kazayı haber alarak olay yerine gelen Fatma Ünlü'nün eşi Ercan Ünlü sinir krizi geçirdi. Uzun süre eşinin yanında duran Ercan ünlü "Aşkım sakın bayılma, iyisin birşeyin yok" diyerek eşine yardımcı olmaya çalıştı. Zor anlar yaşayan Ercan Ünlü sağlık görevlileri ve jandarma ekipleri tarafından sakinleştirilmeye çalışıldı.
Fatma ünlünün 3 yaşındaki kızı Gülcan Dora Ünlü ise kazayı görerek duran bayanlar tarafından teselli edildi. Yaklaşık 20 dakika süren çalışma sonucu kurtarılan Fatma Ünlü Bodrum Universal Hospitalde tedavi altına alındı.
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 16:56:07' and `ac`.`end_time` >= '2023-01-31 16:56:07'
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=430checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=16 and campaign_id=430update ad_view_stat set view_count=view_count+1 where id=1660239
Konacık Belediyesi ve Kızılay Marmaris Kan Bağışı Merkezi işbirliğinde düzenlenen...
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 16:56:07' and `ac`.`end_time` >= '2023-01-31 16:56:07'
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=455checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=16 and campaign_id=455update ad_view_stat set view_count=view_count+1 where id=1660242