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` = 1
AND `ac`.`start_time` <= '2023-01-31 05:57:01' and `ac`.`end_time` >= '2023-01-31 05:57:01'
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=492checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=05 and campaign_id=492update ad_view_stat set view_count=view_count+1 where id=1659861
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` = 1
AND `ac`.`start_time` <= '2023-01-31 05:57:01' and `ac`.`end_time` >= '2023-01-31 05:57:01'
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=497checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=05 and campaign_id=497update ad_view_stat set view_count=view_count+1 where id=1659862
ATA İÇİN KOŞACAKLAR
Tüm yurtta olduğu gibi Bodrum’da her yıl düzenlenen Atatürk Yol Koşusu, bu yıl 29...
Tüm yurtta olduğu gibi Bodrum’da her yıl düzenlenen Atatürk Yol Koşusu, bu yıl 29 Aralık Salı günü gerçekleştirilecek.
Bodrum Gençlik Hizmetleri ve Spor İlçe Müdürlüğü tarafından organize edilen, Bodrum Kaymakamlığı ve Bodrum Belediyesi tarafından desteklenen bu yılki Atatürk Yol Koşusu’nda sporcular 15 ayrı kategoride yarışacak. İçmeler Tersaneler bölgesi ile Barış (İskele) Meydanı arasında gerçekleşecek koşunun kategorileri ise “Küçük kız-erkek, yıldız kız-erkek, genç kız-erkek, büyük bayan-bay, masterler bayan-bay ve özel sporcular” olarak belirlendi.
Bu yıl ayrıca küçük kız-erkek(3+1), yıldız kız-erkek(4+1), genç kız-erkek(4+1) ve büyük bayan-bay(4+1) kategorilerinde takım olarak ta ödül verilecek Atatürk Yol Koşusu’na katılmak isteyenler, koşu günü saat 9:30’da Barış (İskele) Meydanında 2015 yılı vizeli lisans veya ek 5 formları ile kayıt yaptıracaklar.
29 Aralık Salı saat 10:30’da başlayacak Atatürk Yol Koşusu’nun ödül töreni ise koşuların ardından yine Barış (İskele) Meydanı’nda gerçekleştirilecek.
SELECT `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-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` = 3
AND `ac`.`start_time` <= '2023-01-31 05:57:01' and `ac`.`end_time` >= '2023-01-31 05:57:01'
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=359checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=05 and campaign_id=359update ad_view_stat set view_count=view_count+1 where id=1659876
Bodrum’da direksiyon hakimiyetini kaybeden otomobil sürücüsü, durağa daldı. Kaza,...
Anket
SELECT `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-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` = 3
AND `ac`.`start_time` <= '2023-01-31 05:57:01' and `ac`.`end_time` >= '2023-01-31 05:57:01'
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=394checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=05 and campaign_id=394update ad_view_stat set view_count=view_count+1 where id=1659877