English Members

The forum consists of a group of academicians’ practitioners, decision makers and intellectuals who are actively involved and interested about development and civic engagement and dialogue. It welcomes new members interested in getting involved and welling to actively participate in the process of sustainable development to achieve a better future to the nation.

To become a member of the FDPD, kindly fill the Become a member Form.

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.127 seconds (+0.127); 2.21 MB (+1.862) - afterInitialise
Application 0.143 seconds (+0.015); 2.71 MB (+0.497) - afterRoute
Application 0.229 seconds (+0.086); 3.95 MB (+1.241) - afterDispatch
Application 0.243 seconds (+0.014); 4.06 MB (+0.110) - beforeRenderModule mod_custom (English Footer Links and Copyright)
Application 0.251 seconds (+0.008); 4.08 MB (+0.017) - afterRenderModule mod_custom (English Footer Links and Copyright)
Application 0.251 seconds (+0.000); 4.08 MB (-0.001) - beforeRenderModule mod_custom (English Contact Info)
Application 0.258 seconds (+0.006); 4.09 MB (+0.013) - afterRenderModule mod_custom (English Contact Info)
Application 0.258 seconds (+0.000); 4.09 MB (+0.002) - beforeRenderModule mod_jevents_latest (English Latest Events)
Application 0.344 seconds (+0.086); 5.44 MB (+1.348) - afterRenderModule mod_jevents_latest (English Latest Events)
Application 0.344 seconds (+0.000); 5.43 MB (-0.008) - beforeRenderModule mod_custom (English Members Left Banner)
Application 0.348 seconds (+0.003); 5.44 MB (+0.003) - afterRenderModule mod_custom (English Members Left Banner)
Application 0.348 seconds (+0.000); 5.44 MB (-0.001) - beforeRenderModule mod_banners (Members)
Application 0.371 seconds (+0.023); 5.55 MB (+0.114) - afterRenderModule mod_banners (Members)
Application 0.371 seconds (+0.000); 5.55 MB (-0.001) - beforeRenderModule mod_exmenu (English Left Sub Menu)
Application 0.410 seconds (+0.039); 6.00 MB (+0.453) - afterRenderModule mod_exmenu (English Left Sub Menu)
Application 0.410 seconds (+0.000); 5.99 MB (-0.007) - beforeRenderModule mod_exmenu (English Left Menu)
Application 0.439 seconds (+0.029); 6.41 MB (+0.419) - afterRenderModule mod_exmenu (English Left Menu)
Application 0.439 seconds (+0.000); 6.41 MB (-0.005) - beforeRenderModule mod_exmenu (English Top Tabs)
Application 0.454 seconds (+0.015); 6.47 MB (+0.058) - afterRenderModule mod_exmenu (English Top Tabs)
Application 0.454 seconds (+0.000); 6.46 MB (-0.006) - beforeRenderModule mod_exmenu (English Menu)
Application 0.508 seconds (+0.054); 6.63 MB (+0.165) - afterRenderModule mod_exmenu (English Menu)
Application 0.508 seconds (+0.000); 6.62 MB (-0.006) - beforeRenderModule mod_languages (lang)
Application 0.529 seconds (+0.021); 6.71 MB (+0.088) - afterRenderModule mod_languages (lang)
Application 0.534 seconds (+0.005); 6.73 MB (+0.026) - afterRender

Memory Usage

6.74 MB (7,067,408 Bytes)

37 Queries Logged

  1. SELECT `data`
      FROM `xnygc_session`
      WHERE `session_id` = '1e6kprbg5u5rous8bja3vbpa21'
  2. DELETE
      FROM `xnygc_session`
      WHERE `time` < 1695320413
  3. SELECT `session_id`
      FROM `xnygc_session`
      WHERE `session_id` = '1e6kprbg5u5rous8bja3vbpa21'
      LIMIT 0, 1
  4. INSERT INTO `xnygc_session` (`session_id`, `client_id`, `time`)
      VALUES ('1e6kprbg5u5rous8bja3vbpa21', 0, 1695321313)
  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 = 17
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-21 18:35:13')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-21 18:35:13')
      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 = 17
  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:35:13')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-21 18:35:13')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 127 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:35:14'
      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:35:14'
      AND rpt2.startrepeat <= '2023-09-30 23:59:59') OR (rpt2.startrepeat <= '2023-09-21 21:35:14'
      AND rpt2.endrepeat > '2023-09-21 21:35:14'
      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:35:14'
      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:35:14'
      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:35:14'
      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:35:14'
      AND rpt.endrepeat >= '2023-09-21 21:35:14'
      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 (25)
      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 (25)
      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 = 16
  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=127
  37. UPDATE `xnygc_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1695321313;s:18:\"session.timer.last\";i:1695321313;s:17:\"session.timer.now\";i:1695321313;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:\"7be9010538d4d405942b59c5516adb02bed54730\";O:8:\"stdClass\":2:{s:4:\"link\";s:31:\"http://fdpdegypt.org/en/members\";s:6:\"expiry\";i:1695321313;}}}', `time` = 1695321314
      WHERE `session_id` = '1e6kprbg5u5rous8bja3vbpa21'

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:1695321313;s:18:\"session.timer.last\";i:1695321313;s:17:\"session.timer.now\";i:1695321313;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:\"7be9010538d4d405942b59c5516adb02bed54730\";O:8:\"stdClass\":2:{s:4:\"link\";s:31:\"http://fdpdegypt.org/en/members\";s:6:\"expiry\";i:1695321313;}}}', `time` = 1695321314
  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 ('1e6kprbg5u5rous8bja3vbpa21', 0, 1695321313
  6. 1 × DELETE FROM `xnygc_session`