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 09:53:53' and `ac`.`end_time` >= '2023-01-29 09:53:53'
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=357checkstat select id from ad_view_stat where view_date="2023-01-29" and view_hour=09 and campaign_id=357update ad_view_stat set view_count=view_count+1 where id=1658334
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 09:53:53' and `ac`.`end_time` >= '2023-01-29 09:53:53'
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=09 and campaign_id=392update ad_view_stat set view_count=view_count+1 where id=1658335
AMATÖR LİGLERDE GEÇTİĞİMİZ HAFTA
Muğla Süper Amatör Lig’de mücadele eden temsilcilerimizden Ortakent-Yahşi Gençlikspor...
Muğla Süper Amatör Lig’de mücadele eden temsilcilerimizden Ortakent-Yahşi Gençlikspor deplasmanda kazanırken, Turgutreisspor evinde mağlup oldu, Gümüşlük Gençlikspor ise hükmen galip sayıldı.
Geçtiğimiz Cuma günü Muğla’dan Bodrum’a gelirken trafik kazası geçiren Ortakent-Yahşi Gençlikspor, Seydikemer Belediyespor deplasmanında kazada yaralanan 4 oyuncusundan eksik olarak sahaya çıktı. Maça etkili başlayan ekip temsilcimiz Ortakent-Yahşi Gençlikspor olurken, dakikalar 20’yi gösterdiğinde Uğurcan’ın kafa vuruşu golü getirdi. İkinci yarıda da etkili oyununu sürdüren Ortakent-Yahşi Gençlikspor 65 ve 77’nci dakikalarda Gökhan Kabayel’in attığı goller ile karşılaşmayı 3-0 kazandı.
Süper Amatör Ligde mücadele eden ve şampiyonluğun en büyük adaylarından olan Gümüşlük Gençlikspor ise Ölüdeniz Belediyespor’un ligden çekilmesi dolayısıyla haftayı maç oynamadan 3 puanla kapattı.
Süper Amatör Lig’de mücadele eden diğer temsilcimiz Turgutreisspor ise Turgutreis’te oynanan karşılaşmada Muğla Üniversitesispor’a 2-0 mağlup oldu.
Bu hafta ligde alınan diğer sonuçlarla birlikte Gümüşlük Gençlikspor 13 puanla liderlik koltuğunda otururken, Ortakent-Yahşi Gençlikspor 10 puanla üçüncü, Turgutreisspor ise 9 puan ile dördüncü sırada bulunuyor.
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 09:53:53' and `ac`.`end_time` >= '2023-01-29 09:53:53'
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=09 and campaign_id=502update ad_view_stat set view_count=view_count+1 where id=1658323
Delfi Otel sahibi Mehmet Dağoğlu'nun girişimleriyle Bodrum'a gelen Kırsal Turizm...
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 09:53:53' and `ac`.`end_time` >= '2023-01-29 09:53:53'
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-29" and view_hour=09 and campaign_id=509update ad_view_stat set view_count=view_count+1 where id=1658326