6 years ago
Topic

It's showing up before my list how do I disappear? Help


SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS parent,t0.author_id AS author,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias 

FROM `#__cck_core` AS t0
LEFT JOIN `#__content` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t1.state = 1
AND t1.access IN (1,1,2,3,6)
AND ( t1.publish_up = '0000-00-00 00:00:00' OR t1.publish_up <= '2018-01-08 13:38' )
AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2018-01-08 13:38' )
AND t0.storage_location = "joomla_article"
ORDER BY t1.created DESC
LIMIT 5

SELECT COUNT(t0.id)
FROM `#__cck_core` AS t0
LEFT JOIN `#__content` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t1.state = 1
AND t1.access IN (1,1,2,3,6)
AND ( t1.publish_up = '0000-00-00 00:00:00' OR t1.publish_up <= '2018-01-08 13:38' )
AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2018-01-08 13:38' )
AND t0.storage_location = "joomla_article"

0.004 seconds (0.004); 13.02 MB (13.016) - afterSearch [Cache=OFF] = 11 results.
0.030 seconds (0.026); 14.54 MB (1.521) - afterRender [Cache=OFF]

Help Help Help Help Help

Get a VIP membership
4229 Posts
Kadministrator
6 years ago
1
Level 1

This is debug information, you can turn this off in list settings.

6 years ago
0
Level 2

Thank you, solved!

Get a VIP membership