05 Ara 2019
ABD'de 3 Türk Akademisyen, Yılın Mucitleri Listesine Girdi
ABD'de 3 Türk Akademisyen, Yılın Mucitleri Listesine Girdi

ABD Ulusal Mucitler Akademisi (NAI) tarafından dünyanın dört bir yanından seçilen 168 akademik mucit arasında 3 Türk akademisyen Prof. Dr. Aykut Üren, Prof. Dr. Mihri Özkan, Doç. Dr. Ebru Oral...

Read more
01 Ara 2019
Refik Anadol: Binalara Rüya Gördürüyor
Refik Anadol: Binalara Rüya Gördürüyor

Jimmy Cüneyt Gürkan - Son yüzyılın en önemli sanatçılarından biri olan Refik Anadol ile New York, Artechouse’ da gerçekleştirdiği muhteşem “Machine Hallucination” sergisinde buluştuk. Binalara rüya gördüren sanatçı, New York...

Read more
25 Kas 2019
Haluk Bilginer Emmy Ödüllerinde En İyi Erkek Oyuncu Seçildi
Haluk Bilginer Emmy Ödüllerinde En İyi Erkek Oyuncu Seçildi

47. Uluslararası Emmy Ödülleri, New York'ta düzenlenen törenle sahiplerini buldu. Emmy Ödülleri, televizyon yapımlarına verilen dünyanın en prestijli ödüllerinden. İnternet üzerinden yayınlanan Şahsiyet dizisi de Türkiye'de olduğu kadar başka ülkelerde de büyük...

Read more
25 Kas 2019
Smart Logistics'ten Clifton'da Kiralık Depo ve Ofis Yeri
Smart Logistics'ten Clifton'da Kiralık Depo ve Ofis Yeri

Online ticaretin her geçen gün büyümesi, perakende sektöründeki firmaların yaşadıkları sıkıntılar, girişimcileri daha fazla sanal dünyadaki iş kollarına yöneltirken, depo talebi de her geçen gün büyüyor. Amerikan Ticaret Bakanlığı verilerine...

Read more
22 Kas 2019
ABD'de Türk Öğrenci Sayısı 350 Azaldı
ABD'de Türk Öğrenci Sayısı 350 Azaldı

Amerika Birleşik Devletleri Uluslararası Eğitim Enstitüsü “Open Doors 2019” rapor yayınlayarak uluslararası öğrenci sayılarını verdi. Geçen yıl 1 milyon olan yabancı öğrenci sayısı bu yıl 1 milyon yüz bin olurken,...

Read more
21 Kas 2019
Amerika'dan Boğaziçi Otizm Klubüne Destek
Amerika'dan Boğaziçi Otizm Klubüne Destek

Boğaziçi Otizm Gençlik ve Spor Kulübü adına New York – New Jersey eyaletlerindeki Türk iş insanları tarafından yardım gecesi düzenlendi. Barsan Global Lojistik'in Amerika CEO'su Uğur Aksu'nun öncülük ettiği geceye...

Read more
19 Kas 2019
Beşinci TOA Ödülleri Washington DC’de Sahiplerini Buldu
Beşinci TOA Ödülleri Washington DC’de Sahiplerini Buldu

TOA Ödülleri sahiplerini buldu. TURKOFAMERICA Dergisi ve TOA Danışmanlık tarafından Amerika'daki başarılı isimlere 2014 yılından beri verilen ödüller bu yıl Amerikan Ticaret Odası’nın da işbirliği ile Washington, DC’de düzenlendi. Ödül...

Read more
04 Kas 2019
Beşinci TOA Ödülleri Washington DC’de Sahiplerini Buluyor
Beşinci TOA Ödülleri Washington DC’de Sahiplerini Buluyor

Amerika'daki başarılı isimlere 2014 yılından beri farklı kategorilerde ödüller veren TURKOFAMERICA Dergisi, bu yılki ödül alacakların isimlerini açıkladı. TOA Danışmanlık tarafından U.S. Chamber of Commerce iş birliği ile 5th TOA...

Read more
28 Eki 2019
Yüzyıllık Yanlızlık'ın Tiyatrosunda Bir Türk
Yüzyıllık Yanlızlık'ın Tiyatrosunda Bir Türk

