Inicio

Ruta

Usted está aquí: Inicio

Lof Article Scroller Module

Reactivo limitante. Ejercicio resueltos paso a paso. Vamos... Read more

Campo Eléctrico - Ejercicios resueltos 2º Bachillerato Os... Read more

Equilibrio químico y solubilidad 2015 - Ejercicios resueltos selectividad química 2º Bachillerato Ejercicios... Read more

Ecuaciones logarítmicas. Resolución fácil en 5 pasos Buenas, ... Read more

Examen Selectividad Resuelto Matematicas CCSS Andalucía Junio 2014 - Opción A Os... Read more

Configuración Electrónica - ESO y BACHILLERATO Os... Read more

ITPSocialButtons

Twitter Slider Widget

Strict Standards: Non-static method modTwitterFollowerbox::getTwitterFollowerbox() should not be called statically in /web/htdocs/www.fiquimakcc.es/home/modules/mod_twitterslider/mod_twitterslider.php on line 14

Tweets by @fiquimakcc

Reactivo limitante. Ejercicio resueltos paso a paso.

Detalles: Categoría: Fisica y Quimica 1º Bachillerato

Vamos a resolver un problema típico de estequiometría en el que debamos identificar el reactivo limitante.

Veamos un ejemplo.

PROBLEMA:

Se introducen 13,5 gramos de aluminio en 500 ml de ácido sulfúrico 1,7 M. Sabiendo que uno de los productos es hidrógeno gaseoso, calcular:

a) La cantidad de reactivo que queda sin reaccionar.

b) El volumen de gas obtenido a 27ºC y 2 atm.

Este es un ejercicio típico en el que lo primero que debemos identificar es el reactivo limitante.

¿Como nos damos cuenta de esto?

Pues observando que nos dan dos cantidades de reactivos, 13,5 gramos de Aluminio y 500ml de disolución y no sabemos si están en la proporción adecuada (y se gastarán ambos) o hay más proporción de uno ( se gastará uno totalmente "limitante" y sobrará una cantidad del otro "exceso")

La forma más fácil de identificarlo es calcular los moles de los dos reactivos y dividir cada uno entre su coeficiente estequiométrico. El número que resulte menor nos indicará que ese compuesto es el limitante ya que estará en menor proporción.

Veámoslo en el problema:

Al hacer la división de los 0,5 moles de Aluminio entre 2 que es su coeficiente y de los 0,85 moles de ácido entre 3 que es su coeficiente obtenemos que el aluminio está en menor proporción y por tanto se gastará completo, siendo este el reactivo limitante.

IMPORTANTE: Una vez localizado el limitante, para los cálculos de proporcionalidad entre compuestos usaremos dicha cantidad, los 0,5 moles de Al, ya que el ácido no se gastará del todo.

Calculamos la cantidad de ácido que reacciona (se utilizará) y las cantidad de sobra.
Viendo la reacción ajustada tenemos que por cada 2 moles de aluminio, necesitamos 3 de ácido, por tanto, si de aluminio van a reaccionar 0,5 moles, de ácido reaccionarán x y sobrarán el resto.

Tendríamos terminado el apartado a.

El apartado b así como otros problemas de estequiometría los puedes consultar en el siguiente enlace.

Estequiometría - Ejercicios resueltos curso 14/15 - ENLACE

Más ejercicios en :

Ejercicios resueltos estequiometría paso a paso - ENLACE o ENLACE2

"Usamos adf.ly para mantener el dominio, esperar 5 segundos y pulsar en "saltar publicidad" arriba a la derecha"

Los ejercicios están resueltos paso a paso, de todas formas si os queda alguna duda o veis algún error mandadme un email o dejar un comentario abajo y actualizaré el archivo.

PD: Si te han sido útiles los ejercicios, colabora con nosotros y ayuda a que la web siga activa visitando a nuestros anunciantes. Muchas gracias.

