© Copyright 2022 | Kayın Yayıncılık Radyo Televizyon A.Ş.

  1. Ana Sayfa
  2. tedbirler

Etiket: tedbirler

Gündem
Koronavirüs Önlemleri Genişletildi!

Koronavirüs Önlemleri Genişletildi!

İçişleri Bakanlığı, 81 İl Valiliğine “Koronavirüs Tedbirleri” konulu ek bir genelge daha gönderdi. Son genelge ile faaliyetleri geçici...

Gündem
Torba'ya Termal Kamera Önerisi!

Torba'ya Termal Kamera Önerisi!

Bodrum’da yaşayan kimi vatandaşlar, olası koronavirüs taşıyıcılarının Bodrum'a girerken tespiti için Torba Uygulama Noktası’nda termal...

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` = 2 AND `ac`.`start_time` <= '2023-01-31 07:20:55' and `ac`.`end_time` >= '2023-01-31 07:20:55' 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=493checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=07 and campaign_id=493update ad_view_stat set view_count=view_count+1 where id=1659930
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` = 2 AND `ac`.`start_time` <= '2023-01-31 07:20:55' and `ac`.`end_time` >= '2023-01-31 07:20:55' 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=498checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=07 and campaign_id=498update ad_view_stat set view_count=view_count+1 where id=1659931
D