Tiyatro sanatçısı ve aktris Desen Uygur, Kolombiya'nın dünyaca ünlü yazarı Gabriel García Márquez'in "Yüzyıllık Yalnızlık" adlı romandan sahneye uyarlanan 'The Rise And Fall Of Macondo' tiyatro oyununda başrol karakterlerinden birini...

Read more
22 Ağu 2019
SNC, Dornier Uçaklarını Almanya'da Üretecek
SNC, Dornier Uçaklarını Almanya'da Üretecek

TRJET projesi (yerli yolcu uçağı) kapandı. Almanya projeyi kaptı! Sahibi Türk olan ABD merkezli SNC, Türkiye'de üretim için Dornier 328'in haklarını almış ve ön anlaşma yapmıştı. Ancak nihai anlaşma sağlanamamıştı....

Read more
19 Ağu 2019
Band of Indigo Gorkemli Bir Şovla ABD Pazarında
Band of Indigo Gorkemli Bir Şovla ABD Pazarında

Chicago - Türk girişimciler tarafından kurulan Band of Indigo markası Amerika'da tüketiciler ile Chicago Collective Fuarı'nda buluştu. Amerika'nın efsane jaz gruplarından Allman Brothers'ın hayatta kalan tek üyesi olan Jaimoe'ya fuar...

Read more
05 Ağu 2019
Şehzade Abdül Kerim Efendi Mezarı Başında Anıldı
Şehzade Abdül Kerim Efendi Mezarı Başında Anıldı

1935 yılında New York'ta kaldığı otel odasında Japon istihbaratçılar tarafından öldürülen 2. Abdülhamid'in torunu Şehzade Abdülkerim Efendi, ölümünün 84. yılında Queens Mt Olivet'teki mezarı başında anıldı. Anma töreninde...

Read more

 





 

ABD'de 3 Türk Akademisyen, Yılın Mucitleri Listesine Girdi

turkiye nin gururu uc akademisyen 1575594002ABD Ulusal Mucitler Akademisi (NAI) tarafından dünyanın dört bir yanından seçilen 168 akademik mucit arasında 3 Türk akademisyen Prof. Dr. Aykut Üren, Prof. Dr. Mihri Özkan, Doç. Dr. Ebru Oral da yer aldı. Ulusal Mucitler Akademisi (NAI), yaşam kalitesi, ekonomik gelişme ve toplumun refahı üzerine olağanüstü buluşlar gerçekleştiren yılın akademisyenlerini açıkladı. Dünyanın dört bir yanından seçilen 168 mucit akademisyen arasında, çalışmalarına ABD’de devam eden 3 Türk de yer aldı. Georgetown Üniversitesi Tıp Fakültesi Onkoloji Bölümü öğretim üyesi Prof. Dr. Aykut Üren, California Üniversitesi Elektrik ve Bilgisayar Mühendisliği Bölümü Öğretim Üyesi Prof. Dr. Mihri Özkan ve Massachusetts Hastanesi Harris Ortopedi Laboratuvarı Yardımcı Direktörü Doç. Dr. Ebru Oral, yaptıkları araştırmalarla NAI 2019 akademisyenler listesinde yer aldı.

Devamını oku...

Refik Anadol: Binalara Rüya Gördürüyor

Refik Anadol4Jimmy Cüneyt Gürkan - Son yüzyılın en önemli sanatçılarından biri olan Refik Anadol ile New York, Artechouse’ da gerçekleştirdiği muhteşem “Machine Hallucination” sergisinde buluştuk. Binalara rüya gördüren sanatçı, New York şehrinin tüm hafızasını görsel ve işitsel olarak ziyaretçilere sunuyor. Dünyanın neresinde olursanız olun bir Refik Anadol sergisine rastlarsanız sanat ve teknolojinin birleştiği bu mükemmel deneyimi mutlaka yaşayın! 

Devamını oku...

Haluk Bilginer Emmy Ödüllerinde En İyi Erkek Oyuncu Seçildi

