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

Etiket: tedbirler

Gündem

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!

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