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-27"
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-27 03:56:04' and `ac`.`end_time` >= '2023-01-27 03:56:04'
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-27" and view_hour=03 and campaign_id=492update ad_view_stat set view_count=view_count+1 where id=1656422
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-27"
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-27 03:56:04' and `ac`.`end_time` >= '2023-01-27 03:56:04'
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=507checkstat select id from ad_view_stat where view_date="2023-01-27" and view_hour=03 and campaign_id=507update ad_view_stat set view_count=view_count+1 where id=1656441
HASAR TESPİT MÜRACAATI İÇİN SON GÜNLER!
Bodrum Kaymakamlığı'ndan yapılan açıklamada deprem nedeniyle yapılmakta olan hasar...
Bodrum Kaymakamlığı'ndan yapılan açıklamada deprem nedeniyle yapılmakta olan hasar tespit müracaatlarının 5 Ağustos tarihinde sona ereceği bildirilerek, vatandaşların mağduriyet yaşamamaları için bu tarihten önce müracaatlarını yapmaları istendi.
Bodrum’da 21 Temmuz günü saat 01.31’de yaşanan 6.6 şiddetindeki depremde meydana gelen hasar tespitleri için müracaatlar sürüyor. Binaları depremde hasar gören vatandaşlar için müracaat süresinin 5 Ağustos tarihinde sona ereceğini bildiren Bodrum Kaymakamlığı, konu ile ilgili yaptığı açıklamada şu ifadeleri kullandı:
“21.07.2017 tarihinde Bodrum'da meydana gelen deprem nedeniyle yapılmakta olan hasar tespitleri için müracaatların alınma süreleri 05.08.2017 Cumartesi günü sona erecektir. Bu tarihten sonra verilen hasar tespitine dair talep dilekçeleri işleme alınamayacaktır. Vatandaşlarımızın mağduriyet yaşamamaları için başvurularını belirlenen yasal süre içerisinde yapması gerektiği ilanen duyurulur” denildi.
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-27"
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-27 03:56:04' and `ac`.`end_time` >= '2023-01-27 03:56:04'
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-27" and view_hour=03 and campaign_id=207update ad_view_stat set view_count=view_count+1 where id=1656423
Bodrum'da çıkan kavgada 1 kişi bıçakla yaralandı. Bodrum Artemis caddesinde meydana...
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-27"
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-27 03:56:04' and `ac`.`end_time` >= '2023-01-27 03:56:04'
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-27" and view_hour=03 and campaign_id=330update ad_view_stat set view_count=view_count+1 where id=1656424