h 697047. Uluslararası Emmy Ödülleri, New York'ta düzenlenen törenle sahiplerini buldu. Emmy Ödülleri, televizyon yapımlarına verilen dünyanın en prestijli ödüllerinden. İnternet üzerinden yayınlanan Şahsiyet dizisi de Türkiye'de olduğu kadar başka ülkelerde de büyük beğeni kazanarak izlenmişti. Bu başarısı sayesinde, dizide rol alan Haluk Bilginer, en iyi erkek oyuncu ödülüne aday olarak gösterilmişti. Bilginer, Şahsiyet dizisindeki performansıyla aday gösterildiği en iyi erkek oyuncu ödülünü kazandı.

Devamını oku...

Smart Logistics'ten Clifton'da Kiralık Depo ve Ofis Yeri

AY0A2720Online ticaretin her geçen gün büyümesi, perakende sektöründeki firmaların yaşadıkları sıkıntılar, girişimcileri daha fazla sanal dünyadaki iş kollarına yöneltirken, depo talebi de her geçen gün büyüyor. Amerikan Ticaret Bakanlığı verilerine göre ABD online satış oranı 2018 yılında bir önceki yıla göre yüzde 14.3 büyüyerek 517 milyar dolara ulaştı. 2017 yılında online satış toplam cirosu 449 milyar dolar olmuştu. Toplam perakende sektörünün (benzin, otomobil, restoran dışında) 2018 yılındaki toplam hacmi ise 3.6 trilyon dolar oldu. Bir önceki yıla göre yüzde 3.9 arttı. 2018 sonu itibariyle 517 milyar dolar olan online satışlar şu an Amerika’da toplam perakende sektörünün yüzde 9’una karşılık geliyor. 2023 yılında bu rakamın 735 milyar dolara ulaşacağı tahmin ediliyor.

Devamını oku...

ABD'de Türk Öğrenci Sayısı 350 Azaldı

2019 11 22 06 41 19Amerika Birleşik Devletleri Uluslararası Eğitim Enstitüsü “Open Doors 2019” rapor yayınlayarak uluslararası öğrenci sayılarını verdi. Geçen yıl 1 milyon olan yabancı öğrenci sayısı bu yıl 1 milyon yüz bin olurken, Türkiye'den gelen öğrenci sayısında düşüş kaydedildi. Rapora göre, en fazla Yabancı öğrenci nufüs Çinlilerde. Amerika Birleşik Devletleri'nden Çin'den 369 bin 500 öğrenci gelirken, Hindistan'dan 202 bin öğrenci, Güney Kore'den 52 bin öğrenci eğitim için gelmiş. Raporda dikkat çeken başka bir ülke ise Suudi Arabistan. Suudi Arabistan Amerika Birleşik Devletleri'ne en fazla öğrenci gönderen Müslüman ülke. Suudi Arabistan 37 bin öğrenci ile en çok öğrenci gönderen ülkeler arasında ise 4. sırada. Kanada 26 bin öğrenci ile 5. sırada yer aldı.

Devamını oku...

Amerika'dan Boğaziçi Otizm Klubüne Destek

76610995 10212868157133523 8358783244585402368 oBoğaziçi Otizm Gençlik ve Spor Kulübü adına New York – New Jersey eyaletlerindeki Türk iş insanları tarafından yardım gecesi düzenlendi. Barsan Global Lojistik'in Amerika CEO'su Uğur Aksu'nun öncülük ettiği geceye 250'den fazla kişi katıldı. New Jersey'nin Weehawken şehrinde bulunan Chart House'da gerçekleştirilen gecenin açılışında bir konuşma yapan New York Başkonsolosu Alper Aktaş, böyle önemli ve anlamlı bir gecede hasta olmasına rağmen olmak istediğini söyledi. Gecede açık arttırmaya çıkarılan milli takım formasını alan kişiyle de özel olarak konutunda akşam yemeği yeme sözü verdi.

Devamını oku...

Beşinci TOA Ödülleri Washington DC’de Sahiplerini Buldu

49083112237 bc13904c87 cTOA Ödülleri sahiplerini buldu. TURKOFAMERICA Dergisi ve TOA Danışmanlık tarafından Amerika'daki başarılı isimlere 2014 yılından beri verilen ödüller bu yıl Amerikan Ticaret Odası’nın da işbirliği ile Washington, DC’de düzenlendi. Ödül alan isimler arasında Amerikan İçişleri eski Bakanı Ryan Zinke, Azerbaycan Washington DC Büyükelçisi Elin Süleymanov ve Pepsi Co. Kıdemli Başkan Yardımcısı Ümran Beba da yer aldı. Türk Hava Yolları’nın sponsorluğunda Outstanding Achievement Awards, Heritage + Diversity + Legacy + Business adıyla organize edilen törende, üç Türk sanatçının da eserleri sergilendi. Amerikan Ticaret Odası'nın tarihi binasındaki sergide Hulis Mavruk, Tony Şeker ve Esin Kösoğlu’nun eserleri büyük ilgi gördü.

