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 15:54:58' and `ac`.`end_time` >= '2023-01-31 15:54:58'
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=15 and campaign_id=445update ad_view_stat set view_count=view_count+1 where id=1660235
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 15:54:58' and `ac`.`end_time` >= '2023-01-31 15:54:58'
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=446checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=15 and campaign_id=446update ad_view_stat set view_count=view_count+1 where id=1660205
GÖKOVA KİRLENİYOR
İstanbul Üniversitesi Su Ürünleri Fakültesi Akdeniz'in ardından Ege'de de araştırma...
İstanbul Üniversitesi Su Ürünleri Fakültesi Akdeniz'in ardından Ege'de de araştırma yapmak üzere Bodrum'dan ayrıldı. Türk gemisinin ilk kez Suriye karasularında araştırma yaptığı çalışmanın devamı olarak Yunus S gemisi Ege'ye açıldı.
İstanbul Üniversitesi Su Ürünleri Fakültesi'ne ait 1994 yapımı 'Yunus-S' adlı gemi ile Suriye ve Kuzey Kıbrıs Türk Cumhuriyeti'nde araştırma yapan ekip Ege'ye açıldı. Sabah saatlerinde Bodrum Limanı'ndan çıkan gemide bulunan Prof.Dr. Bayram Öztürk, Doç.Dr. Yelde Aktan, Yrd.Doç.Dr. Bülent Topaloğlu, Yrd.Doç.Dr. Ayhan Dede, Yrd.Doç.Dr. Çetin Keskin ve Dr. Mine Çardak araştırmalara başladı.
Çalışmalar kapsamında Ege Denizi'nde yaşayan balık türlerinin tespitinin yapılacağını ifade eden Prof.Dr. Bayram Öztürk, " Ayrıca su kirlenme oranları, denizde bulunan bakteri miktarı, denizde petrol kirliliği ve suyun ısınma oranı gibi konularda araştırma yapacağız" dedi.
Yapılan çalışmalarda özellikle Bodrum ve Gökova'da yoğun bir kirlenme tespit edildiğini söyleyen Öztürk, " Bence bölgedeki belediyeler bir an önce arıtma tesislerini faaliyete geçirmeli. Ben şahsen uzun yıllardır bu bölgeye tatile gelmiyorum" şeklinde konuştu.
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 15:54:58' and `ac`.`end_time` >= '2023-01-31 15:54:58'
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=494checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=15 and campaign_id=494update ad_view_stat set view_count=view_count+1 where id=1660231
Turizm sektörünün en önemli buluşma noktalarından biri olan Travel Turkey İzmir...
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 15:54:58' and `ac`.`end_time` >= '2023-01-31 15:54:58'
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=499checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=15 and campaign_id=499update ad_view_stat set view_count=view_count+1 where id=1660232