Escribir un comentario

Ecuaciones logarítmicas. Resolución fácil en 5 pasos

Detalles: Categoría: Matemáticas 1º Bachillerato Ciencias

Buenas,

os dejo un vídeo en el que os enseño a resolver ecuaciones logarítmicas siguiendo 5 pasos muy fáciles si sabéis las propiedades de los logaritmos.

En este caso es una ecuación muy fácil, pero podamos aplicar el método a cualquier ecuación logarítmica. Espero que os sea de ayuda.

Escribir un comentario

Equilibrio químico y solubilidad 2015 - Ejercicios resueltos selectividad química 2º Bachillerato

Detalles: Categoría: Química 2º Bachillerato

Ejercicios resueltos selectividad química 2º Bachillerato sobre Equilibrio químico y solubilidad. Curso 2014/2015.

Os dejo los ejercicios que vamos resolviendo en case estos días sobre el tema indicado. Espero que os sean de ayuda.

Ejercicios resueltos sobre equilibrios homogéneos, heterogéneos y solubilidad. Reacciones de precipitación.

El documento se irá actualizando solo y se añadirán más ejercicios.

Equilibrio 2015 - Ejercicios resueltos 2º Bachillerato - DESCARGAR

Enlace a más ejercicios resueltos sobre equilibrio químico de años anteriores - WEB

ACTUALIZADA 10/03/2015

Los ejercicios están resueltos paso a paso, de todas formas si os queda alguna duda o veis algún error mandadme un email o dejar un comentario abajo y actualizaré el archivo.

PD: Si te han sido útiles los ejercicios, colabora con nosotros y ayuda a que la web siga activa visitando a nuestros anunciantes. Muchas gracias.

Escribir un comentario

Campo Eléctrico - Ejercicios resueltos 2º Bachillerato

Detalles: Categoría: Física 2º Bachillerato

Os dejo los ejercicios resueltos en clase sobre CAMPO ELÉCTRICO. Son ejercicios de 2º de bachillerato muchos de ellos sacados de exámenes de selectividad. Espero que os sean de ayuda.

Campo Eléctrico - Ejercicios resueltos 2013 - ENLACE

Los ejercicios están resueltos paso a paso, de todas formas si os queda alguna duda o veis algún error mandadme un email o dejar un comentario abajo y actualizaré el archivo.

PD: Si te han sido útiles los ejercicios, colabora con nosotros y ayuda a que la web siga activa visitando a nuestros anunciantes. Muchas gracias.

Escribir un comentario

Videos de Ciencia

Detalles: Categoría: Astronomía

¿Qué es la relatividad?

Escribir un comentario

Más Artículos...

Página 1 de 16

Iniciar
Previo
1
2
3
4
5
6
7
8
9
10
Siguiente
Fin

Este Sitio

Formulario de acceso

Lista de Recursos

Ultimas Noticias

Contenido Mas Leido

Quien esta en Linea

Contador de Visitas

