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-29"
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-29 08:33:29' and `ac`.`end_time` >= '2023-01-29 08:33:29'
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=446checkstat select id from ad_view_stat where view_date="2023-01-29" and view_hour=08 and campaign_id=446update ad_view_stat set view_count=view_count+1 where id=1658298
MOTORYAT ALEV TOPUNA DÖNDÜ, CANINI ZOR KURTARDI!..
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-29"
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-29 08:33:29' and `ac`.`end_time` >= '2023-01-29 08:33:29'
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=453checkstat select id from ad_view_stat where view_date="2023-01-29" and view_hour=08 and campaign_id=453update ad_view_stat set view_count=view_count+1 where id=1658270
MOTORYAT ALEV TOPUNA DÖNDÜ, CANINI ZOR KURTARDI!..
Bodrum’da açıkta bulunan motoryat yanarak battı. Motoryattaki bir kişi canını zor...
Bodrum’da açıkta bulunan motoryat yanarak battı. Motoryattaki bir kişi canını zor kurtardı.
Gündoğan Limanı'ndan bu sabah Didim'e doğru yola çıkan 14 metre uzunluğundaki 'Mystry' isimli motoryatın motor bölümünde, limandan çıktıktan 2 mil sonra, yangın çıktı. Yat kaptanı T.K. (38), alevlere yangın söndürme tüpüyle müdahale ettiyse de sonuç alamadı. Alevler hızla büyürken, kaptan T.K. denize atlayıp kurtuldu. O esnada bölgeden teknesiyle geçen Nedim Örer adlı vatandaş, denize atlayan kaptanı kurtardı.
Durumu ihbar alan Bodrum Sahil Güvenlik Komutanlığı ekipleri, bölgeye gelip tekneyi söndürmeye çalıştı. Alev topuna dönen motoryat dakikalar içinde yanarak battı.
Kent Haber'e olayı anlatan Nedim Örer "Ben Türkbükü'nden çıktım, Akvaryum Koyu'na gidiyordum. Kızılburun'a geldiğimize bir duman gördüm. Biraz daha yaklaştığımızda bir teknenin yandığını, kaptanın da denizde olduğunu gördüm. Kaptanı denizde alıp, Sahil Güvenlik'e haber verdim" diye konuştu.
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-29"
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-29 08:33:29' and `ac`.`end_time` >= '2023-01-29 08:33:29'
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=207checkstat select id from ad_view_stat where view_date="2023-01-29" and view_hour=08 and campaign_id=207update ad_view_stat set view_count=view_count+1 where id=1658276
TFF 2. Lig Beyaz Grup'ta mücadele eden Bodrum Belediyesi Bodrumspor, Kastamonuspor...
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-29"
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-29 08:33:29' and `ac`.`end_time` >= '2023-01-29 08:33:29'
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=330checkstat select id from ad_view_stat where view_date="2023-01-29" and view_hour=08 and campaign_id=330update ad_view_stat set view_count=view_count+1 where id=1658277