English News

Activities, programs, news and reports

“Promoting the culture of using solar energy and integrated ecosystems” closing conference

The launch of “Promoting the culture of using solar energy and integrated ecosystems” closing conference activities at Al-Azhar University, under the generous patronage of the Grand Imam Prof. Dr. Ahmed Al-Tayeb “Sheikh of Al-Azhar Al-Sharif” and Ms. Dr. Nevin Al-Kabbaj “H.E. Minister of Social Solidarity”.

The launch of “Promoting the culture of using solar energy and integrated ecosystems” closing conference activities at Al-Azhar University

Implementation by: Forum of Dialogue and Participation for Development “FDPD”

Funded by: Global Environment Facility “GEF” - Small Grants Program “SGP”

 

The Conference was the closing to the project's activities of (Promoting the culture of Using Solar Energy and Integrated Ecosystems at Al-Azhar University), implemented by FPDP, and funded by the United Nations Development Program "UNDP", GEF and SGP - Egypt.

 

The Grand Imam Hall in the presidency building of Al-Azhar University in Nasr City hosted the activities of the project’s final conference, which was held under the patronage of the Grand Imam Prof. Dr. Ahmed Al-Tayeb “Sheikh of Al-Azhar Al-Sharif” and Ms. Dr. Nevin Al-Kabbaj “H.E. Minister of Social Solidarity”, in the presence of Prof. Dr. Mahmoud Seddik “Vice President of Al-Azhar University for Postgraduate Studies and Head of the Community Service & Environmental Development Committee at the university”. And also, in the presence of Dr. Emad El-Din Adly "SGP - National Director", Prof. Ayman Abdul Mawgood "The Assistant of the Minister of Social Solidarity Affairs for Civil Work Institutions", and Dr. Samar Youssef Sa’afan “FDPD - Chairman of Board of Directors”.

 

A group of university professors, public figures and representatives of governmental and civil organizations concerned with environmental issues participated in the conference, where a documentary film and review of the project's activities were presented that covered a period of a year and a half inside Al-Azhar University.

 

On the sidelines of the conference, the official inauguration of two solar power plants established on top of the main and administrative building of the university with a total capacity of 104.4 kilowatts was held. Also, a cooperation protocol was signed between Al-Azhar University and the Forum for Dialogue and Partnership for Development “FDPD to implement a strategic plan that ensures the sustainability of the project’s achieved results. The project activities included:

 

Two solar power plants established with a total capacity of 104.4 kilowatts.

Creating platform plants islands and planting dense shade trees inside the university campus.

Replacing regular neon bulbs with energy-saving LED bulbs inside the administrative offices in the main building, and regulating the lighting working hours system inside the building’s corridors with timer panels

 

Supply and installation of waste disposal units inside the university campus, as well as inside the main and administrative building

 

 

 

Developing and raising the efficiency of students’ sidewalk-seats and lighting them with solar energy, in addition of providing a USB unit to charge mobile phones using clean energy.

 

Implementation of 16 workshops for university employees, security personnel, housekeepers, male and female students to raise awareness of the integrated ecosystem model inside the university.

 

Supplying and installing water saving units in toilets of the main and administrative buildings.


Link to the Post on the forum's Facebook page:

https://www.facebook.com/fdpdegypt/posts/5460615863966460

 

 

The General Program

The existence of an older female announcer in The General Program as a member in the forum' board of trustees which will help to strengthen the efforts of the forum in the advocacy issue.

The chairman and board members provided technical support

The chairman of the forum of dialogue and partnership for development and some of board members provided technical support to organizations and associations working to address the issue of child labor, particularly working girls through training the cadres of these associations on planning for the advocacy campaigns, its preparation, its implementation and strategic plans of these associations, so that they can develop the performance of tasks in addressing this issue.

Food Contamination Issue

The Forum is a founding member of the "Hana and Shifa" network which adopte a project entitled "Food contamination issue", which seeks to activate the dialogue and participation in the enlightenment for the elimination of food contamination.

Environment Street

The Forum is a founding member of the NGOs network which adopt a project entitled " environment street "which seeks to activate dialogue and participation in the preservation of the environment.

National Committees

The Forum is member in many of the national committees, the most important one (National Committee for mine clearance, the participatory planning committee...).

Seminars to Discuss Important Law Drafts

