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 09:01:20' and `ac`.`end_time` >= '2023-01-28 09:01:20'
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=500checkstat select id from ad_view_stat where view_date="2023-01-28" and view_hour=09 and campaign_id=500update ad_view_stat set view_count=view_count+1 where id=1657463
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 09:01:20' and `ac`.`end_time` >= '2023-01-28 09:01:20'
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-01-28" and view_hour=09 and campaign_id=507update ad_view_stat set view_count=view_count+1 where id=1657464
MİDTOWN AÇILIŞ FESTİVALİ SONA ERDİ…
Geçtiğimiz haftalarda hizmete giren, Bodrum’un en büyük alışveriş ve yaşam merkezi...
Geçtiğimiz haftalarda hizmete giren, Bodrum’un en büyük alışveriş ve yaşam merkezi Midtown, açılışıyla beraber festivali de beraberinde getirdi.
Bodrum Ortakent’te Haziran ayında ziyaretçileriyle buluşan Midtown Alışveriş ve Yaşam Merkezi, açıldığı günden bu yana, birbirinden özel sürprizlerle ziyaretçilerine keyif dolu anlar yaşattı. Bodrum’un kalbinde bulunan Midtown, kültür, alışveriş ve eğlencenin yeni adresi olurken, en son gerçekleştirdiği 3 gece boyunca süren konserleriyle açılış festivalinin finalini tamamladı.
Midtown açılış festivalinin son üç gecesinde sahne alan Ayhan Sicimoğlu ve Latin All Stars, Behzat Gerçeker ENBE Orkestrası ve Sunshine Band konserleri izleyiciler tarafından büyük beğeni topladı.
Sicimoğlu’nun klasikleşen dans ve eğlence dolu performansı, Latin All Stars’ın muhteşem yorumu ile birleşirken, Barry White, Richard Clayderman, Goran Bregoviç gibi dünyanın en ünlü isimleriyle muhteşem şovlara imza atan Behzat Gerçeker ENBE Orkestrası, Bodrum Midtown Alışveriş ve Yaşam Merkezi’nde ziyaretçilerini benzersiz bir müzik yolculuğuna çıkardı. Açılışın final gecesinde ise 1960’dan 90’lı yıllara kadar en popüler şarkılara hayat veren Türkiye’nin güçlü orkestralarında Sunshine Band sahne aldı.
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 09:01:20' and `ac`.`end_time` >= '2023-01-28 09:01:20'
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-28" and view_hour=09 and campaign_id=430update ad_view_stat set view_count=view_count+1 where id=1657469
Turgutreis Çarşısı'ndaki boş dükkanlar sanatçılar tarafından değerlendirildi. Yaşanan...
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 09:01:20' and `ac`.`end_time` >= '2023-01-28 09:01:20'
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-28" and view_hour=09 and campaign_id=455update ad_view_stat set view_count=view_count+1 where id=1657470