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-02-01"
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-02-01 19:35:21' and `ac`.`end_time` >= '2023-02-01 19:35:21'
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-02-01" and view_hour=19 and campaign_id=497update ad_view_stat set view_count=view_count+1 where id=1661204
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-02-01"
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-02-01 19:35:21' and `ac`.`end_time` >= '2023-02-01 19:35:21'
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-02-01" and view_hour=19 and campaign_id=500update ad_view_stat set view_count=view_count+1 where id=1661207
YOKUŞTAN ÇIKAMAYINCA OLANLAR OLDU!..
Bodrum'da yaşanan ilginç kazada şans eseri ölen yada yaralanan olmadı. Akşam saatlerinde,...
Bodrum'da yaşanan ilginç kazada şans eseri ölen yada yaralanan olmadı.
Akşam saatlerinde, Yokubaşı Mahallesi Albatros Sitesi içinde tuhaf, bir o kadar da ucuz atlatılan bir kaza yaşandı.
41 HR 393 plakalı aracı kullanan bayan sürücü, Albatros Sitesi içerisindeki yokuşu çıktığı sırada aracın motor devrini düşürdü. Daha sonra vites küçültmek isterken aracı stop ettiren bayan sürücü yokuşun ortasında kala kaldı. Aracın el frenini çekip yanındaki erkek şahsa direksiyonu teslim etmeyi düşündükleri sırada ise araç geri geri hareket ederek yol kenarındaki korkuluklara çarpıp ters döndü.
Kazayı gören çevredeki site sakinleri hemen yardım için aracın yanına koştu. Güçlükle araçtan çıkarılan şahıslar bir süre kazanın şokunu yaşadı. Olay yerine çağrılan 112 Acil Servis ekibi tarafından muayene edilen ve hafif şekilde yaralanan bayan sürücü hastaneye gitmeyi reddetti.
Görenleri hayrete düşüren kazada, aracın korkulukları aşarak aşağıya düşmemesi ise büyük şans oldu.
Polis ekiplerinin olay yerindeki incelemelerinin ardından araç çekici yardımıyla kaldırı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-02-01"
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-02-01 19:35:21' and `ac`.`end_time` >= '2023-02-01 19:35:21'
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-02-01" and view_hour=19 and campaign_id=359update ad_view_stat set view_count=view_count+1 where id=1661185
Ünlü Şovmen Mehmet Ali Erbil'in eşi Tuğba Erbil, rahatsızlanarak hastaneye kaldırıldı....
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-02-01"
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-02-01 19:35:22' and `ac`.`end_time` >= '2023-02-01 19:35:22'
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-02-01" and view_hour=19 and campaign_id=394update ad_view_stat set view_count=view_count+1 where id=1661187