The Forum held a series of seminars to discuss important law drafts that affect large segments of the citizens where they are hosting representatives of all parties - the government - members of the People's Assembly and Shura counsil - the media - NGOs - experts, and there are reports of each seminar with results available to decision makers and the media.

Subcategories

No events

Address: 11 El-Tobgy Street - Dokki - Giza : Fax: +202 333 728 92 : Tel: +202 374 829 23 : E-mail: This e-mail address is being protected from spambots. You need JavaScript enabled to view it. / This e-mail address is being protected from spambots. You need JavaScript enabled to view it.

Profile Information

Application 0.001 seconds (+0.001); 0.35 MB (+0.353) - afterLoad
Application 0.120 seconds (+0.119); 2.22 MB (+1.863) - afterInitialise
Application 0.134 seconds (+0.014); 2.71 MB (+0.497) - afterRoute
Application 0.282 seconds (+0.148); 4.34 MB (+1.628) - afterDispatch
Application 0.297 seconds (+0.015); 4.45 MB (+0.106) - beforeRenderModule mod_custom (English Footer Links and Copyright)
Application 0.303 seconds (+0.006); 4.46 MB (+0.014) - afterRenderModule mod_custom (English Footer Links and Copyright)
Application 0.303 seconds (+0.000); 4.46 MB (-0.001) - beforeRenderModule mod_custom (English Contact Info)
Application 0.311 seconds (+0.007); 4.47 MB (+0.013) - afterRenderModule mod_custom (English Contact Info)
Application 0.311 seconds (+0.000); 4.47 MB (+0.002) - beforeRenderModule mod_jevents_latest (English Latest Events)
Application 0.415 seconds (+0.104); 5.82 MB (+1.345) - afterRenderModule mod_jevents_latest (English Latest Events)
Application 0.415 seconds (+0.000); 5.81 MB (-0.008) - beforeRenderModule mod_custom (English Projects Left Banner)
Application 0.418 seconds (+0.003); 5.81 MB (+0.003) - afterRenderModule mod_custom (English Projects Left Banner)
Application 0.418 seconds (+0.001); 5.81 MB (-0.001) - beforeRenderModule mod_banners (News)
Application 0.543 seconds (+0.125); 5.89 MB (+0.081) - afterRenderModule mod_banners (News)
Application 0.543 seconds (+0.000); 5.89 MB (-0.001) - beforeRenderModule mod_exmenu (English Left Sub Menu)
Application 0.573 seconds (+0.029); 6.35 MB (+0.453) - afterRenderModule mod_exmenu (English Left Sub Menu)
Application 0.573 seconds (+0.000); 6.34 MB (-0.007) - beforeRenderModule mod_exmenu (English Left Menu)
Application 0.599 seconds (+0.026); 6.76 MB (+0.420) - afterRenderModule mod_exmenu (English Left Menu)
Application 0.599 seconds (+0.000); 6.75 MB (-0.005) - beforeRenderModule mod_exmenu (English Top Tabs)
Application 0.611 seconds (+0.012); 6.81 MB (+0.058) - afterRenderModule mod_exmenu (English Top Tabs)
Application 0.611 seconds (+0.000); 6.81 MB (-0.006) - beforeRenderModule mod_exmenu (English Menu)
Application 0.662 seconds (+0.051); 6.97 MB (+0.165) - afterRenderModule mod_exmenu (English Menu)
Application 0.662 seconds (+0.000); 6.97 MB (-0.006) - beforeRenderModule mod_languages (lang)
Application 0.679 seconds (+0.017); 7.05 MB (+0.088) - afterRenderModule mod_languages (lang)
Application 0.687 seconds (+0.008); 7.09 MB (+0.041) - afterRender

Memory Usage

7.1 MB (7,445,632 Bytes)

