logoinstituto.jpg

Instituto

Directores

El Instituto es un Centro Privado de Salud Mental, autorizado por la Consejería de Salud de la Junta de Andalucía, para realizar actividades de formación y asistencia en el campo de la psicología, los directores y propietarios del mismo son:

Javier Rodríguez Escobar

  • Psicólogo Especialista en Psicología Clínica. Psicoanalista.
  • Miembro de la Sociedad Forum de Psicoterapia Psicoanalítica
  • Presidente de la Sociedad Andaluza de Rorschach y Métodos Proyectivos
  • Miembro de la Sociedad Española y de la Sociedad Internacional del Rorschach y Métodos Proyectivos.
  • Miembro de la Asociación Europea de Rorschach
  • Miembro del Instituto de Estudios Psicosomáticos y Psicoterapia Psicoanalítica
  • Psicoterapeuta acreditado por la Federación Española de Asociaciones de Psicoterapéutas
  • Presidente de la Sociedad Española de Psicología de Emergencias y Catástrofes
  • Su formación incluye las modalidades terapéuticas de Psicoanálisis, Psicoterapia Psicoanalítica y Terapia Breve
  • Director de la Unidad Isis, especializada en intervenciónes de urgencias, emergencias y catástrofes

Pilar Távora Ferrer

  • Psicóloga Especialista en Psicología Clínica. Psicoanalista
  • Miembro de la Sociedad Forum de Psicoterapia Psicoanalítica
  • Psicoterapeuta psicoanalítica acredita por la Federación Europea de Asociaciones de Psicoterapeutas
  • Miembro de la Sociedad Andaluza de Rorschach y Métodos Proyectivos
  • Su formación incluye las modalidades terapéuticas de Psicoanálisis, Psicoterapia Psicoanalítica y Terapia Breve

 

Aviso

Autoridad

 

Nuestro foro está moderado sobre una base semanal . Los moderadores y administradores son voluntarios .

El administrador utiliza el nick de Javier, y puede contactar con él en el correo This e-mail address is being protected from spambots. You need JavaScript enabled to view it.

El administrador es profesional de la salud, psicólogo especialistra en psicología clínica. Los moderadores no tienen por qué serlo .

 

Complementariedad

La información proporcionada en este foro está dirigida a complementar, no a reemplazar, la relación directa entre los pacientes y los profesionales de la salud .

 

Privacidad

Le recordamos que cualquier mensaje se puede leer , utilizar, reproducir y citado por todos. No tienes la opción de borrar los mensajes. Sin embargo , en circunstancias excepcionales , puede ponerse en contacto con los moderadores para hacerlo. Las referencias que proporcione para sus mensajes no se pueden borrar . Por lo tanto , por favor tenga cuidado acerca de la información que publique .

 

Mensajes

Los moderadores y miembros deben conducirse en todo momento con respeto y honestidad. Cualquier mensaje que falte al respeto a los foreros o que implica dar información no avalada empíricamente y que pueda poner en riesgo la salud mental o física de las personas, será inmediatamente eliminado

Mediante el uso de nuestros foros, usted está de acuerdo para publicar información que sea verdadera y correcta a lo mejor de su conocimiento y es de su experiencia personal. Si la información que publica no es la experiencia personal , le solicitamos que nos proporcione fuentes ( referencias , enlaces, etc . ) Siempre que sea pertinente y posible .

No se permite publicar anuncios, ya sea en forma de enlaces de texto o banners, ni ningún tipo de publicidad 

Los moderadores se reservan el derecho de eliminar los mensajes que considere inapropiados sin notificar al autor. En los casos de abuso, los moderadores se reservan el derecho de prohibir a un miembro del foro . En ambos casos , se le enviará un mensaje al usuario, explicando los motivos por el que ha sido baneado .

Educación Maternal

Actividades Sociales

Actividades sociales:

Próximamente  Cineforum y tertulias

Grupos de Adopción

Grupos para madres adoptivas

Profesores


El Instituto contrata los profesores en función de los cursos que se vayan a impartir, pero todos están dirigidos por los directores del Centro:    Pilar Távora Ferrer y Javier Rodríguez Escobar, psicólogos especialistas en psicología clínica,  especialistas en psicoterapia (EFPA) y con amplia experiencia docente, acumulan más 7.000 horas de clases impartidas , más de 4.000 horas de formación postgraduada acreditada y 20 años de experiencia clínica

Joomla templates by a4joomla

Profile Information