Strict Standards: Only variables should be assigned by reference in /web/htdocs/www.fiquimakcc.es/home/modules/mod_vvisit_counter/mod_vvisit_counter.php on line 99 Strict Standards: Only variables should be assigned by reference in /web/htdocs/www.fiquimakcc.es/home/modules/mod_vvisit_counter/mod_vvisit_counter.php on line 103 Strict Standards: mktime(): You should be using the time() function instead in /web/htdocs/www.fiquimakcc.es/home/plugins/system/vvisit_counter/helper/vvisit_counter_timestart.php on line 28 Strict Standards: Only variables should be assigned by reference in /web/htdocs/www.fiquimakcc.es/home/modules/mod_vvisit_counter/mod_vvisit_counter.php on line 124 Strict Standards: Only variables should be assigned by reference in /web/htdocs/www.fiquimakcc.es/home/plugins/system/vvisit_counter/helper/vvisit_counter.php on line 107 Strict Standards: Only variables should be assigned by reference in /web/htdocs/www.fiquimakcc.es/home/plugins/system/vvisit_counter/helper/vvisit_counter.php on line 107 Strict Standards: Only variables should be assigned by reference in /web/htdocs/www.fiquimakcc.es/home/plugins/system/vvisit_counter/helper/vvisit_counter.php on line 107 Strict Standards: Only variables should be assigned by reference in /web/htdocs/www.fiquimakcc.es/home/plugins/system/vvisit_counter/helper/vvisit_counter.php on line 107 Strict Standards: Only variables should be assigned by reference in /web/htdocs/www.fiquimakcc.es/home/plugins/system/vvisit_counter/helper/vvisit_counter.php on line 107 Strict Standards: Only variables should be assigned by reference in /web/htdocs/www.fiquimakcc.es/home/plugins/system/vvisit_counter/helper/vvisit_counter.php on line 107 Strict Standards: Only variables should be assigned by reference in /web/htdocs/www.fiquimakcc.es/home/plugins/system/vvisit_counter/helper/vvisit_counter.php on line 107

1104358

Hoy

Ayer

Esta semana

Semana pasada

Este mes

Mes pasado

Total

217

902486

3140

4190

1104358

Your IP: 34.204.168.57

Server Time: 2019-10-24 00:31:32

Visitors Counter

Webs Recomendas

Consola de Joomla! Debug

Application 0.000 seconds (+0.000); 0.71 MB (+0.706) - afterLoad

Application 0.077 seconds (+0.077); 3.51 MB (+2.808) - afterInitialise

Application 0.127 seconds (+0.050); 6.50 MB (+2.989) - afterRoute

Application 0.286 seconds (+0.159); 9.47 MB (+2.968) - afterDispatch

Application 0.295 seconds (+0.009); 9.70 MB (+0.225) - beforeRenderModule mod_phocagoogleadsense (Phoca - Google AdSense Easy footer)

Application 0.298 seconds (+0.003); 9.72 MB (+0.027) - afterRenderModule mod_phocagoogleadsense (Phoca - Google AdSense Easy footer)

Application 0.298 seconds (+0.000); 9.72 MB (-0.003) - beforeRenderModule mod_articles_latest (Ultimas Noticias)

Application 0.387 seconds (+0.089); 9.93 MB (+0.212) - afterRenderModule mod_articles_latest (Ultimas Noticias)

Application 0.387 seconds (+0.000); 9.79 MB (-0.144) - beforeRenderModule mod_articles_popular (Contenido Mas Leido)

Application 0.417 seconds (+0.030); 10.05 MB (+0.257) - afterRenderModule mod_articles_popular (Contenido Mas Leido)

Application 0.417 seconds (+0.000); 9.82 MB (-0.226) - beforeRenderModule mod_phocagoogleadsense (Phoca - Google AdSense Easy USADO DCHA)

Application 0.418 seconds (+0.001); 9.83 MB (+0.006) - afterRenderModule mod_phocagoogleadsense (Phoca - Google AdSense Easy USADO DCHA)

Application 0.418 seconds (+0.000); 9.82 MB (-0.005) - beforeRenderModule mod_whosonline (Quien esta en Linea)

Application 0.442 seconds (+0.025); 10.20 MB (+0.376) - afterRenderModule mod_whosonline (Quien esta en Linea)

Application 0.443 seconds (+0.000); 10.20 MB (+0.000) - beforeRenderModule mod_vvisit_counter (Contador de Visitas)

Application 0.454 seconds (+0.011); 10.28 MB (+0.087) - afterRenderModule mod_vvisit_counter (Contador de Visitas)

Application 0.454 seconds (+0.000); 10.26 MB (-0.020) - beforeRenderModule mod_menu (Webs Recomendas)

Application 0.462 seconds (+0.009); 10.34 MB (+0.075) - afterRenderModule mod_menu (Webs Recomendas)

