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 07:22:48' and `ac`.`end_time` >= '2023-01-31 07:22:48'
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=07 and campaign_id=497update ad_view_stat set view_count=view_count+1 where id=1659950
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 07:22:48' and `ac`.`end_time` >= '2023-01-31 07:22:48'
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=500checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=07 and campaign_id=500update ad_view_stat set view_count=view_count+1 where id=1659951
KASKSIZ SÜRÜCÜLERE CEZA
Bodrum İlçe Emniyet Müdürlüğü trafik ekiplerince, Bodrumdaki motosiklet sürücülerine...
Bodrum İlçe Emniyet Müdürlüğü trafik ekiplerince, Bodrumdaki motosiklet sürücülerine yönelik uygulama yapıldı. Uygulama kapsamında kurallara uymayan çok sayıda motosiklet sürücüsüne çeşitli cezalar kesildi.
Bodrum Neyzen Tevfik Caddesinde 2 ekibin katılımıyla yapılan uygulamalarda denetlenen araçlara,kask,ehliyet ve evrak eksikliği nedeniyle çok sayıda sürücüye yasal işlem yapıldı.
Emniyet yetkilileri motosiklet sürücülerini kask takmaları ve yetersiz belge ile trafiğe çıkmamaları konusunda uyardı.Eksikliklerinin farkında olan bazı motosiklet sürücüleri ise trafik ekiplerini karşısında görünce kaçmaya çalıştı.
Yaklaşık 2 saat süren uygulamalarda 17 sürücüye çeşitli suçlardan 2 bin lira para cezası kesilirken,6 motosiklet ise trafikten men edildi, 2 kişi de mahkemeye sevk edildi. Uygulamaların çeşitli bölgelerde devam edeceği öğrenilirken sürücüler trafik kurallarına uymaları konusunda uyarıldı.
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 07:22:48' and `ac`.`end_time` >= '2023-01-31 07:22:48'
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=430checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=07 and campaign_id=430update ad_view_stat set view_count=view_count+1 where id=1659944
Kurtlar Vadisi Dizisi'nin ünlü oyuncusu Atilla Olgaç, Gümüşlük'teki evinde tatil...
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 07:22:48' and `ac`.`end_time` >= '2023-01-31 07:22:48'
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=455checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=07 and campaign_id=455update ad_view_stat set view_count=view_count+1 where id=1659945