Banner ad space:headerSELECT `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-27"
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-27 03:29:12' and `ac`.`end_time` >= '2023-01-27 03:29:12'
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-01-27" and view_hour=03 and campaign_id=453update ad_view_stat set view_count=view_count+1 where id=1656421
Banner ad space:headerSELECT `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-27"
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-27 03:29:12' and `ac`.`end_time` >= '2023-01-27 03:29:12'
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-01-27" and view_hour=03 and campaign_id=492update ad_view_stat set view_count=view_count+1 where id=1656422
DAĞDA KAYBOLAN 3 KARDEŞ KURTARILDI
Datça'da dağ yürüyüşü yapan, ancak yollarını kaybeden 3 kardeş, jandarma ekiplerince...
Datça'da dağ yürüyüşü yapan, ancak yollarını kaybeden 3 kardeş, jandarma ekiplerince bulunup kurtarıldı.
Datça ilçe merkezinden Marmaris'e gitmek üzere dağ yürüyüşü rotası belirleyen Şamil Kurt (18), Muhammed Ali Kurt (23) ve Abidin Kurt (33) kardeşler, dün öğleden sonra İskele Mahallesi'nden yola çıktı. Dağlık arazide ilerleyen gençler, Datça ilçe merkezine 30 kilometre mesafedeki Hurmalıbük Koyu yakınlarındaki bir tepede geceyi geçirdi. Sabah tekrar yola devam eden 3 kardeş, bir süre sonra yolu kaybetti. Saat 09.00'da, 112 Acil Çağrı Merkezi'ni arayıp kaybolduğunu söyleyen Şamil Kurt, Muhammed Ali Kurt ve Abidin Kurt, yardım istedi. Bölgeye jandarma ekipleri sevk edildi. Bölgede arama çalışması başlatan jandarma ekipleri, bugün saat 16.00'da, gençlerin yerini belirledi.
Karayolu olmadığı için denizden sahil güvenlik ekiplerinin desteğiyle kurtarılan gençler, ilçe merkezine getirildi. Kardeşlerden Şamil Kurt ve Abidin Kurt, açlık ve susuzluktan etkilendikleri için kontrol amaçlı Datça Devlet Hastanesi'ne kaldırıldı. Kardeşlerin sağlık durumunun iyi olduğu belirtildi.
Banner ad space:sidebar_topSELECT `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-27"
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-27 03:29:12' and `ac`.`end_time` >= '2023-01-27 03:29:12'
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-01-27" and view_hour=03 and campaign_id=502update ad_view_stat set view_count=view_count+1 where id=1656419
Bodrum Kaymakamlığı ve İlçe Milli Eğitim Müdürlüğü tarafından düzenlenen bilgi yarışmasının...
Anket
Banner ad space:sidebar_bottomSELECT `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-27"
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-27 03:29:12' and `ac`.`end_time` >= '2023-01-27 03:29:12'
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-01-27" and view_hour=03 and campaign_id=509update ad_view_stat set view_count=view_count+1 where id=1656420