Application 0.463 seconds (+0.000); 10.33 MB (-0.006) - beforeRenderModule mod_menu (Lista de Recursos)

Application 0.476 seconds (+0.013); 10.37 MB (+0.032) - afterRenderModule mod_menu (Lista de Recursos)

Application 0.476 seconds (+0.000); 10.36 MB (-0.006) - beforeRenderModule mod_phocagoogleadsense (Phoca - Google AdSense Easy USADO1)

Application 0.477 seconds (+0.001); 10.37 MB (+0.006) - afterRenderModule mod_phocagoogleadsense (Phoca - Google AdSense Easy USADO1)

Application 0.477 seconds (+0.000); 10.36 MB (-0.003) - beforeRenderModule mod_menu (Este Sitio)

Application 0.486 seconds (+0.009); 10.39 MB (+0.030) - afterRenderModule mod_menu (Este Sitio)

Application 0.486 seconds (+0.000); 10.38 MB (-0.008) - beforeRenderModule mod_login (Formulario de acceso)

Application 0.493 seconds (+0.007); 10.41 MB (+0.030) - afterRenderModule mod_login (Formulario de acceso)

Application 0.493 seconds (+0.000); 10.41 MB (+0.000) - beforeRenderModule mod_breadcrumbs (Ruta)

Application 0.500 seconds (+0.007); 10.48 MB (+0.064) - afterRenderModule mod_breadcrumbs (Ruta)

Application 0.501 seconds (+0.000); 10.48 MB (+0.002) - beforeRenderModule mod_lofarticlescroller (Lof Article Scroller Module)

Application 0.554 seconds (+0.053); 11.09 MB (+0.610) - afterRenderModule mod_lofarticlescroller (Lof Article Scroller Module)

Application 0.554 seconds (+0.000); 10.88 MB (-0.209) - beforeRenderModule mod_itpsocialbuttons (ITPSocialButtons)

Application 0.560 seconds (+0.005); 10.94 MB (+0.061) - afterRenderModule mod_itpsocialbuttons (ITPSocialButtons)

Application 0.560 seconds (+0.000); 10.93 MB (-0.010) - beforeRenderModule mod_twitterslider (Twitter Slider Widget)

Application 0.561 seconds (+0.002); 10.95 MB (+0.017) - afterRenderModule mod_twitterslider (Twitter Slider Widget)

Application 0.562 seconds (+0.000); 10.95 MB (+0.001) - beforeRenderModule mod_search (Buscar)

Application 0.566 seconds (+0.004); 10.97 MB (+0.020) - afterRenderModule mod_search (Buscar)

Application 0.573 seconds (+0.008); 11.06 MB (+0.086) - afterRender

49 Registro Consultas

