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 16:22:11' and `ac`.`end_time` >= '2023-01-31 16:22:11'
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-31" and view_hour=16 and campaign_id=446update ad_view_stat set view_count=view_count+1 where id=1660237
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 16:22:11' and `ac`.`end_time` >= '2023-01-31 16:22:11'
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-31" and view_hour=16 and campaign_id=453update ad_view_stat set view_count=view_count+1 where id=1660240
“DİYABETİ DURDURALIM” PROJESİ…
Konacık Belediyesi ile Türkiye Diyabet Vakfı Bodrum Şubesi işbirliğinde, 'Diyabeti...
Konacık Belediyesi ile Türkiye Diyabet Vakfı Bodrum Şubesi işbirliğinde, 'Diyabeti Durduralım' projesi kapsamında, “Akran Eğitim Programı” düzenlendi.
Türkiye Diyabet Vakfı’nın diyabet hastalığı ile mücadele etmek amacıyla Cumhurbaşkanlığı himayesinde başlattığı 'Diyabeti Durduralım' projesi kapsamında düzenlenen “Akran Eğitimi Programı” Konacıklı vatandaşların yoğun katılımı ile gerçekleşti.
Konacık Belediyesi Meclis Salonunda düzenlenen eğitim sırasında Diyabet Akran Eğitimcisi Sevtap Türkay’ın sunumlu anlatımıyla “Diyabeti Tanıyalım, Diyabette Beslenme Tedavisi ve Egzersiz, Diyabette İnsülin ve İlaç Tedavisi, Diyabette Organ Hasarları, Diyabetin Evde Takibi ve Vücudun Bakımını Tanıyalım” konuları ele alındı. Diyabet hastalarının doğru beslenmesine yönelik örnek diyabete uygun ikramlar da dağıtıldı.
Diyabetle barışık yaşama yolunun dikkat etmekten geçtiğini belirten Diyabet Akran Eğitimcisi Sevtap Türkay; “Kan şekeri düzeylerinizi ortalama aralıklarda tutarak olabildiğince normal yaşam sürdürmeyi hedeflemeliyiz. Bu hedefe ulaşmanın en iyi yolu uygun diyet programı uygulamak ve bol bol egzersiz yapmaktır” dedi.
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 16:22:11' and `ac`.`end_time` >= '2023-01-31 16:22:11'
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=16 and campaign_id=430update ad_view_stat set view_count=view_count+1 where id=1660239
Yasa dışı yollardan kaçmak için değişik yöntemleri deneyen göçmenler, son olayda...
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 16:22:11' and `ac`.`end_time` >= '2023-01-31 16:22:11'
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=16 and campaign_id=455update ad_view_stat set view_count=view_count+1 where id=1660242