39 Queries Logged

  1. SELECT `data`
      FROM `xnygc_session`
      WHERE `session_id` = 'k84gr6h867t591ep8q58nqj016'
  2. DELETE
      FROM `xnygc_session`
      WHERE `time` < 1701360637
  3. SELECT `session_id`
      FROM `xnygc_session`
      WHERE `session_id` = 'k84gr6h867t591ep8q58nqj016'
      LIMIT 0, 1
  4. INSERT INTO `xnygc_session` (`session_id`, `client_id`, `time`)
      VALUES ('k84gr6h867t591ep8q58nqj016', 0, 1701361537)
  5. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM xnygc_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  6. SELECT id, rules
      FROM `xnygc_viewlevels`
  7. SELECT folder AS type, element AS name, params
      FROM xnygc_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  8. SELECT *
      FROM xnygc_languages
      WHERE published=1
      ORDER BY ordering ASC
  9. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM xnygc_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  10. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
      FROM xnygc_menu AS m
      LEFT JOIN xnygc_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
  11. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM xnygc_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  12. SELECT id, home, template, s.params
      FROM xnygc_template_styles as s
      LEFT JOIN xnygc_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
  13. SELECT a.rules
      FROM xnygc_assets AS a
      WHERE a.id = 1
  14. SELECT b.rules
      FROM xnygc_assets AS a
      LEFT JOIN xnygc_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content'
      ORDER BY b.lft
  15. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
      FROM xnygc_categories as c
      LEFT JOIN xnygc_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM xnygc_categories AS cat JOIN xnygc_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN `xnygc_content` AS i
      ON i.`catid` = c.id
      AND i.state = 1
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=32
      AND badcats.id is null
      AND (c.id=s.id OR c.language in ('en-GB','*'))
      GROUP BY c.id
      ORDER BY c.lft
  16. SELECT b.rules
      FROM xnygc_assets AS a
      LEFT JOIN xnygc_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content.category.32'
      ORDER BY b.lft
  17. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM xnygc_content AS a
      LEFT JOIN xnygc_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN xnygc_categories AS c
      ON c.id = a.catid
      LEFT JOIN xnygc_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN xnygc_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN xnygc_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN xnygc_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN xnygc_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM xnygc_categories AS cat JOIN xnygc_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1)
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid = 32
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-11-30 16:25:37')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-11-30 16:25:37')
      AND a.language in ('en-GB','*')
      AND (contact.language in ('en-GB','*') OR contact.language IS NULL)
      GROUP BY a.id
      ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created
      LIMIT 0, 15
  18. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM xnygc_content AS a
      LEFT JOIN xnygc_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN xnygc_categories AS c
      ON c.id = a.catid
      LEFT JOIN xnygc_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN xnygc_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN xnygc_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN xnygc_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN xnygc_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM xnygc_categories AS cat JOIN xnygc_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1)
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid = 32
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-11-30 16:25:37')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-11-30 16:25:37')
      AND a.language in ('en-GB','*')
      AND (contact.language in ('en-GB','*') OR contact.language IS NULL)
      GROUP BY a.id
      ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created
  19. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM xnygc_categories as c
      LEFT JOIN xnygc_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM xnygc_categories AS cat JOIN xnygc_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=32
      AND badcats.id is null
      AND (c.id=s.id OR c.language in ('en-GB','*'))
      GROUP BY c.id
      ORDER BY c.lft
  20. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM xnygc_modules AS m
      LEFT JOIN xnygc_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN xnygc_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-11-30 16:25:37')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-11-30 16:25:37')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 156 OR mm.menuid <= 0)
      AND m.language IN ('en-GB','*')
      ORDER BY m.position, m.ordering
  21. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM xnygc_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_jevents'
  22. SHOW FULL COLUMNS
      FROM `xnygc_jev_users`
  23. SELECT b.rules
      FROM xnygc_assets AS a
      LEFT JOIN xnygc_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_jevents'
      ORDER BY b.lft
  24. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM xnygc_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM xnygc_categories AS cat JOIN xnygc_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_jevents'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_jevents' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND badcats.id is null
      AND (c.language in ('en-GB','*'))
      GROUP BY c.id
      ORDER BY c.lft
  25. SELECT c.id
      FROM xnygc_categories AS c
      WHERE c.access IN (1,1)
      AND c.published = 1
      AND c.language in ('en-GB','*')
      AND c.extension = 'com_jevents'
      AND ((c.lft>=73
      AND c.rgt<=74 ))
  26. SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
      FROM xnygc_jevents_repetition as rpt
      LEFT JOIN xnygc_jevents_vevent as ev
      ON rpt.eventid = ev.ev_id
      LEFT JOIN xnygc_jevents_icsfile as icsf
      ON icsf.ics_id=ev.icsid
      LEFT JOIN xnygc_jevents_vevdetail as det
      ON det.evdet_id = rpt.eventdetail_id
      LEFT JOIN xnygc_jevents_rrule as rr
      ON rr.eventid = rpt.eventid
      WHERE ev.catid IN(-1,37)
      AND rpt.endrepeat >= '2023-11-30 19:25:37'
      AND rpt.startrepeat <= '2023-12-09 23:59:59'
      AND (rpt.startrepeat >= '2023-11-26 00:00:00' OR det.multiday=1)
      AND ev.state=1
      AND ev.access IN (1,1)
      AND icsf.state=1
      AND icsf.access IN (1,1)
      AND rpt.startrepeat=( SELECT MIN(startrepeat)
      FROM xnygc_jevents_repetition as rpt2
      WHERE rpt2.eventid=rpt.eventid
      AND ( (rpt2.startrepeat >= '2023-11-30 19:25:37'
      AND rpt2.startrepeat <= '2023-12-09 23:59:59') OR (rpt2.startrepeat <= '2023-11-30 19:25:37'
      AND rpt2.endrepeat > '2023-11-30 19:25:37'
      AND det.multiday=1) ) )
      GROUP BY ev.ev_id
      ORDER BY rpt.startrepeat
      LIMIT 5
  27. SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
      FROM xnygc_jevents_repetition as rpt
      LEFT JOIN xnygc_jevents_vevent as ev
      ON rpt.eventid = ev.ev_id
      LEFT JOIN xnygc_jevents_icsfile as icsf
      ON icsf.ics_id=ev.icsid
      LEFT JOIN xnygc_jevents_vevdetail as det
      ON det.evdet_id = rpt.eventdetail_id
      LEFT JOIN xnygc_jevents_rrule as rr
      ON rr.eventid = rpt.eventid
      WHERE ev.catid IN(-1,37)
      AND rpt.endrepeat >= '2023-11-26 00:00:00'
      AND rpt.startrepeat <= '2023-11-30 19:25:37'
      AND (rpt.startrepeat >= '2023-11-26 00:00:00' OR det.multiday=1)
      AND ev.state=1
      AND ev.access IN (1,1)
      AND icsf.state=1
      AND icsf.access IN (1,1)
      AND rpt.startrepeat=( SELECT MAX(startrepeat)
      FROM xnygc_jevents_repetition as rpt2
      WHERE rpt2.eventid=rpt.eventid
      AND rpt2.startrepeat <= '2023-11-30 19:25:37'
      AND rpt2.startrepeat >= '2023-11-26 00:00:00' )
      GROUP BY ev.ev_id
      ORDER BY rpt.startrepeat desc
      LIMIT 5
  28. SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
      FROM xnygc_jevents_repetition as rpt
      LEFT JOIN xnygc_jevents_vevent as ev
      ON rpt.eventid = ev.ev_id
      LEFT JOIN xnygc_jevents_icsfile as icsf
      ON icsf.ics_id=ev.icsid
      LEFT JOIN xnygc_jevents_vevdetail as det
      ON det.evdet_id = rpt.eventdetail_id
      LEFT JOIN xnygc_jevents_rrule as rr
      ON rr.eventid = rpt.eventid
      WHERE ev.catid IN(-1,37)
      AND rpt.endrepeat >= '2023-11-26 00:00:00'
      AND rpt.startrepeat <= '2023-11-30 19:25:37'
      AND (rpt.startrepeat <= '2023-11-26 00:00:00'OR det.multiday=1)
      AND ev.state=1
      AND ev.access IN (1,1)
      AND icsf.state=1
      AND icsf.access IN (1,1)
      AND rpt.startrepeat <= '2023-11-30 19:25:37'
      AND rpt.endrepeat >= '2023-11-30 19:25:37'
      GROUP BY ev.ev_id
      ORDER BY rpt.startrepeat
      LIMIT 5
  29. SELECT *
      FROM xnygc_banners
      WHERE NOW() >= `reset`
      AND `reset` != '0000-00-00 00:00:00'
      AND `reset`!=NULL
      AND (`checked_out` = 0 OR `checked_out` = 0)
  30. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
      FROM xnygc_banners as a
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.catid IN (33)
      AND a.language in ('en-GB','*')
      ORDER BY a.sticky DESC,a.ordering
  31. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
      FROM xnygc_banners as a
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.catid IN (33)
      AND a.language in ('en-GB','*')
      ORDER BY a.sticky DESC,a.ordering
      LIMIT 0, 5
  32. UPDATE xnygc_banners
      SET impmade = (impmade + 1)
      WHERE id = 23
  33. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='english-menu'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  34. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='homeleftmenu-english'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  35. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='toptabs-english'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  36. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='english-menu'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  37. SELECT id,language
      FROM `xnygc_menu`
      WHERE home=1
  38. SELECT m2.language, m2.id
      FROM xnygc_menu as m
      LEFT JOIN xnygc_associations as a
      ON a.id=m.id
      AND a.context='com_menus.item'
      LEFT JOIN xnygc_associations as a2
      ON a.key=a2.key
      LEFT JOIN xnygc_menu as m2
      ON a2.id=m2.id
      WHERE m.id=156
  39. UPDATE `xnygc_session`
      SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1701361537;s:18:\"session.timer.last\";i:1701361537;s:17:\"session.timer.now\";i:1701361537;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}', `time` = 1701361537
      WHERE `session_id` = 'k84gr6h867t591ep8q58nqj016'

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 4 × SELECT m.* FROM xnygc_menu AS m
  2. 4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM xnygc_extensions
  3. 3 × SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn FROM xnygc_jevents_repetition as rpt LEFT JOIN xnygc_jevents_vevent as ev ON rpt.eventid = ev.ev_id LEFT JOIN xnygc_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid LEFT JOIN xnygc_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id LEFT JOIN xnygc_jevents_rrule as rr ON rr.eventid = rpt.eventid
  4. 3 × SELECT b.rules FROM xnygc_assets AS a LEFT JOIN xnygc_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  5. 2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM xnygc_content AS a LEFT JOIN xnygc_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN xnygc_categories AS c ON c.id = a.catid LEFT JOIN xnygc_users AS ua ON ua.id = a.created_by LEFT JOIN xnygc_users AS uam ON uam.id = a.modified_by LEFT JOIN xnygc_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN xnygc_categories as parent ON parent.id = c.parent_id LEFT JOIN xnygc_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM xnygc_categories AS cat JOIN xnygc_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  6. 2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions FROM xnygc_banners as a
  7. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM xnygc_categories as c LEFT JOIN (SELECT cat.id as id FROM xnygc_categories AS cat JOIN xnygc_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  8. 1 × SELECT m2.language, m2.id FROM xnygc_menu as m LEFT JOIN xnygc_associations as a ON a.id=m.id AND a.context='com_menus.item' LEFT JOIN xnygc_associations as a2 ON a.key=a2.key LEFT JOIN xnygc_menu as m2 ON a2.id=m2.id
  9. 1 × SELECT id,language FROM `xnygc_menu`
  10. 1 × SELECT c.id FROM xnygc_categories AS c
  11. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM xnygc_modules AS m LEFT JOIN xnygc_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN xnygc_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
  12. 1 × SELECT * FROM xnygc_banners
  13. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROM xnygc_categories as c LEFT JOIN xnygc_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM xnygc_categories AS cat JOIN xnygc_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  14. 1 × SELECT folder AS type, element AS name, params FROM xnygc_extensions
  15. 1 × SELECT id, rules FROM `xnygc_viewlevels
  16. 1 × SELECT `session_id` FROM `xnygc_session`
  17. 1 × SELECT * FROM xnygc_languages
  18. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM xnygc_menu AS m LEFT JOIN xnygc_extensions AS e ON m.component_id = e.extension_id
  19. 1 × SELECT `data` FROM `xnygc_session`
  20. 1 × SELECT a.rules FROM xnygc_assets AS a
  21. 1 × SELECT id, home, template, s.params FROM xnygc_template_styles as s LEFT JOIN xnygc_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  22. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM xnygc_categories as c LEFT JOIN xnygc_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM xnygc_categories AS cat JOIN xnygc_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
OTHER Tables:
  1. 1 × UPDATE `xnygc_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1701361537;s:18:\"session.timer.last\";i:1701361537;s:17:\"session.timer.now\";i:1701361537;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}', `time` = 1701361537
  2. 1 × UPDATE xnygc_banners SET impmade = (impmade + 1)
  3. 1 × SHOW FULL COLUMNS FROM `xnygc_jev_users
  4. 1 × INSERT INTO `xnygc_session` (`session_id`, `client_id`, `time`) VALUES ('k84gr6h867t591ep8q58nqj016', 0, 1701361537
  5. 1 × DELETE FROM `xnygc_session`