SELECT `data` FROM `cmp98_session` WHERE `session_id` = '8m2h4otntigmmm4a33lkls0166'
DELETE FROM `cmp98_session` WHERE `time` < '1571876191'
SELECT `session_id` FROM `cmp98_session` WHERE `session_id` = '8m2h4otntigmmm4a33lkls0166' LIMIT 0, 1
INSERT INTO `cmp98_session` (`session_id`, `client_id`, `time`) VALUES ('8m2h4otntigmmm4a33lkls0166', 0, '1571877091')
SELECT extension_id AS id, element AS "option", params, enabled FROM cmp98_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT b.id FROM cmp98_usergroups AS a LEFT JOIN cmp98_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1
SELECT id, rules FROM `cmp98_viewlevels`
SELECT folder AS type, element AS name, params FROM cmp98_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1) ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled FROM cmp98_extensions WHERE `type` = 'component' AND `element` = 'com_languages'
SELECT time FROM cmp98_vvisit_counter USE INDEX(time) ORDER BY time DESC LIMIT 1;
UPDATE cmp98_vvisit_counter SET visits=visits+1, guests=guests+1 WHERE time=1571877900;
SELECT m.id, m.menutype, m.title, m.alias, m.note, 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 cmp98_menu AS m LEFT JOIN cmp98_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
SELECT * FROM cmp98_jcomments_settings
SELECT id, home, template, s.params FROM cmp98_template_styles as s LEFT JOIN cmp98_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
SELECT extension_id AS id, element AS "option", params, enabled FROM cmp98_extensions WHERE `type` = 'component' AND `element` = 'com_content'
SELECT * FROM cmp98_languages WHERE published=1 ORDER BY ordering ASC
SELECT a.rules FROM cmp98_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
SELECT b.rules FROM cmp98_assets AS a LEFT JOIN cmp98_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content' OR a.parent_id=0) GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
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.images, a.urls, 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, 0) 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 cmp98_content AS a LEFT JOIN cmp98_categories AS c ON c.id = a.catid LEFT JOIN cmp98_users AS ua ON ua.id = a.created_by LEFT JOIN cmp98_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM cmp98_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN cmp98_categories as parent ON parent.id = c.parent_id LEFT JOIN cmp98_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM cmp98_categories AS cat JOIN cmp98_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 INNER JOIN cmp98_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND 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 <= '2019-10-24 00:31:31') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-24 00:31:31') GROUP BY 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, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY fp.ordering, a.created DESC LIMIT 0, 10
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.images, a.urls, 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, 0) 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 cmp98_content AS a LEFT JOIN cmp98_categories AS c ON c.id = a.catid LEFT JOIN cmp98_users AS ua ON ua.id = a.created_by LEFT JOIN cmp98_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM cmp98_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN cmp98_categories as parent ON parent.id = c.parent_id LEFT JOIN cmp98_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM cmp98_categories AS cat JOIN cmp98_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 INNER JOIN cmp98_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND 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 <= '2019-10-24 00:31:31') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-24 00:31:31') GROUP BY 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, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY fp.ordering, a.created DESC
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM cmp98_categories as c LEFT JOIN cmp98_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 cmp98_categories AS cat JOIN cmp98_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=87 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT count(*) FROM cmp98_jcomments AS c WHERE c.object_id = 236 AND c.object_group = 'com_content' AND c.published = 1
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM cmp98_categories as c LEFT JOIN cmp98_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 cmp98_categories AS cat JOIN cmp98_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=102 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT count(*) FROM cmp98_jcomments AS c WHERE c.object_id = 239 AND c.object_group = 'com_content' AND c.published = 1
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM cmp98_categories as c LEFT JOIN cmp98_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 cmp98_categories AS cat JOIN cmp98_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=90 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT count(*) FROM cmp98_jcomments AS c WHERE c.object_id = 237 AND c.object_group = 'com_content' AND c.published = 1
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM cmp98_categories as c LEFT JOIN cmp98_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 cmp98_categories AS cat JOIN cmp98_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=81 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT count(*) FROM cmp98_jcomments AS c WHERE c.object_id = 182 AND c.object_group = 'com_content' AND c.published = 1
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM cmp98_categories as c LEFT JOIN cmp98_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 cmp98_categories AS cat JOIN cmp98_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=88 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT count(*) FROM cmp98_jcomments AS c WHERE c.object_id = 235 AND c.object_group = 'com_content' AND c.published = 1
SELECT count(*) FROM cmp98_jcomments AS c WHERE c.object_id = 234 AND c.object_group = 'com_content' AND c.published = 1
SELECT count(*) FROM cmp98_jcomments AS c WHERE c.object_id = 233 AND c.object_group = 'com_content' AND c.published = 1
SELECT count(*) FROM cmp98_jcomments AS c WHERE c.object_id = 232 AND c.object_group = 'com_content' AND c.published = 1
SELECT count(*) FROM cmp98_jcomments AS c WHERE c.object_id = 231 AND c.object_group = 'com_content' AND c.published = 1
SELECT count(*) FROM cmp98_jcomments AS c WHERE c.object_id = 229 AND c.object_group = 'com_content' AND c.published = 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM cmp98_modules AS m LEFT JOIN cmp98_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN cmp98_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 <= '2019-10-24 00:31:31') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-10-24 00:31:31') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 435 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
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.images, a.urls, 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, 0) 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 cmp98_content AS a LEFT JOIN cmp98_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN cmp98_categories AS c ON c.id = a.catid LEFT JOIN cmp98_users AS ua ON ua.id = a.created_by LEFT JOIN cmp98_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM cmp98_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN cmp98_categories as parent ON parent.id = c.parent_id LEFT JOIN cmp98_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM cmp98_categories AS cat JOIN cmp98_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 c.access IN (1,1) AND 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 <= '2019-10-24 00:31:31') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-24 00:31:31') GROUP BY 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, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY a.created DESC LIMIT 0, 5
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM cmp98_categories as c LEFT JOIN cmp98_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 cmp98_categories AS cat JOIN cmp98_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=111 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM cmp98_categories as c LEFT JOIN cmp98_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 cmp98_categories AS cat JOIN cmp98_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 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
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.images, a.urls, 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, 0) 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 cmp98_content AS a LEFT JOIN cmp98_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN cmp98_categories AS c ON c.id = a.catid LEFT JOIN cmp98_users AS ua ON ua.id = a.created_by LEFT JOIN cmp98_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM cmp98_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN cmp98_categories as parent ON parent.id = c.parent_id LEFT JOIN cmp98_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM cmp98_categories AS cat JOIN cmp98_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 c.access IN (1,1) AND 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 <= '2019-10-24 00:31:31') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-24 00:31:31') GROUP BY 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, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY a.hits DESC LIMIT 0, 8
SELECT guest, usertype, client_id FROM cmp98_session WHERE client_id = 0
SHOW FULL COLUMNS FROM `cmp98_assets`
SELECT id FROM cmp98_assets WHERE parent_id = 0
SELECT b.rules FROM cmp98_assets AS a LEFT JOIN cmp98_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.id = 1 OR a.parent_id=0) GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT a.username, a.time, a.userid, a.usertype, a.client_id FROM cmp98_session AS a WHERE a.userid != 0 AND a.client_id = 0 GROUP BY a.userid
SELECT SUM(visits) AS visits FROM cmp98_vvisit_counter WHERE '1=1' AND time > 1571875200
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.images, 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.images, 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, 0) 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 cmp98_content AS a LEFT JOIN cmp98_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN cmp98_categories AS c ON c.id = a.catid LEFT JOIN cmp98_users AS ua ON ua.id = a.created_by LEFT JOIN cmp98_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM cmp98_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN cmp98_categories as parent ON parent.id = c.parent_id LEFT JOIN cmp98_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM cmp98_categories AS cat JOIN cmp98_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 c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.featured = 1 AND a.catid IN (9,87,88,90,102,104,105,106) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-10-24 00:31:31') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-24 00:31:31') GROUP BY 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, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY a.ordering asc LIMIT 0, 6
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM cmp98_categories as c LEFT JOIN cmp98_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 cmp98_categories AS cat JOIN cmp98_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=106 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
UPDATE `cmp98_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1571877091;s:18:\"session.timer.last\";i:1571877091;s:17:\"session.timer.now\";i:1571877091;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{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:13:\"lastResetTime\";N;s:10:\"resetCount\";N;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:13:\"session.token\";s:32:\"4434d6abb59745add4764d2f3e2f53a0\";}' , `time` = '1571877092' WHERE `session_id` = '8m2h4otntigmmm4a33lkls0166'

28 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

10 × SELECT count(*) FROM cmp98_jcomments AS c
8 × SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM cmp98_categories as c LEFT JOIN cmp98_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 cmp98_categories AS cat JOIN cmp98_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
3 × SELECT extension_id AS id, element AS "option", params, enabled FROM cmp98_extensions
2 × SELECT b.rules FROM cmp98_assets AS a LEFT JOIN cmp98_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
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.images, a.urls, 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, 0) 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 cmp98_content AS a LEFT JOIN cmp98_categories AS c ON c.id = a.catid LEFT JOIN cmp98_users AS ua ON ua.id = a.created_by LEFT JOIN cmp98_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM cmp98_contact_details AS contact
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.images, a.urls, 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, 0) 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 cmp98_content AS a LEFT JOIN cmp98_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN cmp98_categories AS c ON c.id = a.catid LEFT JOIN cmp98_users AS ua ON ua.id = a.created_by LEFT JOIN cmp98_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM cmp98_contact_details AS contact
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM cmp98_modules AS m LEFT JOIN cmp98_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN cmp98_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT id FROM cmp98_assets
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.images, 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.images, 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, 0) 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 cmp98_content AS a LEFT JOIN cmp98_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN cmp98_categories AS c ON c.id = a.catid LEFT JOIN cmp98_users AS ua ON ua.id = a.created_by LEFT JOIN cmp98_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM cmp98_contact_details AS contact
1 × SELECT SUM(visits) AS visits FROM cmp98_vvisit_counter
1 × SELECT a.username, a.time, a.userid, a.usertype, a.client_id FROM cmp98_session AS a
1 × SELECT guest, usertype, client_id FROM cmp98_session
1 × SELECT a.rules FROM cmp98_assets AS a
1 × SELECT folder AS type, element AS name, params FROM cmp98_extensions
1 × SELECT id, rules FROM `cmp98_viewlevels
1 × SELECT b.id FROM cmp98_usergroups AS a LEFT JOIN cmp98_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `session_id` FROM `cmp98_session`
1 × SELECT time FROM cmp98_vvisit_counter USE INDEX(time)
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, 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 cmp98_menu AS m LEFT JOIN cmp98_extensions AS e ON m.component_id = e.extension_id
1 × SELECT * FROM cmp98_languages
1 × SELECT id, home, template, s.params FROM cmp98_template_styles as s LEFT JOIN cmp98_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT * FROM cmp98_jcomments_setting
1 × SELECT `data` FROM `cmp98_session`

