English Objective
  • Enabling the Egyptian mankind and training him on the skill of the optimize use of the elements of dialogue and partnership to reach the best views of the general topics.
  • Create a link between concerned associations on one hand and beneficiary groups on the other hand, according to the topics of concern to the majority.
  • Draw the attention of decision-makers to marginalized groups, and delivery the problems of these groups, and the diagnosis and determine the causal factors and ways to solve them, using the scientific method based on dialogue and social surveys and discussion.
  • Raising awareness of the society – in general- of dangers in disregard the rights of marginalized groups and ignoring their legal existence, as well as other community groups of children, youth, the elderly and women.
  • Create links between the Forum and other associations interested in common issues on one hand and the donors on the other hand.
  • Building a database of information and literature dealing with social issues through the research unit.
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.352) - afterLoad
Application 0.132 seconds (+0.132); 2.21 MB (+1.862) - afterInitialise
Application 0.148 seconds (+0.015); 2.71 MB (+0.497) - afterRoute
Application 0.238 seconds (+0.091); 3.96 MB (+1.244) - afterDispatch
Application 0.253 seconds (+0.015); 4.06 MB (+0.108) - beforeRenderModule mod_custom (English Footer Links and Copyright)
Application 0.262 seconds (+0.009); 4.08 MB (+0.017) - afterRenderModule mod_custom (English Footer Links and Copyright)
Application 0.262 seconds (+0.000); 4.08 MB (-0.001) - beforeRenderModule mod_custom (English Contact Info)
Application 0.268 seconds (+0.007); 4.09 MB (+0.013) - afterRenderModule mod_custom (English Contact Info)
Application 0.269 seconds (+0.000); 4.10 MB (+0.002) - beforeRenderModule mod_jevents_latest (English Latest Events)
Application 0.360 seconds (+0.091); 5.44 MB (+1.348) - afterRenderModule mod_jevents_latest (English Latest Events)
Application 0.360 seconds (+0.000); 5.44 MB (-0.006) - beforeRenderModule mod_banners (Objective)
Application 0.383 seconds (+0.023); 5.55 MB (+0.114) - afterRenderModule mod_banners (Objective)
Application 0.384 seconds (+0.000); 5.55 MB (-0.001) - beforeRenderModule mod_exmenu (English Left Sub Menu)
Application 0.446 seconds (+0.063); 6.41 MB (+0.860) - afterRenderModule mod_exmenu (English Left Sub Menu)
Application 0.447 seconds (+0.000); 6.40 MB (-0.006) - beforeRenderModule mod_exmenu (English Left Menu)
Application 0.463 seconds (+0.017); 6.46 MB (+0.053) - afterRenderModule mod_exmenu (English Left Menu)
Application 0.463 seconds (+0.000); 6.45 MB (-0.005) - beforeRenderModule mod_exmenu (English Top Tabs)
Application 0.479 seconds (+0.015); 6.51 MB (+0.059) - afterRenderModule mod_exmenu (English Top Tabs)
Application 0.479 seconds (+0.000); 6.50 MB (-0.006) - beforeRenderModule mod_exmenu (English Menu)
Application 0.530 seconds (+0.051); 6.67 MB (+0.166) - afterRenderModule mod_exmenu (English Menu)
Application 0.530 seconds (+0.000); 6.66 MB (-0.006) - beforeRenderModule mod_languages (lang)
Application 0.551 seconds (+0.020); 6.75 MB (+0.088) - afterRenderModule mod_languages (lang)
Application 0.556 seconds (+0.006); 6.78 MB (+0.027) - afterRender

Memory Usage

6.79 MB (7,115,216 Bytes)

