Banner ad space:headerSELECT `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-28"
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` = 1
AND `ac`.`start_time` <= '2023-01-28 10:06:03' and `ac`.`end_time` >= '2023-01-28 10:06:03'
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=329checkstat select id from ad_view_stat where view_date="2023-01-28" and view_hour=10 and campaign_id=329update ad_view_stat set view_count=view_count+1 where id=1657523
Banner ad space:headerSELECT `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-28"
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` = 1
AND `ac`.`start_time` <= '2023-01-28 10:06:03' and `ac`.`end_time` >= '2023-01-28 10:06:03'
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=357checkstat select id from ad_view_stat where view_date="2023-01-28" and view_hour=10 and campaign_id=357update ad_view_stat set view_count=view_count+1 where id=1657524
NEJAT İŞLER'E YAKIŞMADI
Ünlü sinema oyuncusu Nejat İşler Bodrum Gümbet'te Kent Tv kameralarına yakalandı....
Ünlü sinema oyuncusu Nejat İşler Bodrum Gümbet'te Kent Tv kameralarına yakalandı.
Bir erkek arkadaşıyla birlikte Gümbet barlar sokağında gezerken rastladığımız Nejat İşler, ayakta durmakta zorlanıyordu. Gümbet'te gezerken hayranlarının da ilgisiyle karşılaşan İşler, sempatik tavırlarıyla dikkat çekti. Arkadaşına sarılarak yürüyebilen ünlü oyuncu, kamerayı görünce hemen bir bara girerek saklandı. Bir süre bardan dışarı çıkmayan oyuncu, daha sonra yine arkadaşına sarılarak aracına doğru yürüdü. Bu sırada muhabirin sorularına sinirlenen ve cevap vermeyen oyuncu "ben buna dayanamam, nereye gidiyoruz" diyerek arkadaşına defalarca sordu. Nejat İşler daha sonra muhabirin sorusuna ise küfürle karşılık verdi. Kendini tutmakta zorlanan oyuncu, muhabire saldırmaya kalktı ancak yanındaki arkadaşı İşler'i sakinleştirdi. Sinirlenen oyuncu arkasına bakarak yürümeye devam etti. Kameraların çekim yaptığı gören oyuncu kameraya yöneldi, arkadaşı ise İşler'i durdurarak araca binmesini söyledi. Ayakta durmakta zorlanan oyuncu arabasına binerek Gümbet'ten ayrıldı.
Banner ad space:sidebar_topSELECT `ac`.`id`, `ac`.`banner_text`, `ac`.`banner_url`, `ac`.`hash` as `banner_hash`, `images`.`image_320x320` 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-28"
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` = 3
AND `ac`.`start_time` <= '2023-01-28 10:06:03' and `ac`.`end_time` >= '2023-01-28 10:06:03'
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=494checkstat select id from ad_view_stat where view_date="2023-01-28" and view_hour=10 and campaign_id=494update ad_view_stat set view_count=view_count+1 where id=1657529
İlki geçtiğimiz yıl düzenlenen Kraft Yaşam Festivali bu yıl 13-15 Eylül tarihlerinde...
Anket
Banner ad space:sidebar_bottomSELECT `ac`.`id`, `ac`.`banner_text`, `ac`.`banner_url`, `ac`.`hash` as `banner_hash`, `images`.`image_320x320` 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-28"
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` = 3
AND `ac`.`start_time` <= '2023-01-28 10:06:03' and `ac`.`end_time` >= '2023-01-28 10:06:03'
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=499checkstat select id from ad_view_stat where view_date="2023-01-28" and view_hour=10 and campaign_id=499update ad_view_stat set view_count=view_count+1 where id=1657530