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 17:54:19' and `ac`.`end_time` >= '2023-02-01 17:54:19'
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=497checkstat select id from ad_view_stat where view_date="2023-02-01" and view_hour=17 and campaign_id=497update ad_view_stat set view_count=view_count+1 where id=1661125
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 17:54:19' and `ac`.`end_time` >= '2023-02-01 17:54:19'
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-02-01" and view_hour=17 and campaign_id=500update ad_view_stat set view_count=view_count+1 where id=1661128
ARI HAYATINI KAYBETTİ
Bodrum'da faaliyet gösteren 01 Adana Restoranı'nın sahibi eski uzman çavuş Mustafa...
Bodrum'da faaliyet gösteren 01 Adana Restoranı'nın sahibi eski uzman çavuş Mustafa Arı hayatını kaybetti. Mustafa Arı, önceki gün Yeniköy Mahallesi, Mimoza Sitesi'ndeki
evinde eşi tarafından başından yaralı olarak bulunmuş eşi Dürdane Arı tarafından haber verilen ambulans ile hastaneye kaldırılarak tedavi altına alınmıştı. Mustafa Arı hastanede gerçekleşen tüm müdahalelere rağmen hayatını kaybetti. Arı'nın cenazesi otopsi için İzmir Adli Tıp Kurumuna gönderildi. Mustafa Arı'nın Konacık Balkanoğlu iş merkezinde açtığı restoranında ve daha sonra Bodrum da açtığı restoranında ekonomik sıkıntılar yaşadığı öğrenildi. Çevresinde sessiz, onurlu, içine kapanıklığı ile bilinen ve sevilen Arı'nın bir süredir yaşadığı sıkıntılar nedeniyle bunaldığı iddia edildi. Arı MHP Bodrum İlçesi Yönetim kurulu yedek üyesi üyesi olarak görev yapıyordu. Mustafa Arı'nın cenazesi Pazartesi günü İzmir Adli Tıp kurumundan alınarak memleketi Adana'da defnedilecek.
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 17:54:19' and `ac`.`end_time` >= '2023-02-01 17:54:19'
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=423checkstat select id from ad_view_stat where view_date="2023-02-01" and view_hour=17 and campaign_id=423update ad_view_stat set view_count=view_count+1 where id=1661123
Bodrum Fenerbahçeliler Derneği olağan seçimli genel kurulunda mevcut başkan Mert...
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 17:54:19' and `ac`.`end_time` >= '2023-02-01 17:54:19'
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=17 and campaign_id=430update ad_view_stat set view_count=view_count+1 where id=1661126