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:12:43' and `ac`.`end_time` >= '2023-01-28 10:12:43'
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
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:12:43' and `ac`.`end_time` >= '2023-01-28 10:12:43'
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=392checkstat select id from ad_view_stat where view_date="2023-01-28" and view_hour=10 and campaign_id=392update ad_view_stat set view_count=view_count+1 where id=1657527
ÜCRETSİZ GÖZ TANSİYONU ÖLÇÜMÜ
Bodrum Belediyesi ile Universal Hospital Bodrum işbirliğinde vatandaşlara ücretsiz...
Bodrum Belediyesi ile Universal Hospital Bodrum işbirliğinde vatandaşlara ücretsiz ''Göz tansiyonu'' ölçümü yapıldı. Bodrum Belediyesi Meclis Salonu'nda yapılan ücretsiz göz tansiyonu ölçümüne, vatandaşlar yoğun ilgi gösterdi.
Universal Hospital Bodrum'da görevli Hemşire Cevriye Karadavut, halk arasında göz tansiyonu olarak bilinen glokomun tedavi edilmezse, görme kaybına neden olabileceğini söyledi.
Glokomun erken dönemde belirti göstermediğinden, kişinin hastalığının farkına varamadığını belirten Karadavut, "Glokom sinsi bir hastalıktır. 40 yaş üzerindeki herkes yılda en az bir kez muayene olup göz tansiyonunu ölçtürmelidir. Glokom lazer, cerrahi ve medikal yöntemlerle tedavi edilir" dedi.
Göz tansiyonu ölçümüne katılan vatandaşlar ise uygulamadan memnun kaldıklarını belirterek, Bodrum Belediyesi ile Universal Hospital Bodrum'a teşekkür etti.
Öte yandan 17 Aralık'ta Nurol Kültür Merkezi'nde glokomun konu edildiği bir seminer düzenlenecek.
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:12:43' and `ac`.`end_time` >= '2023-01-28 10:12:43'
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=419checkstat select id from ad_view_stat where view_date="2023-01-28" and view_hour=10 and campaign_id=419update ad_view_stat set view_count=view_count+1 where id=1657521
Bodrum'da hizmet veren esnaf, sezon boyunca olduğu gibi Kurban Bayramı'nda da otellerin...
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:12:43' and `ac`.`end_time` >= '2023-01-28 10:12:43'
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=423checkstat select id from ad_view_stat where view_date="2023-01-28" and view_hour=10 and campaign_id=423update ad_view_stat set view_count=view_count+1 where id=1657522