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-02-01"
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-02-01 15:08:08' and `ac`.`end_time` >= '2023-02-01 15:08:08'
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-02-01" and view_hour=15 and campaign_id=507update ad_view_stat set view_count=view_count+1 where id=1661058
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-02-01"
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-02-01 15:08:08' and `ac`.`end_time` >= '2023-02-01 15:08:08'
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-02-01" and view_hour=15 and campaign_id=329update ad_view_stat set view_count=view_count+1 where id=1661059
HER ŞEY ONLAR İÇİN
"Engelliler Haftası" etkinlikleri kapsamında Bodrum İskele Meydanı Denizciler Kahvesi...
"Engelliler Haftası" etkinlikleri kapsamında Bodrum İskele Meydanı Denizciler Kahvesi önünde engelliler yararına kermes düzenlendi. Cumartersi ve pazar açık kermeste birçok etkinlik yer aldı.
Bodrum Sağlık Vakfı Begonvil Özel Eğitim ve Rehabilitasyon Merkezi, Yahşi Eğitim Uygulama Okulu ve İş Eğitim Merkezi ile Yeni Ufuklar Sosyal Yardımlaşma ve Dayanışma Derneği'nin birlikte düzenledikleri kermeste, animasyonlar ve öğrenci gösterileri yapıldı. Engellilerin yaptığı el işleri sergilenirken, okuma yazma öğrenen çocuklara da belgeleri verildi.
Kermeste elde edilecek gelir Bodrum Sağlık Vakfı'nın giderleri için harçanacak. Sağlık Vakfı Turgutreis Engelli Çocuklar Özel Eğitim ve Rehabilitasyon Merkezi Genel Koordinatörü Zafer Pınarer bu tür etkinlikleri sıklıkla düzenleyeceklerini söyleyerek, amaçlarının engelliler için hizmet etmek olduğunu söyledi.
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-02-01"
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-02-01 15:08:08' and `ac`.`end_time` >= '2023-02-01 15:08:08'
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=359checkstat select id from ad_view_stat where view_date="2023-02-01" and view_hour=15 and campaign_id=359update ad_view_stat set view_count=view_count+1 where id=1661069
Bodrum'da şezlongların arasından çıkan yavru caretta carettalar heyecan yarattı.
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-02-01"
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-02-01 15:08:08' and `ac`.`end_time` >= '2023-02-01 15:08:08'
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=394checkstat select id from ad_view_stat where view_date="2023-02-01" and view_hour=15 and campaign_id=394update ad_view_stat set view_count=view_count+1 where id=1661071