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:09:46' and `ac`.`end_time` >= '2023-01-31 16:09:46'
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
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:09:46' and `ac`.`end_time` >= '2023-01-31 16:09:46'
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=492checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=16 and campaign_id=492update ad_view_stat set view_count=view_count+1 where id=1660241
GÜMBET’İN ÇILGIN EĞLENCE HAYATI BAŞLADI...
Bodrum’a tatile gelen yerli ve yabancı turistler eğlencede sınır tanımıyor. Bodrum’un...
Bodrum’a tatile gelen yerli ve yabancı turistler eğlencede sınır tanımıyor.
Bodrum’un Dünyaca ünlü Gümbet plajında sabah saatlerinden itibaren hareketlilik başlarken, özellikle akşamüstü saatlerinde bazı işletmelerin gerçekleştirdiği partilere katılan turistler çılgınca eğleniyor. Köpük partisine katılan yerli ve yabancı turistler çılgınca dans ederken, arkadaşları da bu anları ölümsüzleştiriyor.
Hava sıcaklığının 36 derece ölçüldüğü Bodrum’da güneşlenen turistler, 22 derece ölçülen Ege denizine girerek serinliyor. Tatillerine macera katmak isteyen adrenalin tutkunu turistler ise sürat teknesinin çektiği paraşütle 120 metre yükseklikten Bodrum koylarını izliyorlar.
Gündüzleri deniz ve güneşin tadını çıkaran turistler akşamları ise Bodrum’un Dünyaca ünlü gece kulüplerine giderek sabahın ilk ışıklarına kadar eğleniyorlar.
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:09:46' and `ac`.`end_time` >= '2023-01-31 16:09:46'
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
25 Eylül - 1 Ekim tarihleri arasında kutlanan İtfaiyecilik Haftası nedeni ile Turgutreis...
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:09:46' and `ac`.`end_time` >= '2023-01-31 16:09:46'
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