English Partners

Partners

the Renaissance Society for the Development of Women

The Renaissance Society for the Development of Women

Aswan Governorate
Directorate of Social Affairs
Renaissance Society for the Development of the mirror Nazareth
Designated 526 for the year 1996

Communication and information technology service center for environment

The establishment of the Renaissance Society for the Development of Women Nazareth in August 1996 as an autonomous working with NGOs that provide services to women and children (children's clubs and religious seminars and health) and through a grant from the German Technical Cooperation Agency (GT button) for the project to improve Nasiriyah was built based independent Assembly To cover all health services and educational and cultural rights of women and child care.

Kenouz Sinai association for economic development and environment protection

Kenouz Sinai association for economic development and environment protection

Notarization No. 41 for the year 1996

Communication and information technology service center for environment

This is the first and main partner. It was notarized with No. 41 for the year 1995 in the area of Ra's Sedr, south Sinai and was the first association to be concerned with the rehabilitation of the immigrating young people from the valley to South Sinai and to enable them settle and establish new local communities with new ideology based on the cooperative work and application of the relevant technology.

Young Muslim Association

Young Muslim Association

Communication and information technology service center for environment

The young Muslim association is one of the associations that were established to serve the natives of the Rabaa Village, north Sinai, and its affiliate villages as much as possible. The association intended recently to promote the village in different fields including technology and communication, and increasing the ideological awareness of the young people, but it must cope with the age and this will only be made by technology.

Local Community Development Association in al Sharkawiya

Date of Notarization \ 398 for the year 1981

The local community development in al sharkawiya, shubra el khaima, works to develop the surrounding community comprehensively through its social, economic, health, cultural, environmental and religious programs that depend on better empowerment and it targets in its work the different social classes and pays particular attention to the child care and development, and tries to find fair equality between the different social classes and achieve stability and progress for society as a whole.

Vocational training and productive family association in Giza

Notarization No. 53 for the year 1973

The vocational training and productive family association is one of the associations working in the field of care and family with Notarization No. 53 for the year 1973 in the social solidarity directorate.

Local Community Development Association in al Kablat

Local Community Development Association in al Kablat

Notarization No. 504 for the year 1986

Partners of the Consulting Committees Project (ADF)

The local community development association in al kablat is a nongovernmental organization that works in the shubra el khaima area, kalioubiya governorate, and it was established in 1986 with Notarization No. 504. The association includes many experts and activists concerned with the community issues.

Local community Development Association in Abou el Saud

Local community Development Association in Abou el Saud

Notarization No. 4539 for the year 1998

Partners of the Consulting Committees Project (ADF)

Fixed Social Makki Center

This is a nongovernmental organization that works in the area of misr el kadima, Cairo, and was established in 1998 with Notarization No. 4539. The members of the general assembly are 68 including 14 women of those concerned with the community issues.

Community Development Association-Menyet El Rashid-Mutawbass-Kafr El Sheikh

Notarization No. 90 for the year 1969

In addition, the association completes the project of social integration, nongovernmental project consisting of the association members and natives and it adopts the project of circulating loans.

Institute of Cultural Affairs for Middle East & North Africa

Institute of Cultural Affairs for Middle East & North Africa

This institute was established in 1976 and its main focus of work is development. The institute aims at reaching the integral development and empowering the communities by concentrating on the human development and change of experiences among the different social classes to support and build it and to reach an integrated healthy community and create an active Egyptian human who can be able to contribute.

GENERAL ASSOCIATION FOR INTERNAL MIGRATION AND DEVELOPMENT (IMADA)

GENERAL ASSOCIATION FOR INTERNAL MIGRATION AND DEVELOPMENT (IMADA)

General NGO, Registration No. 450/2000

A central organization notarized with No. 450 for the year 2000 AD, and its main objective is to encourage the young people and population of the old valley in the different governorates to migrate to the areas of large national projects (Sinai-Toshka-South Valley-Sharq El Ouwainat-The New Valley) to contribute solve the problem of overpopulation in the governorates of Delta and to redistribute the population to solve the problem of unemployment. The board consists of fifteen members; most of them are teachers and experts who have long experience in the process of comprehensive development and training.

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.101 seconds (+0.101); 2.22 MB (+1.862) - afterInitialise
Application 0.117 seconds (+0.016); 2.71 MB (+0.497) - afterRoute
Application 0.681 seconds (+0.564); 4.37 MB (+1.656) - afterDispatch
Application 0.697 seconds (+0.015); 4.47 MB (+0.105) - beforeRenderModule mod_custom (English Footer Links and Copyright)
Application 0.703 seconds (+0.006); 4.49 MB (+0.014) - afterRenderModule mod_custom (English Footer Links and Copyright)
Application 0.703 seconds (+0.000); 4.49 MB (-0.001) - beforeRenderModule mod_custom (English Contact Info)
Application 0.712 seconds (+0.009); 4.50 MB (+0.013) - afterRenderModule mod_custom (English Contact Info)
Application 0.712 seconds (+0.000); 4.50 MB (+0.002) - beforeRenderModule mod_jevents_latest (English Latest Events)
Application 0.820 seconds (+0.107); 5.85 MB (+1.348) - afterRenderModule mod_jevents_latest (English Latest Events)
Application 0.820 seconds (+0.000); 5.84 MB (-0.006) - beforeRenderModule mod_banners (Partners)
Application 0.857 seconds (+0.036); 5.92 MB (+0.081) - afterRenderModule mod_banners (Partners)
Application 0.857 seconds (+0.000); 5.92 MB (-0.002) - beforeRenderModule mod_exmenu (English Left Sub Menu)
Application 0.886 seconds (+0.030); 6.38 MB (+0.453) - afterRenderModule mod_exmenu (English Left Sub Menu)
Application 0.887 seconds (+0.000); 6.37 MB (-0.007) - beforeRenderModule mod_exmenu (English Left Menu)
Application 0.914 seconds (+0.027); 6.79 MB (+0.420) - afterRenderModule mod_exmenu (English Left Menu)
Application 0.914 seconds (+0.000); 6.78 MB (-0.005) - beforeRenderModule mod_exmenu (English Top Tabs)
Application 0.928 seconds (+0.013); 6.84 MB (+0.058) - afterRenderModule mod_exmenu (English Top Tabs)
Application 0.928 seconds (+0.000); 6.84 MB (-0.006) - beforeRenderModule mod_exmenu (English Menu)
Application 0.982 seconds (+0.054); 7.00 MB (+0.166) - afterRenderModule mod_exmenu (English Menu)
Application 0.982 seconds (+0.000); 7.00 MB (-0.006) - beforeRenderModule mod_languages (lang)
Application 1.001 seconds (+0.019); 7.08 MB (+0.088) - afterRenderModule mod_languages (lang)
Application 1.008 seconds (+0.007); 7.12 MB (+0.037) - afterRender

Memory Usage

7.14 MB (7,483,536 Bytes)

38 Queries Logged

  1. SELECT `data`
      FROM `xnygc_session`
      WHERE `session_id` = 'qcrk9gjphj433of8bga9j66fu1'
  2. SELECT `session_id`
      FROM `xnygc_session`
      WHERE `session_id` = 'qcrk9gjphj433of8bga9j66fu1'
      LIMIT 0, 1
  3. INSERT INTO `xnygc_session` (`session_id`, `client_id`, `time`)
      VALUES ('qcrk9gjphj433of8bga9j66fu1', 0, 1695318250)
  4. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM xnygc_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  5. SELECT id, rules
      FROM `xnygc_viewlevels`
  6. 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
  7. SELECT *
      FROM xnygc_languages
      WHERE published=1
      ORDER BY ordering ASC
  8. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM xnygc_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  9. 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
  10. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM xnygc_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  11. 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
  12. SELECT a.rules
      FROM xnygc_assets AS a
      WHERE a.id = 1
  13. 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
  14. 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=9
      AND badcats.id is null
      AND (c.id=s.id OR c.language in ('en-GB','*'))
      GROUP BY c.id
      ORDER BY c.lft
  15. 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.9'
      ORDER BY b.lft
  16. 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 = 9
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-21 17:44:10')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-21 17:44:10')
      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
  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 = 9
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-21 17:44:10')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-21 17:44:10')
      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
  18. 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=9
      AND badcats.id is null
      AND (c.id=s.id OR c.language in ('en-GB','*'))
      GROUP BY c.id
      ORDER BY c.lft
  19. 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-09-21 17:44:11')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-21 17:44:11')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 128 OR mm.menuid <= 0)
      AND m.language IN ('en-GB','*')
      ORDER BY m.position, m.ordering
  20. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM xnygc_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_jevents'
  21. SHOW FULL COLUMNS
      FROM `xnygc_jev_users`
  22. 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
  23. 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
  24. 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 ))
  25. 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-09-21 20:44:11'
      AND rpt.startrepeat <= '2023-09-30 23:59:59'
      AND (rpt.startrepeat >= '2023-09-17 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-09-21 20:44:11'
      AND rpt2.startrepeat <= '2023-09-30 23:59:59') OR (rpt2.startrepeat <= '2023-09-21 20:44:11'
      AND rpt2.endrepeat > '2023-09-21 20:44:11'
      AND det.multiday=1) ) )
      GROUP BY ev.ev_id
      ORDER BY rpt.startrepeat
      LIMIT 5
  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-09-17 00:00:00'
      AND rpt.startrepeat <= '2023-09-21 20:44:11'
      AND (rpt.startrepeat >= '2023-09-17 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-09-21 20:44:11'
      AND rpt2.startrepeat >= '2023-09-17 00:00:00' )
      GROUP BY ev.ev_id
      ORDER BY rpt.startrepeat desc
      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-09-17 00:00:00'
      AND rpt.startrepeat <= '2023-09-21 20:44:11'
      AND (rpt.startrepeat <= '2023-09-17 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-09-21 20:44:11'
      AND rpt.endrepeat >= '2023-09-21 20:44:11'
      GROUP BY ev.ev_id
      ORDER BY rpt.startrepeat
      LIMIT 5
  28. 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)
  29. 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 (26)
      AND a.language in ('en-GB','*')
      ORDER BY a.sticky DESC,a.ordering
  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 (26)
      AND a.language in ('en-GB','*')
      ORDER BY a.sticky DESC,a.ordering
      LIMIT 0, 5
  31. UPDATE xnygc_banners
      SET impmade = (impmade + 1)
      WHERE id = 17
  32. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='english-menu'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  33. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='homeleftmenu-english'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  34. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='toptabs-english'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  35. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='english-menu'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  36. SELECT id,language
      FROM `xnygc_menu`
      WHERE home=1
  37. 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=128
  38. UPDATE `xnygc_session`
      SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1695318250;s:18:\"session.timer.last\";i:1695318250;s:17:\"session.timer.now\";i:1695318250;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` = 1695318251
      WHERE `session_id` = 'qcrk9gjphj433of8bga9j66fu1'

26 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:1695318250;s:18:\"session.timer.last\";i:1695318250;s:17:\"session.timer.now\";i:1695318250;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` = 1695318251
  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 ('qcrk9gjphj433of8bga9j66fu1', 0, 1695318250