37 Queries Logged

  1. SELECT `data`
      FROM `xnygc_session`
      WHERE `session_id` = 'jbuj0a3h9icu949760tladb557'
  2. DELETE
      FROM `xnygc_session`
      WHERE `time` < 1695321415
  3. SELECT `session_id`
      FROM `xnygc_session`
      WHERE `session_id` = 'jbuj0a3h9icu949760tladb557'
      LIMIT 0, 1
  4. INSERT INTO `xnygc_session` (`session_id`, `client_id`, `time`)
      VALUES ('jbuj0a3h9icu949760tladb557', 0, 1695322315)
  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 a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,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
      FROM xnygc_content AS a
      LEFT JOIN xnygc_categories AS c
      on c.id = a.catid
      LEFT JOIN xnygc_users AS u
      on u.id = a.created_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 <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 4
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-21 18:51:55')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-21 18:51:55')
      AND (a.state = 1 OR a.state =2)
  16. 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=7
      AND badcats.id is null
      AND (c.id=s.id OR c.language in ('en-GB','*'))
      GROUP BY c.id
      ORDER BY c.lft
  17. UPDATE xnygc_content
      SET hits = hits + 1
      WHERE id = 4
  18. 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 18:51:55')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-21 18:51:55')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 114 OR mm.menuid <= 0)
      AND m.language IN ('en-GB','*')
      ORDER BY m.position, m.ordering
  19. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM xnygc_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_jevents'
  20. SHOW FULL COLUMNS
      FROM `xnygc_jev_users`
  21. 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
  22. 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
  23. 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 ))
  24. 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 21:51:55'
      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 21:51:55'
      AND rpt2.startrepeat <= '2023-09-30 23:59:59') OR (rpt2.startrepeat <= '2023-09-21 21:51:55'
      AND rpt2.endrepeat > '2023-09-21 21:51:55'
      AND det.multiday=1) ) )
      GROUP BY ev.ev_id
      ORDER BY rpt.startrepeat
      LIMIT 5
  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-17 00:00:00'
      AND rpt.startrepeat <= '2023-09-21 21:51:55'
      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 21:51:55'
      AND rpt2.startrepeat >= '2023-09-17 00:00:00' )
      GROUP BY ev.ev_id
      ORDER BY rpt.startrepeat desc
      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 21:51:55'
      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 21:51:55'
      AND rpt.endrepeat >= '2023-09-21 21:51:55'
      GROUP BY ev.ev_id
      ORDER BY rpt.startrepeat
      LIMIT 5
  27. 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)
  28. 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 (12)
      AND a.language in ('en-GB','*')
      ORDER BY a.sticky DESC,a.ordering
  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 (12)
      AND a.language in ('en-GB','*')
      ORDER BY a.sticky DESC,a.ordering
      LIMIT 0, 5
  30. UPDATE xnygc_banners
      SET impmade = (impmade + 1)
      WHERE id = 3
  31. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='english-menu'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  32. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='homeleftmenu-english'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  33. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='toptabs-english'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  34. SELECT m.*
      FROM xnygc_menu AS m
      WHERE menutype='english-menu'
      AND published = 1
      AND access IN (1,1)
      ORDER BY lft
  35. SELECT id,language
      FROM `xnygc_menu`
      WHERE home=1
  36. 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=114
  37. UPDATE `xnygc_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1695322315;s:18:\"session.timer.last\";i:1695322315;s:17:\"session.timer.now\";i:1695322315;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;}s:16:\"com_mailto.links\";a:1:{s:40:\"f30ed151b25364efad6bf762550e3d61752bb72e\";O:8:\"stdClass\":2:{s:4:\"link\";s:42:\"http://fdpdegypt.org/en/about-us/objective\";s:6:\"expiry\";i:1695322315;}}}', `time` = 1695322316
      WHERE `session_id` = 'jbuj0a3h9icu949760tladb557'

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM xnygc_extensions
  2. 4 × SELECT m.* FROM xnygc_menu AS m
  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. 2 × 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 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
  6. 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
  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 c.id FROM xnygc_categories AS c
  9. 1 × SELECT id,language FROM `xnygc_menu`
  10. 1 × SELECT * FROM xnygc_banners
  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 a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,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 FROM xnygc_content AS a LEFT JOIN xnygc_categories AS c on c.id = a.catid LEFT JOIN xnygc_users AS u on u.id = a.created_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
  13. 1 × SELECT folder AS type, element AS name, params FROM xnygc_extensions
  14. 1 × SELECT id, rules FROM `xnygc_viewlevels
  15. 1 × SELECT `session_id` FROM `xnygc_session`
  16. 1 × SELECT * FROM xnygc_languages
  17. 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
  18. 1 × SELECT `data` FROM `xnygc_session`
  19. 1 × SELECT a.rules FROM xnygc_assets AS a
  20. 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
  21. 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_banners SET impmade = (impmade + 1)
  2. 1 × UPDATE `xnygc_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1695322315;s:18:\"session.timer.last\";i:1695322315;s:17:\"session.timer.now\";i:1695322315;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;}s:16:\"com_mailto.links\";a:1:{s:40:\"f30ed151b25364efad6bf762550e3d61752bb72e\";O:8:\"stdClass\":2:{s:4:\"link\";s:42:\"http://fdpdegypt.org/en/about-us/objective\";s:6:\"expiry\";i:1695322315;}}}', `time` = 1695322316
  3. 1 × SHOW FULL COLUMNS FROM `xnygc_jev_users
  4. 1 × UPDATE xnygc_content SET hits = hits + 1
  5. 1 × INSERT INTO `xnygc_session` (`session_id`, `client_id`, `time`) VALUES ('jbuj0a3h9icu949760tladb557', 0, 1695322315
  6. 1 × DELETE FROM `xnygc_session`