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:13:24' and `ac`.`end_time` >= '2023-01-31 16:13:24'
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=16 and campaign_id=445update ad_view_stat set view_count=view_count+1 where id=1660236
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:13:24' and `ac`.`end_time` >= '2023-01-31 16:13:24'
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
KIZILAY PERŞEMBE GÜNÜ DEVLET HASTANESİ'NDE
Kızılay'ın gezici kan toplama aracı 07 Şubat Perşembe günü Bodrum Devlet Hastanesinde...
Kızılay'ın gezici kan toplama aracı 07 Şubat Perşembe günü Bodrum Devlet Hastanesinde gün boyu kan toplayacak.
Sabah saat 10'da başlayacak olan kan toplama işlemi saat 15.30'da sona erecek. Kızılay'ın görevli personeli gün boyu TIR'ın içerisinde kan verecek vatandaşlara yardımcı olacak. Bodrum'da özellikle kış aylarında vatandaşlarca verilen kan stoklarında düşüş yaşandığını bu nedenle herkesi kan vermeye davet ettiklerini belirten Bodrum Devlet Hastanesi Başhekimi Dr. Oğuz Şahin "Kızılay'ın kan toplama aracı 7 Şubat perşembe günü hastanemizin bahçesinde olacak. Bodrum halkının bu konuda duyarlı olduklarını biliyorum. Ümit ediyorum ki talep yine yoğun olur. Özellikle kış aylarında kan stoklarımız azalmış oluyor. Kış aylarında yapılan bağışlar kan stokları için büyük önem arz ediyor. Herkesi kan vermeye davet ediyoruz" dedi.
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:13:24' and `ac`.`end_time` >= '2023-01-31 16:13:24'
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=502checkstat select id from ad_view_stat where view_date="2023-01-31" and view_hour=16 and campaign_id=502update ad_view_stat set view_count=view_count+1 where id=1660246
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:13:24' and `ac`.`end_time` >= '2023-01-31 16:13:24'
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=16 and campaign_id=509update ad_view_stat set view_count=view_count+1 where id=1660247