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-28"
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-28 10:27:30' and `ac`.`end_time` >= '2023-01-28 10:27:30'
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=329checkstat select id from ad_view_stat where view_date="2023-01-28" and view_hour=10 and campaign_id=329update ad_view_stat set view_count=view_count+1 where id=1657523
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-28"
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-28 10:27:30' and `ac`.`end_time` >= '2023-01-28 10:27:30'
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=357checkstat select id from ad_view_stat where view_date="2023-01-28" and view_hour=10 and campaign_id=357update ad_view_stat set view_count=view_count+1 where id=1657524
TARIMA 1 MİLYON YTL DESTEK...
Sosyal Riski Azaltma Projesi kapsamında Milas Sosyal Yardımlaşma ve Dayanışma Vakfı...
Sosyal Riski Azaltma Projesi kapsamında Milas Sosyal Yardımlaşma ve Dayanışma Vakfı tarafından gerçekleştirilen faaliyetler Vakıf Başkanı Kaymakam Hulusi Doğan tarafından yerinde yapılan incelemelerle basına anlatıldı.
Kaymakam Doğan'ın Kırcağız Köyü'nde yapılan Enginar Projesi ile başladığı ziyaretler Kafaca Köyü ve Dibekderesi Çilek Projesi ile tamamlandı. Gerçekleşen ziyaret ve bilgilendirme gezisine Milas Kaymakamı Hulusi Doğan, İlçe Tarım Müdürü Ali Akay, Sosyal Yardımlaşma ve Dayanışma Vakfı Müdürü Latif Şengür, İlçe Tarım Müdürü yetkilileri, Kafaca Köy Muhtarı Saadettin Akarca, Gönüllü Ziraat Görevlisi Ümit Özgür ve basın mensupları katıldı. Kırcağız'a yapılan ilk ziyaret geçtiğimiz yıl aldığı destekle 3 dönüm arazi üzerine Enginar Projesi uygulayan çiftçinin enginar tarlasında gerçekleşti. Vakıf Müdürü Latif Şengür, burada yapılan 5 yıllık çalışmalar hakkında bilgi verdi.
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-28"
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-28 10:27:30' and `ac`.`end_time` >= '2023-01-28 10:27:30'
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-28" and view_hour=10 and campaign_id=207update ad_view_stat set view_count=view_count+1 where id=1657510
Adalet ve Demokrasi Haftası sebebiyle düzenlenen panelde anayasa tartışmaları konuşuldu....
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-28"
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-28 10:27:30' and `ac`.`end_time` >= '2023-01-28 10:27:30'
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-28" and view_hour=10 and campaign_id=330update ad_view_stat set view_count=view_count+1 where id=1657511