Application 0.001 seconds (+0.001); 0.57 MB (+0.568) - afterLoad
Application 0.025 seconds (+0.024); 3.09 MB (+2.520) - afterInitialise
Application 0.029 seconds (+0.005); 3.80 MB (+0.710) - afterRoute
Application 0.064 seconds (+0.035); 6.68 MB (+2.879) - afterDispatch
Application 0.067 seconds (+0.003); 6.83 MB (+0.153) - beforeRenderModule mod_articles_news (Comunicados)
Application 0.072 seconds (+0.004); 6.96 MB (+0.130) - afterRenderModule mod_articles_news (Comunicados)
Application 0.072 seconds (+0.000); 6.89 MB (-0.066) - beforeRenderModule mod_articles_latest (Últimas noticias)
Application 0.078 seconds (+0.006); 7.16 MB (+0.262) - afterRenderModule mod_articles_latest (Últimas noticias)
Application 0.078 seconds (+0.000); 6.95 MB (-0.204) - beforeRenderModule mod_menu (Main Menu)
Application 0.088 seconds (+0.009); 7.07 MB (+0.116) - afterRenderModule mod_menu (Main Menu)
Application 0.088 seconds (+0.000); 7.06 MB (-0.008) - beforeRenderModule mod_virtuemart_cart (Carro de Compra)
Application 0.112 seconds (+0.025); 9.62 MB (+2.561) - afterRenderModule mod_virtuemart_cart (Carro de Compra)
Application 0.112 seconds (+0.000); 9.62 MB (-0.004) - beforeRenderModule mod_login (Login Form)
Application 0.114 seconds (+0.002); 9.65 MB (+0.031) - afterRenderModule mod_login (Login Form)
Application 0.115 seconds (+0.000); 9.65 MB (-0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.116 seconds (+0.001); 9.67 MB (+0.024) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.117 seconds (+0.001); 9.74 MB (+0.066) - afterRender

Memory Usage

9.77 MB (10,245,600 Bytes)

35 Queries Logged

  1. SELECT `data`
      FROM `j25_session`
      WHERE `session_id` = 'i9esol14hg708ra8oe4klhl2f7'
  2. SELECT `session_id`
      FROM `j25_session`
      WHERE `session_id` = 'i9esol14hg708ra8oe4klhl2f7'
      LIMIT 0, 1
  3. INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
      VALUES ('i9esol14hg708ra8oe4klhl2f7', 0, 1490271524)
  4. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j25_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  5. SELECT id, rules
      FROM `j25_viewlevels`
  6. SELECT folder AS type, element AS name, params
      FROM j25_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  7. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j25_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  8. 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 j25_menu AS m
      LEFT JOIN j25_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
  9. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM j25_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  10. SELECT *
      FROM j25_languages
      WHERE published=1
      ORDER BY ordering ASC
  11. SELECT id, home, template, s.params
      FROM j25_template_styles as s
      LEFT JOIN j25_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 j25_assets AS a
      WHERE a.id = 1
  13. SELECT b.rules
      FROM j25_assets AS a
      LEFT JOIN j25_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 j25_categories as c
      LEFT JOIN j25_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 j25_categories AS cat JOIN j25_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 `j25_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=36
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  15. SELECT b.rules
      FROM j25_assets AS a
      LEFT JOIN j25_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content.category.36'
      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 j25_content AS a
      LEFT JOIN j25_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN j25_categories AS c
      ON c.id = a.catid
      LEFT JOIN j25_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j25_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN j25_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN j25_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j25_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_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 = 36
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-03-23 12:18:44')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-03-23 12:18:44')
      GROUP BY a.id
      ORDER BY fp.ordering, a.created
      LIMIT 0, 10
  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 j25_content AS a
      LEFT JOIN j25_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN j25_categories AS c
      ON c.id = a.catid
      LEFT JOIN j25_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j25_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN j25_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN j25_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j25_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_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 = 36
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-03-23 12:18:44')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-03-23 12:18:44')
      GROUP BY a.id
      ORDER BY fp.ordering, 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 j25_categories as c
      LEFT JOIN j25_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 j25_categories AS cat JOIN j25_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=45
      AND badcats.id is null
      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 j25_modules AS m
      LEFT JOIN j25_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN j25_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 <= '2017-03-23 12:18:44')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-03-23 12:18:44')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 146 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  20. SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,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 j25_content AS a
      LEFT JOIN j25_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN j25_categories AS c
      ON c.id = a.catid
      LEFT JOIN j25_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j25_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN j25_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN j25_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j25_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_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 CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid IN (3)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-03-23 12:18:44')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-03-23 12:18:44')
      GROUP BY a.id
      ORDER BY a.publish_up DESC
      LIMIT 0, 5
  21. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM j25_categories as c
      LEFT JOIN j25_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 j25_categories AS cat JOIN j25_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=3
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  22. 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 j25_content AS a
      LEFT JOIN j25_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN j25_categories AS c
      ON c.id = a.catid
      LEFT JOIN j25_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j25_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN j25_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN j25_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j25_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_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 CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-03-23 12:18:44')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-03-23 12:18:44')
      GROUP BY a.id
      ORDER BY a.created DESC
      LIMIT 0, 5
  23. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM j25_categories as c
      LEFT JOIN j25_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 j25_categories AS cat JOIN j25_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=31
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  24. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM j25_categories as c
      LEFT JOIN j25_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 j25_categories AS cat JOIN j25_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=47
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  25. SHOW TABLES LIKE "j25_virtuemart_configs"
  26. SELECT `config`
      FROM `j25_virtuemart_configs`
      WHERE `virtuemart_config_id` = "1";
  27. SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
      FROM `j25_virtuemart_vendors` AS v
      LEFT JOIN `j25_virtuemart_currencies` AS c
      ON virtuemart_currency_id = vendor_currency
      WHERE v.`virtuemart_vendor_id`="1"
  28. SELECT *
      FROM `j25_virtuemart_currencies`
      WHERE `virtuemart_currency_id`="47"
  29. SELECT `price_display`,`custom_price_display`
      FROM `j25_virtuemart_shoppergroups` AS `sg`
      WHERE `sg`.`default` = "2"
  30. SELECT *
      FROM `j25_virtuemart_shoppergroups`
      WHERE `default` = "2"
      AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
      AND `published`="1"
  31. SELECT *
      FROM j25_virtuemart_calcs
      WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
      AND `published`="1"
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
      AND ( ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2017-03-23 12:18:44" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2017-03-23 12:18:44" ) OR `for_override` = "1" )
  32. SELECT *
      FROM j25_virtuemart_calcs
      WHERE `calc_kind`="DBTaxBill"
      AND `published`="1"
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
      AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2017-03-23 12:18:44" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2017-03-23 12:18:44" )
  33. SELECT *
      FROM j25_virtuemart_calcs
      WHERE `calc_kind`="TaxBill"
      AND `published`="1"
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
      AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2017-03-23 12:18:44" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2017-03-23 12:18:44" )
  34. SELECT *
      FROM j25_virtuemart_calcs
      WHERE `calc_kind`="DATaxBill"
      AND `published`="1"
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
      AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2017-03-23 12:18:44" )
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2017-03-23 12:18:44" )
  35. UPDATE `j25_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1490271524;s:18:\"session.timer.last\";i:1490271524;s:17:\"session.timer.now\";i:1490271524;s:24:\"session.client.forwarded\";s:14:\"54.157.226.227\";s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://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;s:1:\"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:13:\"session.token\";s:32:\"ac6f318a2ff9c6aab932332166df989a\";}', `time` = 1490271524
      WHERE `session_id` = 'i9esol14hg708ra8oe4klhl2f7'

24 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 4 × SELECT * FROM j25_virtuemart_calcs
  2. 4 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM j25_categories as c LEFT JOIN j25_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 j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  3. 3 × 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 j25_content AS a LEFT JOIN j25_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN j25_categories AS c ON c.id = a.catid LEFT JOIN j25_users AS ua ON ua.id = a.created_by LEFT JOIN j25_users AS uam ON uam.id = a.modified_by LEFT JOIN j25_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN j25_categories as parent ON parent.id = c.parent_id LEFT JOIN j25_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  4. 3 × SELECT extension_id AS "id", element AS "option", params, enabled FROM j25_extensions
  5. 2 × SELECT b.rules FROM j25_assets AS a LEFT JOIN j25_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  6. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j25_modules AS m LEFT JOIN j25_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j25_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
  7. 1 × SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,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 j25_content AS a LEFT JOIN j25_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN j25_categories AS c ON c.id = a.catid LEFT JOIN j25_users AS ua ON ua.id = a.created_by LEFT JOIN j25_users AS uam ON uam.id = a.modified_by LEFT JOIN j25_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN j25_categories as parent ON parent.id = c.parent_id LEFT JOIN j25_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  8. 1 × SELECT * FROM `j25_virtuemart_currencies`
  9. 1 × SELECT * FROM `j25_virtuemart_shoppergroups`
  10. 1 × SELECT `price_display`,`custom_price_display` FROM `j25_virtuemart_shoppergroups` AS `sg`
  11. 1 × SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code` FROM `j25_virtuemart_vendors` AS v LEFT JOIN `j25_virtuemart_currencies` AS c ON virtuemart_currency_id = vendor_currency
  12. 1 × SELECT `config` FROM `j25_virtuemart_configs`
  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 j25_categories as c LEFT JOIN j25_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 j25_categories AS cat JOIN j25_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  14. 1 × SELECT folder AS type, element AS name, params FROM j25_extensions
  15. 1 × SELECT id, rules FROM `j25_viewlevels
  16. 1 × SELECT `session_id` FROM `j25_session`
  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 j25_menu AS m LEFT JOIN j25_extensions AS e ON m.component_id = e.extension_id
  18. 1 × SELECT * FROM j25_languages
  19. 1 × SELECT a.rules FROM j25_assets AS a
  20. 1 × SELECT id, home, template, s.params FROM j25_template_styles as s LEFT JOIN j25_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  21. 1 × SELECT `data` FROM `j25_session`
OTHER Tables:
  1. 1 × UPDATE `j25_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1490271524;s:18:\"session.timer.last\";i:1490271524;s:17:\"session.timer.now\";i:1490271524;s:24:\"session.client.forwarded\";s:14:\"54.157.226.227\";s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://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;s:1:\"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:13:\"session.token\";s:32:\"ac6f318a2ff9c6aab932332166df989a\";}', `time` = 1490271524
  2. 1 × SHOW TABLES LIKE "j25_virtuemart_configs
  3. 1 × INSERT INTO `j25_session` (`session_id`, `client_id`, `time`) VALUES ('i9esol14hg708ra8oe4klhl2f7', 0, 1490271524