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 15:57:10' and `ac`.`end_time` >= '2023-01-31 15:57:10'
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-01-31" and view_hour=15 and campaign_id=445update ad_view_stat set view_count=view_count+1 where id=1660235
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 15:57:10' and `ac`.`end_time` >= '2023-01-31 15:57:10'
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=446checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=15 and campaign_id=446update ad_view_stat set view_count=view_count+1 where id=1660205
YUSUF TARIM RESİM SERGİSİ
Bodrum Kalesi Haluk Elbe Sanat Galerisi'nde ressam Yusuf Tarım'ın resim sergisi...
Bodrum Kalesi Haluk Elbe Sanat Galerisi'nde ressam Yusuf Tarım'ın resim sergisi açıldı. Sergiye Bodrumlu sanatseverler büyük ilgi gösterdi. 1959 yılında Hemşin-Rize'de doğan sanatçı, Samsun Endüstri Meslek Lisesi Makina Modeli Bölümü'nü bitirdi. Resim çalışmalarına Manisa'da başlayan sanatçı, Bağbozumu Resim Yarışması'nda birincilik ve ikincilik ödüllerini kazandı.1991 yılında Esbank Resim Yarışması'nda resimleri sergilenmeye değer görüldü. 1995 yılında Bodrum'a yerleşen Yusuf Tarım, kısa bir süre Dr. Ayla Eriş Atölyesi'ne devam etti. Birçok karma ve kişisel sergide resimleri yer alan sanatçı, çalışmalarını Bodrum'daki kendi atölyesinde sürdürüyor. Sergi, 10 Ekim tarihine kadar sanatseverler tarafından gezilebilir.
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 15:57:10' and `ac`.`end_time` >= '2023-01-31 15:57:10'
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=509checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=15 and campaign_id=509update ad_view_stat set view_count=view_count+1 where id=1660214
Turizm sektörünün en önemli buluşma noktalarından biri olan Travel Turkey İzmir...
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 15:57:10' and `ac`.`end_time` >= '2023-01-31 15:57:10'
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=207checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=15 and campaign_id=207update ad_view_stat set view_count=view_count+1 where id=1660216
