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

Etiket: TUİK

Bölgeden

Hanehalkı Ortalaması 2,82 Kişi!

Türkiye İstatistik Kurumu 2019 yılı Adrese Dayalı Nüfus Kayıt Sistemi sonuçlarına göre oluşan Ortalama Hanehalkı verilerini yayımladı....

Ekonomi

Konut Satışlarında Artış Sürüyor!

Türkiye İstatistik Kurumu 2020 yılı Ocak ayı Konut Satış İstatistiklerini yayımladı. Bu kapsamda TÜİK Denizli Bölge Müdürü Ali İhsan...

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:17:42' and `ac`.`end_time` >= '2023-01-31 06:17:42' 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=422checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=06 and campaign_id=422update ad_view_stat set view_count=view_count+1 where id=1659918
Gündem

Muğla’da Trafik Kazalarının Sayısı Arttı!

Türkiye İstatistik Kurumu 2018 yılı Karayolu Trafik Kaza İstatistiklerini yayımladı. TÜİK'ten verilen bilgiye göre Muğla’da Trafik...

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:17:42' and `ac`.`end_time` >= '2023-01-31 06:17:42' 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=429checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=06 and campaign_id=429update ad_view_stat set view_count=view_count+1 where id=1659919
D