Devamını oku...

Sayfa 1 / 424

  • «
  •  Başlangıç 
  •  Önceki 
  •  1 
  •  2 
  •  3 
  •  4 
  •  5 
  •  6 
  •  7 
  •  8 
  •  9 
  •  10 
  •  Sonraki 
  •  Son 
  • »
Yatırımı Yap Green Card'ı Al

Yatırımı Yap Green Card'ı Al

Barst Mukammal & Kleiner LLP hukuk firmasının ...

University of Minneasota'ya TCA'dan Dava

University of Minneasota'ya TCA'dan Dava

ABD’deki Türk lobisi kuruluşu Türk-Amerikan İttifa...

 

 

Üyeler
Son Aktiviteler
67 Ay Önce
Funda karakoc Yeni Bir Avatar Yükledi. Haz 26
77 Ay Önce
Ali Gunertem Yeni Bir Video Ekledi Dersimin Kayip Kizlari Hollywood Izi Eyl 03
Ali Gunertem Yeni Bir Video Ekledi NY Gezi Protestosu CNN Onu Eyl 03
 
Video Yorumları
  • MOD_VIDEOCOMMENTS NO COMMENTS
 

Profile Information

Application afterLoad: 0.001 seconds, 0.41 MB
Application afterInitialise: 0.038 seconds, 3.04 MB
Application afterRoute: 0.071 seconds, 4.96 MB
Application afterDispatch: 0.565 seconds, 7.47 MB
Application afterRender: 1.815 seconds, 14.86 MB

Memory Usage

15653640

