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

Etiket: Tataristan

Gündem

Bodrum'un Dijital Vizyonunu Anlattı

“Uluslararası 2022 Kazan Dijital Haftası Forumu” Bodrum Belediye Başkanı Ahmet Aras’ın katılımıyla 21–24 Eylül tarihleri arasında...

Banner ad space:tag_bottomSELECT `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-29" 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-29 05:49:02' and `ac`.`end_time` >= '2023-01-29 05:49:02' 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=469checkstat select id from ad_view_stat where view_date="2023-01-29" and view_hour=05 and campaign_id=469update ad_view_stat set view_count=view_count+1 where id=1658196
D