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

Etiket: Haluk Pekşen

Yaşam

Bakanlık Soruşturma Başlattı

Sağlık Bakanlığı, CHP eski Trabzon Milletvekili Haluk Pekşen'in ölümüyle ilgili ihmal iddiaları üzerine soruşturma başlattı. Bodrum'daki...

Yaşam

Pekşen'in Vefatı Mercek Altında...

Bodrum'da geçirdiği rahatsızlık sonrası nakledildiği Ankara'daki Güven Hastanesi'nde kurtarılamayarak yaşama veda eden CHP Trabzon...

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 15:34:47' and `ac`.`end_time` >= '2023-01-31 15:34:47' 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=420checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=15 and campaign_id=420update ad_view_stat set view_count=view_count+1 where id=1660206 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 15:34:47' and `ac`.`end_time` >= '2023-01-31 15:34:47' 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=15 and campaign_id=422update ad_view_stat set view_count=view_count+1 where id=1660207
D