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 16:32:25' and `ac`.`end_time` >= '2023-02-01 16:32:25'
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-02-01" and view_hour=16 and campaign_id=492update ad_view_stat set view_count=view_count+1 where id=1661099
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 16:32:25' and `ac`.`end_time` >= '2023-02-01 16:32:25'
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=16 and campaign_id=497update ad_view_stat set view_count=view_count+1 where id=1661102
GÜNDOĞAN’DA TRAFİK KAZASI: 2 YARALI
Gündoğan yolu üzerinde meydana gelen trafik kazasında 2 kişi yaralandı. Edinilen...
Gündoğan yolu üzerinde meydana gelen trafik kazasında 2 kişi yaralandı.
Edinilen bilgiye göre, Gündoğan - Göltürkbükü karayolunda Hüseyin Demirci'nin kullandığı 48 VD 195 plakalı otomobil ile İlyas Kurt idaresindeki 48 VP 924 plakalı minibüs çarpıştı. Kazada her iki aracın sürücüleri de yaralandı.
Minibüs sürücüsü Olay yerine gelen ambulansla Bodrum Devlet Hastanesine kaldırıldı.
Yaralanan Otomobil sürücüsü ise araçta sıkıştı. Sağlık ve itfaiye ekipleri tarafından araçtan çıkartılan yaralı olay yerinde ilk müdahalesi yapıldıktan sonra ambulansla Bodrum Devlet Hastanesine götürüldü.
Her iki yaralının da hayati tehlikelerinin bulunmadığı ve tedavilerinin Bodrum Devlet Hastanesinde sürdüğü öğrenildi.
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 16:32:25' and `ac`.`end_time` >= '2023-02-01 16:32:25'
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=494checkstat select id from ad_view_stat where view_date="2023-02-01" and view_hour=16 and campaign_id=494update ad_view_stat set view_count=view_count+1 where id=1661101
Orman ve Su İşleri Bakanlığı 4. Bölge Müdürü Rahmi Bayrak, "Bitki ve hayvanlarda...
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 16:32:25' and `ac`.`end_time` >= '2023-02-01 16:32:25'
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=499checkstat select id from ad_view_stat where view_date="2023-02-01" and view_hour=16 and campaign_id=499update ad_view_stat set view_count=view_count+1 where id=1661104