OTRAS Tablas:

1 × UPDATE `cmp98_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1571877091;s:18:\"session.timer.last\";i:1571877091;s:17:\"session.timer.now\";i:1571877091;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{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:13:\"lastResetTime\";N;s:10:\"resetCount\";N;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:13:\"session.token\";s:32:\"4434d6abb59745add4764d2f3e2f53a0\";}' , `time` = '1571877092'
1 × SHOW FULL COLUMNS FROM `cmp98_assets
1 × UPDATE cmp98_vvisit_counter SET visits=visits+1, guests=guests+1
1 × INSERT INTO `cmp98_session` (`session_id`, `client_id`, `time`) VALUES ('8m2h4otntigmmm4a33lkls0166', 0, '1571877091'
1 × DELETE FROM `cmp98_session`

Buscar

FIQUIMAKCC

Reactivo limitante. Ejercicio resueltos paso a paso.

Ecuaciones logarítmicas. Resolución fácil en 5 pasos

Equilibrio químico y solubilidad 2015 - Ejercicios resueltos selectividad química 2º Bachillerato

Campo Eléctrico - Ejercicios resueltos 2º Bachillerato

Videos de Ciencia

Más Artículos...

Este Sitio

Formulario de acceso

Lista de Recursos

Ultimas Noticias

Contenido Mas Leido

Quien esta en Linea

Contador de Visitas

Webs Recomendas

Consola de Joomla! Debug

Sesión

__default

user

Información de Perfil

Uso de Memoria

Registro Database

49 Registro Consultas

28 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

OTRAS Tablas: