0

SQL=SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias)!=0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROM t6roy_categories as c LEFT JOIN t6roy_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 t6roy_categories AS cat JOIN t6roy_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 `t6roy_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,5) AND c.published = 1 AND s.id=12 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

The Page you are looking for doesn't exist or an other error occurred. Go back, or head over to Página de inicio to choose a new direction.

Es posible que no pueda visitar esta página por:

  1. un marcador/favorito fuera de fecha
  2. un motor de búsqueda que tiene una lista fuera de fecha para este sitio
  3. una dirección mal escrita
  4. usted no tiene acceso a esta página
  5. El recurso solicitado no fue encontrado.
  6. Se produjo un error al procesar su solicitud.