Banner ad space:headerSELECT `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-29"
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-29 06:02:07' and `ac`.`end_time` >= '2023-01-29 06:02:07'
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=392checkstat select id from ad_view_stat where view_date="2023-01-29" and view_hour=06 and campaign_id=392update ad_view_stat set view_count=view_count+1 where id=1658214
Banner ad space:headerSELECT `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-29"
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-29 06:02:07' and `ac`.`end_time` >= '2023-01-29 06:02:07'
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=428checkstat select id from ad_view_stat where view_date="2023-01-29" and view_hour=06 and campaign_id=428update ad_view_stat set view_count=view_count+1 where id=1658215
ÇANAKKALE'DEN BAYRAK GETİRDİLER
İzcilik Federasyonu tarafından Çanakkale'de düzenlenen etkinliğe Milas'tan katılan...
İzcilik Federasyonu tarafından Çanakkale'de düzenlenen etkinliğe Milas'tan katılan 10 izci, teslim aldıkları Türk Bayrağı'nı İlçe Gençlik ve Spor Müdürü Mustafa Ali Ünlüsoy'a teslim ettiler...
İlçe Gençlik ve Spor Müdürü Mustafa Ali Ünlüsoy'u makamında ziyaret eden 10 izci ve bir izci lideri bugüne kadar yaptıkları izcilik faaliyetlerinde verdiği destekten ötürü Mustafa Ali Ünlüsoy'a teşekkür etti. Yapılan ziyaretten büyük bir mutluluk duyduğunu söyleyen İlçe Gençlik ve Spor Müdürü Ünlüsoy, Türk İzcisi'nin Çanakkale'de gövde göstermesinin önemine değindi...
Çanakkale'de yapılan faaliyetlerle ilgili bilgiler veren izciler, diğer illerden gelen 4 bin izciye Muğla bölgesini tanıtan bir kitap dağıttılar. İlçemizden 1 izci lideri ve 10 izcinin katıldığı faaliyete Muğla'dan da 37 izci katıldı. Çanakkale'de düzenlenen etkinliğe katılan izciler Ünlüsoy'a, bir bayrak, bir kitap ve bir de Çanakkale'de şehit düşen askerlerimizi anlatan poster hediye ettiler...
Yaptıkları ziyaretin izciler için çok iyi olduğunu belirten İzci Lideri Hafize Bacaksız Türk Bayrağı'nı Ünlüsoy'a teslim etti...
Banner ad space:sidebar_topSELECT `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-29"
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-29 06:02:07' and `ac`.`end_time` >= '2023-01-29 06:02:07'
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-01-29" and view_hour=06 and campaign_id=494update ad_view_stat set view_count=view_count+1 where id=1658202
Muğla'nın Marmaris ilçesinde kamyonetle otomobilin çarpışması sonucu 2'si orman...
Anket
Banner ad space:sidebar_bottomSELECT `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-29"
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-29 06:02:07' and `ac`.`end_time` >= '2023-01-29 06:02:07'
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-29" and view_hour=06 and campaign_id=502update ad_view_stat set view_count=view_count+1 where id=1658207