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 19:51:03' and `ac`.`end_time` >= '2023-02-01 19:51:03'
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=428checkstat select id from ad_view_stat where view_date="2023-02-01" and view_hour=19 and campaign_id=428update ad_view_stat set view_count=view_count+1 where id=1661192
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 19:51:03' and `ac`.`end_time` >= '2023-02-01 19:51:03'
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=445checkstat select id from ad_view_stat where view_date="2023-02-01" and view_hour=19 and campaign_id=445update ad_view_stat set view_count=view_count+1 where id=1661195
23 NİSAN HEDİYESİ BODRUM TATİLİ
Lösemili Çocuklar Vakfı'nın (LÖSEV) organizasyonu ile Türkiye'nin farklı illerinden...
Lösemili Çocuklar Vakfı'nın (LÖSEV) organizasyonu ile Türkiye'nin farklı illerinden Bodrum'a getirilen lösemiyi yenmiş ve lösemi ile mücadele eden 40 çocuk gönüllerince eğlendi...
Lösemili Çocuklar Vakfı (LÖSEV) Genel Koordinatörü Hülya Ünver Konya, Mardin, Adana, Çorum ve Türkiye'nin dört bir yanından lösemiyi yenen ve lösemi ile savaşan 40 çocuğu tatil için Bodrum'a getirdiklerini söyledi.
Ünver, vakıflarının özellikle 0-16 yaş grubundaki lösemili çocuklara yönelik çalışmalar yaptığına işaret ederek, '''Bugüne kadar 2 bin 400 lösemili çocuğa farklı şekillerde ulaştık. Vakfımıza kayıtlı 2 bin 400 çocuk var. Bodrum gezisi lösemili çocuklara 23 Nisan hediyemiz'' diye konuştu...
Türkiye'nin farklı illerinden gelen 40 çocuk ise ilk defa geldikleri Bodrum'da Bodrum kalesi ve çarşısını gezdiler. Kaldıkları WOW Bodrum Resort'ta animatörler tarafından düzenlenen oyunlara da katılan çocukların bir bölümü ise resim yapıp, otelin çocuk kulübünde oyuncaklarla oynadı...
Bodrum tatili boyunca çocuklara WOW Bodrum Resort ev sahipliği yaparken, çocukların uçak biletlerini ise MNG havayolları karşıladı...
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 19:51:03' and `ac`.`end_time` >= '2023-02-01 19:51:03'
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-02-01" and view_hour=19 and campaign_id=430update ad_view_stat set view_count=view_count+1 where id=1661194
Bodrum Makina Mühendisleri Odası Başkanı Semai Yaman ile Bodrum'daki mimar ve mühendislik...
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 19:51:03' and `ac`.`end_time` >= '2023-02-01 19:51:03'
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-02-01" and view_hour=19 and campaign_id=455update ad_view_stat set view_count=view_count+1 where id=1661199