Queries logged

  1. DELETE
      FROM jos_session
      WHERE ( time < '1579211796' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = 'j2s56qhevscn8vi7qg86i92qs2'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'j2s56qhevscn8vi7qg86i92qs2','1579271796','','0','1','0' )
  4. SELECT *
      FROM jos_components
      WHERE parent = 0
  5. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  6. SELECT count(*)
      FROM jos_menu_types
      WHERE `menutype`='magazine'
  7. SELECT `id`,`title`,`published`
      FROM  jos_sections
      WHERE `published`<>-2
  8. SELECT name,id,published,parent,link,home
      FROM `jos_menu`
      WHERE `menutype`='magazine'
      AND `published`<>-2
  9. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='17'
      AND `published`<>-2
  10. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='18'
      AND `published`<>-2
  11. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='19'
      AND `published`<>-2
  12. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='20'
      AND `published`<>-2
  13. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='21'
      AND `published`<>-2
  14. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='22'
      AND `published`<>-2
  15. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='15'
      AND `published`<>-2
  16. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='16'
      AND `published`<>-2
  17. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='30'
      AND `published`<>-2
  18. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='24'
      AND `published`<>-2
  19. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='25'
      AND `published`<>-2
  20. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='26'
      AND `published`<>-2
  21. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='27'
      AND `published`<>-2
  22. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='28'
      AND `published`<>-2
  23. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='29'
      AND `published`<>-2
  24. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='32'
      AND `published`<>-2
  25. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='35'
      AND `published`<>-2
  26. SELECT id,title,section
      FROM `jos_categories`
      WHERE `section`='34'
      AND `published`<>-2
  27. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  28. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 641)
      ORDER BY menuid DESC
      LIMIT 0, 1
  29. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:36' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:36' )
      ORDER BY  f.ordering
      LIMIT 0, 7
  30. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:36' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:36' )
      ORDER BY  f.ordering
  31. SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 641 OR mm.menuid = 0 )
      ORDER BY position, ordering
  32. SELECT parent, menutype, ordering
      FROM jos_menu
      WHERE id = 641
      LIMIT 1
  33. SELECT count(*)
      FROM jos_menu AS m

      WHERE menutype='magazine'
      AND published='1'
      AND access <= '0'
      AND parent=0
      AND ordering < 4
  34. SELECT params
      FROM jos_modules
      WHERE `module`='mod_janews2'
  35. SELECT *
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND cid = 3
      AND catid = 230
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
  36. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 13
  37. SELECT *
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND cid = 3
      AND catid = 230
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
  38. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 13
  39. SELECT *
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND cid = 3
      AND catid = 230
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
  40. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 13
  41. SELECT a.*,u.name AS authorname,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug

      FROM (
    SELECT created_by, MAX(created) AS maxcreated

      FROM jos_content AS x

      INNER JOIN jos_categories AS cc
      ON cc.id = x.catid

      INNER JOIN jos_sections AS s
      ON s.id = x.sectionid

      LEFT JOIN jos_content_frontpage AS f
      ON f.content_id = x.id

      WHERE x.state = 1
           
      AND (x.created_by=69 OR x.created_by=71 OR x.created_by=148 OR x.created_by=257)
           
      AND s.id > 0
           
      AND s.published = 1
           
      AND cc.published = 1
           
      AND (x.publish_up = '0000-00-00 00:00:00' OR x.publish_up <= '2020-01-17 14:36:36')
           
      AND (x.publish_down = '0000-00-00 00:00:00' OR x.publish_down >= '2020-01-17 14:36:36')
           
      AND (cc.id=143 OR cc.id=144 OR cc.id=145 OR cc.id=146 OR cc.id=147)
           
      AND (s.id=15)
           
      AND x.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
           
      AND f.content_id IS NULL

      GROUP BY created_by) AS b

      INNER JOIN jos_content AS a
      ON a.created_by = b.created_by
      AND a.created = b.maxcreated

      LEFT JOIN jos_users AS u
      ON u.id = a.created_by

      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
  42. SHOW TABLES LIKE 'jos_fb_%'
  43. SELECT *
      FROM jos_fb_config
  44. SELECT *
      FROM jos_fb_config
  45. SELECT *
      FROM jos_fb_users
      WHERE userid = '0'
  46. SELECT *
      FROM jos_fb_config
  47. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_kunena'
      AND published='1'
  48. SELECT id
      FROM jos_menu
      WHERE link LIKE 'index.php?option=com_community%'
      AND published='1'
      ORDER BY id ASC
      LIMIT 1
  49. SELECT *
      FROM jos_community_config
      WHERE name = 'config'
  50. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='0'
  51. SELECT template
      FROM jos_templates_menu
      WHERE client_id='0'
  52. SELECT l.id, l.time, l.thread, n.hits, count(m.id) AS `count`, l.subject, l.userid, l.name, l.catid, l.catname, l.unread, t.message

      FROM
    (SELECT m.time, m.thread, m.id, m.catid, m.userid, m.name, m.subject, c.name AS catname , 0 AS unread

      FROM jos_fb_messages AS m
            JOIN jos_fb_categories AS c
      ON m.catid = c.id
           
      WHERE c.published = 1
      AND m.hold = 0
      AND m.moved = 0
      AND c.pub_access IN (0,1,-1,18) 
      ORDER BY m.id DESC
      LIMIT 10) AS l
    JOIN jos_fb_messages AS m
      ON l.thread = m.thread
    JOIN jos_fb_messages AS n
      ON l.thread = n.id
    JOIN jos_fb_messages_text AS t
      ON l.id = t.mesid

      WHERE l.time >= m.time
      AND m.hold = 0
      AND m.moved = 0
      GROUP BY l.id
      ORDER BY l.id DESC
  53. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%option=com_community&view=profile%'
      AND `published`=1
  54. SELECT id
      FROM jos_menu
      WHERE `link` = 'index.php?option=com_community&view=frontpage'
      AND `published`=1
  55. SELECT `varname`, `value`, `default`
      FROM jos_mt_config
  56. SELECT l.*, cl.cat_id AS cat_id, c.cat_name AS category
     
      FROM (jos_mt_links AS l, jos_mt_cats AS c, jos_mt_cl AS cl)
     
      WHERE l.link_id = cl.link_id
      AND c.cat_id = cl.cat_id
      AND cl.main = 1
     
      AND link_published='1' && link_approved='1'
     
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2020-01-17 14:36:36'  )
     
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2020-01-17 14:36:36' )
     
      AND l.link_votes >= 1
     
      ORDER BY link_rating DESC, link_votes DESC 
     
      LIMIT 10
  57. SELECT id, title, `description`, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS slug
      FROM jos_sections s
      WHERE published = 1
      AND `id` IN (16,17,18,19,20,29)
  58. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=16
      LIMIT 0, 3
  59. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=99
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  60. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=100
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  61. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=101
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  62. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=17
      LIMIT 0, 3
  63. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=102
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  64. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=103
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  65. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=104
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  66. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=18
      LIMIT 0, 3
  67. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=105
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  68. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=106
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  69. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=107
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  70. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=19
      LIMIT 0, 3
  71. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=108
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  72. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=109
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  73. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=110
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  74. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=20
      LIMIT 0, 3
  75. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=157
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  76. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=158
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  77. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=148
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  78. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=29
      LIMIT 0, 3
  79. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=140
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  80. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=139
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  81. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=141
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  82. SELECT id, title, `description`, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS slug
      FROM jos_sections s
      WHERE published = 1
  83. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=17
      LIMIT 0, 3
  84. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=102
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  85. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=103
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  86. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=104
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  87. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=18
      LIMIT 0, 3
  88. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=105
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  89. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=106
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  90. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=107
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  91. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=19
      LIMIT 0, 3
  92. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=108
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  93. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=109
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  94. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=110
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  95. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=20
      LIMIT 0, 3
  96. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=157
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  97. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=158
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  98. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=148
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  99. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=21
      LIMIT 0, 3
  100. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=115
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  101. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=119
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  102. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=120
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  103. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=15
      LIMIT 0, 3
  104. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=144
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  105. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=146
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  106. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=147
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  107. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=16
      LIMIT 0, 3
  108. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=99
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  109. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=100
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  110. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=101
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  111. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=26
      LIMIT 0, 3
  112. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=130
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  113. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=177
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  114. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=178
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  115. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=29
      LIMIT 0, 3
  116. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=140
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  117. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=139
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  118. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=141
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  119. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=35
      LIMIT 0, 3
  120. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=196
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  121. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=197
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  122. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=198
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  123. SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
      FROM `jos_categories` s
      WHERE published = 1
      AND section=34
      LIMIT 0, 3
  124. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=194
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  125. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=193
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  126. SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON a.created_by = u.id
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-17 14:36:37' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-17 14:36:37' )
     
      AND cc.id=195
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 4
  127. SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      WHERE id = 219
      ORDER BY position, ordering
  128. SELECT
                                      `userid`
                                
      FROM
                                      `jos_community_users` AS a
                                
      INNER JOIN
                                     `jos_users` AS b
      ON a.userid=b.id
                                
      WHERE
                                      `thumb` != 'components/com_community/assets/default_thumb.jpg'
                                
      ORDER
                                      BY `points` DESC
                                
      LIMIT
                                      10
  129. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='143'
  130. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='148'
  131. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='167'
  132. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='112'
  133. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='169'
  134. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='69'
  135. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='180'
  136. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='223'
  137. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='94'
  138. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='187'
  139. SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      WHERE id = 217
      ORDER BY position, ordering
  140. SELECT a.*, TO_DAYS('2020-01-17 08:36:38') -  TO_DAYS( DATE_ADD(a.`created`, INTERVAL -6 HOUR ) ) AS 'daydiff' 
      FROM jos_community_activities AS a   
      WHERE   `archived`=0
      AND (a.`access` <= 10)
      ORDER BY a.`created` DESC
      LIMIT 40
  141. SELECT name
      FROM jos_plugins
      WHERE `element`='profile'
  142. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='310'
  143. SELECT name
      FROM jos_plugins
      WHERE `element`='videos'
  144. SELECT *
      FROM jos_community_videos
      WHERE id = '737'
  145. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%option=com_community&view=videos%'
      AND `published`=1
  146. SELECT name
      FROM jos_plugins
      WHERE `element`='videos'
  147. SELECT *
      FROM jos_community_videos
      WHERE id = '736'
  148. SELECT name
      FROM jos_plugins
      WHERE `element`='videos'
  149. SELECT *
      FROM jos_community_videos
      WHERE id = '735'
  150. SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      WHERE id = 218
      ORDER BY position, ordering
  151. SELECT *
      FROM jos_community_wall AS a
      INNER JOIN jos_community_videos AS b
      ON a.contentid=b.id
      WHERE a.type ='videos'
      ORDER BY a.date DESC
      LIMIT 5
  152. SELECT DISTINCT
                                    c.id AS ID,
                                    c.section AS SID,
                                    c.title AS name
                           
      FROM
                                    jos_categories AS c
                           
      LEFT JOIN
                                    jos_content AS content
                                   
      ON
                                    c.id = content.catid    
                           
      WHERE
                                    (  c.id = 102 )
                                   
      AND
                                    c.published = 1
                                   
      AND
                                    c.access <= 0;
  153. SELECT DISTINCT
                                    cats.title AS cat,
                                    users.name AS author,
                                    users.email AS author_email,
                                    cats.section AS SID,
                                    content.title AS title,
                                    content.introtext AS text,
                                    content.created AS date,
                                    content.publish_up AS date_publish,
                                content.images AS images,
                                    content.id AS IID,
                                    content.hits AS hits,
                                    content_rating.rating_sum AS rating_sum,
                                    content_rating.rating_count AS rating_count,
                                    CASE WHEN CHAR_LENGTH(content.alias)
                                            THEN CONCAT_WS(":", content.id, content.alias)
                                                    ELSE content.id END AS ID,
                                    CASE WHEN CHAR_LENGTH(cats.alias)
                                            THEN CONCAT_WS(":", cats.id, cats.alias)
                                                    ELSE cats.id END AS CID                                        
                           
      FROM
                                    jos_content AS content
                                   
      LEFT JOIN
                                            jos_categories AS categories
                                           
      ON categories.id = content.catid
                                   
                                   
      LEFT JOIN
                                            jos_sections AS sections
                                           
      ON sections.id = content.sectionid
                                   
      LEFT JOIN
                                            jos_users AS users
                                           
      ON users.id = content.created_by
                                   
      LEFT JOIN
                                            jos_content_frontpage AS frontpage
                                           
      ON content.id = frontpage.content_id       
                                   
      LEFT JOIN
                                            jos_categories AS cats
                                           
      ON content.catid = cats.id      
                                   
      LEFT JOIN
                                            jos_content_rating AS content_rating
                                           
      ON content_rating.content_id = content.id
                           
      WHERE
                                    content.state = 1
                                           
      AND categories.access <= 0
                                           
      AND content.access <= 0
                                            
      AND categories.published = 1 
                                           
      AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2020-01-17 14:36:36' )
                                           
      AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2020-01-17 14:36:36' )
                                   
      AND (  content.catid = 102 )
                                    
                                    
      AND content.created >= '2016-09-15 00:00:00'
                           
      ORDER BY
                                     content.created DESC
                           
      LIMIT
                                    0,12;
  154. SELECT *
      FROM jos_modules
      WHERE id='139'
  155. SELECT *
      FROM jos_modules
      WHERE id='139'
  156. SELECT *
      FROM jos_modules
      WHERE id='139'
  157. SELECT *
      FROM jos_modules
      WHERE id='139'
  158. SELECT *
      FROM jos_modules
      WHERE id='139'
  159. SELECT *
      FROM jos_modules
      WHERE id='139'
  160. SELECT *
      FROM jos_modules
      WHERE id='289'
  161. SELECT *
      FROM jos_modules
      WHERE id='289'
  162. SELECT *
      FROM jos_modules
      WHERE id='289'
  163. SELECT *
      FROM jos_modules
      WHERE id='289'
  164. SELECT *
      FROM jos_modules
      WHERE id='289'
  165. SELECT *
      FROM jos_modules
      WHERE id='289'
  166. SELECT *
      FROM jos_modules
      WHERE id='289'
  167. SELECT *
      FROM jos_modules
      WHERE id='289'
  168. SELECT *
      FROM jos_modules
      WHERE id='289'
  169. SELECT *
      FROM jos_modules
      WHERE id='289'
  170. SELECT *
      FROM jos_modules
      WHERE id='289'

Language Files Loaded

Untranslated Strings Diagnostic

Hiç

Untranslated Strings Designer

Hiç