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

Etiket: kesin korunacak hassas alan

Gündem

Kesin Korunacak Hassas Alan Oldu!

Bodrum’da 3 mahalle sınırları içerisindeki bazı alanların, Resmi Gazete'de yayımlanan Cumhurbaşkanı Karanamesi ile "Kesin Korunacak...

Güzel Haberler

Küdür Yarımadası Kurtuldu!..

Yalıkavak Küdür Yarımadası 'kesin korunacak hassas alan' olarak tescil ve ilan edildi.

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 06:26:36' and `ac`.`end_time` >= '2023-01-31 06:26:36' 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=06 and campaign_id=498update ad_view_stat set view_count=view_count+1 where id=1659911 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 06:26:36' and `ac`.`end_time` >= '2023-01-31 06:26:36' 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=501checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=06 and campaign_id=501update ad_view_stat set view_count=view_count+1 where id=1659912
D