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:01:55' and `ac`.`end_time` >= '2023-01-29 09:01:55'
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=446checkstat select id from ad_view_stat where view_date="2023-01-29" and view_hour=09 and campaign_id=446update ad_view_stat set view_count=view_count+1 where id=1658312
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:01:55' and `ac`.`end_time` >= '2023-01-29 09:01:55'
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-29" and view_hour=09 and campaign_id=453update ad_view_stat set view_count=view_count+1 where id=1658313
MARMARİS'TE 1 MAYIS KUTLAMASI
1 Mayıs Emek ve Dayanışma Günü, Marmaris'te turistlerin de katılımıyla şenlik havasında...
1 Mayıs Emek ve Dayanışma Günü, Marmaris'te turistlerin de katılımıyla şenlik havasında kutlandı.
Öğlen saatlerinde Atatürk Meydanı'nda toplanan sendika, siyasi parti ve işçi örgütü temsilcileri ve işçiler, yapılan konuşmaların ardından geçtiğimiz yıllardaki 1 Mayıs kutlamalarında hayatını kaybedenler için denize karanfil attı.
Kutlamaya ilgi gösteren çok sayıda turist, fotoğraf makineleri ve kameralarıyla kutlama yapanları görüntülerken, bazılarının ise kalabalık içinde yer aldığı görüldü.
Meydanda davul zurna eşliğinde eğlenmeye başlayan vatandaşlar ve işçiler birlikte halay çekip, zeybek oynadı. Eğlenenleri ilgiyle izleyen turistler, bulundukları yerden oynayan işçilere eşlik etmeye çalıştı.
Kutlamaya baretleri ve çalışma kıyafetleriyle katılan işçiler dikkat çekti. Birçok ailenin çocuklarıyla birlikte katıldığı ve yaklaşık 1 saat süren kutlama, herhangi bir olay çıkmadan sona erdi.
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:01:55' and `ac`.`end_time` >= '2023-01-29 09:01:55'
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=419checkstat select id from ad_view_stat where view_date="2023-01-29" and view_hour=09 and campaign_id=419update ad_view_stat set view_count=view_count+1 where id=1658310
AK Parti Muğla Milletvekili M. Yavuz Demir ve Yelda Erol Gökcan, Milas’ta 100 bin...
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:01:55' and `ac`.`end_time` >= '2023-01-29 09:01:55'
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-01-29" and view_hour=09 and campaign_id=423update ad_view_stat set view_count=view_count+1 where id=1658311